This intensive course will start with a quick overview of the SQL Server architecture, then dive right into using T-SQL. You will learn about batches and scripts, how to declare and use variables—including the inevitable data type conversions—and the rich supply of operators available. You will learn about some of the many built-in T-SQL functions for doing things like working with numbers and string manipulation, as well as global functions for getting state information. You will also learn about how to rank results using special functions and the OVER clause.
Introduction to Microsoft SQL Server
Introduction to T-SQL Querying
Writing SELECT Queries
Querying Multiple Tables
Sorting and Filtering Data
SQL Server Data Types
Using DML to Modify Data
Using Built-In Functions
Grouping and Aggregating Data
Using Subqueries
Using Table Expressions
Using Set Operators
Ranking and Aggregate Functions
Pivoting and Grouping Sets
Executing Stored Procedures
Programming with T-SQL
Error Handling
Transactions
This course assumes that you have at least a basic familiarity with the concept of relational databases and a basic understanding of what SQL Server is and the high-level tools in it, as well as how to create and manage objects using Management Studio. You should also have a basic understanding of how SQL Server implements security, including its authentication and authorization schemes, and how to assign permissions on securable objects to principals.
