Microsoft SQL Development

Introduction to Microsoft SQL Server 2014                          

Introduction to T-SQL Querying                

Writing SELECT Queries                

Querying Multiple Tables                            

Sorting and Filtering Data                            

Working with SQL Server 2014 Data Types                           

Using DML to Modify Data                          

Using Built-In Functions               

Grouping and Aggregating Data                

Using Subqueries                            

Using Table Expressions                               

Using Set Operators                      

Using Window Ranking, Offset, and Aggregate Functions                             

Pivoting and Grouping Sets                        

Querying data with Stored Procedures                 

Programming with T-SQL                             

Implementing Error Handling                     

Implementing Transactions                        

Appendix 1: Improving Query Performance                        

Appendix 2: Querying SQL Server Metadata