Mastering SQL Server 2016

Key Learning Areas

Mastering SQL Server 2016 for Developers provides the definitive hands-on training for SQL Server developers to master crucial SQL server programming fundamentals using top industry practices from an expert who knows SQL intimately. Learn to write robust code for maximum database performance, re-usability, and extensive application modularity. Find out about innovative programming techniques enabled by SQL Server 2016 and Visual Studio.

Students walk away with:

• Full comprehension of the architecture of SQL Server
• Detailed understanding of how SQL Server handles memory and threading
• Effective techniques to read query plans and assign indexes
• Skills to conquer the new data types and language features in T-SQL, like common table expressions, upserts, try/catch error handling, and windowing functions
• In-depth analysis of locking, blocking, transactions, and isolation
• Idea of how to take advantage of new SQL Server features like JSON support, temporal tables, and in-memory data structures

Course Outline

• Tooling & Hardware
• T-SQL Enhancements
• JSON Support
• Temporal Tables
• Monitoring
• Indexing & Tables
• Query Plans
• Concurrency, Locking, & Deadlocking
• In-Memory Tables and Database Capabilities
• Query Store
• Table Partitioning
• CLR
• Error Handling
• Encryption
• Geometry/Spatial Data
• Software Development Best Practices & ALM
• Stretch Database
• Row Level Security

Who Benefits

Learn T-SQL best practices, performance tuning and SQL Server engine internals with hands-on exercises. Understand how to work with geospatial, JSON, .NET, and Filestream data efficiently.  Understand how to solve problems and appropriate use new features of SQL Server 2016.

Prerequisites

Student who attend Mastering SQL Server 2016 for Developers should be familiar with basic programming techniques and have familiarity with .NET programming techniques.