MCSA: SQL Server 2016 Database Development Training & Certification Course

20762C Developing SQL 2016 Databases

• Module 1: An Introduction to Database Development
• Module 2: Designing and Implementing Tables
• Module 3: Advanced Table Designs
• Module 4: Ensuring Data Integrity Through Constraints
• Module 5: Introduction to Indexes
• Module 6: Designing Optimized Index Strategies
• Module 7: Columnstore Indexes
• Module 8: Designing and Implementing Views
• Module 9: Designing and Implementing Stored Procedures
• Module 10: Designing and Implementing User-Defined Functions
• Module 11: Responding to Data Manipulation Via Triggers
• Module 12: Using In-Memory Tables
• Module 13: Implementing Managed Code in SQL Server
• Module 14: Storing and Querying XML Data in SQL Server
• Module 15: Storing and Querying Spatial Data in SQL Server
• Module 16: Storing and Querying BLOBs and Text Documents in SQL Server
• Module 17: SQL Server Concurrency
• Module 18: Performance and Monitoring

20761A Querying Data with Transact‐SQL

• Module 1: Introduction to Microsoft SQL Server 2016
• Module 2: Introduction to T‐SQL Querying
• Module 3: Writing SELECT Queries
• Module 4: Querying Multiple Tables
• Module 5: Sorting and Filtering Data
• Module 6: Working with SQL Server 2016 Data Types
• Module 7: Using DML to Modify Data
• Module 8: Using Built‐In Functions
• Module 9: Grouping and Aggregating Data
• Module 10: Using Subqueries
• Module 11: Using Set Operators

The candidates should have the working knowledge of Relational Databases and the basic knowledge of the Microsoft Windows operating system.