Microsoft SQL Development 2016

Course 20762A Developing SQL Databases

Introduction to Database Development               

Designing and Implementing Tables                       

Advanced Table Designs                              

Ensuring Data Integrity through Constraints                        

Introduction to Indexes                               

Designing Optimized Index Strategies                   

Columnstore Indexes                   

Designing and Implementing Views                        

Designing and Implementing Stored Procedures                              

Designing and Implementing User-Defined Functions                    

Responding to Data Manipulation via Triggers                    

Using In-Memory Tables                             

Implementing Managed Code in SQL Server                       

Storing and Querying XML Data in SQL Server                    

Storing and Querying Spatial Data in SQL Server                

Storing and Querying BLOBs and Text Documents in SQL Server                

Course 20761B Querying Data with Transact-SQL

Introduction to Microsoft SQL Server 2016                          

Introduction to T-SQL Querying                

Writing SELECT Queries                

Querying Multiple Tables                            

Sorting and Filtering Data                            

Working with SQL Server 2016 Data Types                           

Using DML to Modify Data                          

Using Built-In Functions               

Grouping and Aggregating Data                

Using Subqueries                            

Using Table Expressions                               

Using Set Operators                      

Using Windows Ranking, Offset, and Aggregate Functions                           

Pivoting and Grouping Sets                        

Executing Stored Procedures                    

Programming with T-SQL                             

Implementing Error Handling                     

Implementing Transactions