Beginning T-SQL

• Author: Kathi Kellenberger, Scott Shaw
• Language: English
• Published: August 5, 2014
• Page: 480
• Size:  20 MB
• Format: pdf

 
What you’ll learn

• Grasp the fundamentals of relational theory, upon which T-SQL is based.
• Write accurate queries that are scalable and perform well.
• Combine set-based and procedural processing, obtaining the best from both worlds.
• Embed business logic in your database through stored procedures and functions.
• Simplify your work with new and advanced features, such as common table expressions and windowing functions.
• Enhance performance by knowing when to apply features such as temporary tables, and when not to.

Contents at a Glance

Chapter 1: Getting Started
Chapter 2: Exploring Database Concepts
Chapter 3: Writing Simple SELECT Queries
Chapter 4: Using Built-In Functions and Expressions
Chapter 5: Joining Tables
Chapter 6: Building on Subqueries, Common Table Expressions, and Unions
Chapter 7: Grouping and Summarizing Data
Chapter 8: Discovering Windowing Functions
Chapter 9: Advanced WHERE Clauses
Chapter 10: Manipulating Data
Chapter 11: Writing Advanced Queries
Chapter 12: Understanding T-SQL Programming Logic
Chapter 13: Managing Transactions
Chapter 14: Implementing Logic in the Database
Chapter 15: Working with XML
Chapter 16: Expanding on Data Type Concepts
Chapter 17: Running SQL Server in the Cloud
Chapter 18: Where to Go Next?