Skip to Main Content
Beginning T-SQL
book

Beginning T-SQL

by Kathi Kellenberger, Scott Shaw
August 2014
Beginner content levelBeginner
496 pages
12h 26m
English
Apress
Content preview from Beginning T-SQL

CHAPTER 11

image

Writing Advanced Queries

In Chapter 10 you learned how to manipulate data. In this chapter you will learn some advanced query techniques. For example, you will learn more about common table expressions (CTEs), how to write a pivot query, and more. As a beginning T-SQL developer, you may or may not need this information right away. This chapter doesn’t contain any exercises, but I encourage you to experiment and come up with your own examples for any of the features that you are interested in. Consider the information in this chapter as a head start in becoming an expert T-SQL developer.

Advanced CTE Queries

In Chapter 6 you learned ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

T-SQL Fundamentals, 4th Edition

T-SQL Fundamentals, 4th Edition

Itzik Ben-Gan
Learning SQL

Learning SQL

Ben Forta

Publisher Resources

ISBN: 9781484200469Purchase book