+49 (0) 30 5201 4923
info@orb-experts.com
Explore the capabilities of Microsoft SQL Server 2016. This course covers performance optimisation, database development, security, high availability, business intelligence, reporting, and hybrid cloud integration. Participants learn how to use SQL Server 2016 features to build secure, scalable, and high-performing data solutions.
You will learn how to use the most important SQL Server 2016 features across database administration, development, analytics, and reporting. You will explore tools for monitoring query performance, securing sensitive data, working with temporal and JSON data, supporting analytical workloads, and integrating SQL Server with Microsoft Azure.
• Monitor and optimise query performance using Query Store and enhanced caching
• Use In-Memory OLTP, temporal tables, table variables, and native JSON functionality
• Apply advanced security and high-availability features
• Support operational analytics with Columnstore indexes and DirectQuery
• Understand the enhanced capabilities of SSAS, SSIS, MDS, and Reporting Services
• Evaluate options for Azure backup, hybrid storage, and database migration
• Basic IT knowledge
• Familiarity with operating systems, hardware configurations, and basic network operations
• Basic knowledge of relational databases and SQL is recommended
• Previous experience with distributed systems is beneficial but not required
*We customize the course outline and content to your specific needs and relevant use cases.
Day 1: Performance, development, security, and availability
Module 1: SQL Server 2016 overview
• SQL Server 2016 architecture, editions, and core components
• Key improvements compared with previous SQL Server versions
• Overview of the Database Engine, Analysis Services, Integration Services, and Reporting Services
• Identifying suitable SQL Server features for different organisational requirements
Module 2: Performance management and Query Store
• Exploring enhanced database caching
• Understanding Query Store and query performance history
• Identifying inefficient execution plans and performance regressions
• Monitoring database resources and common performance bottlenecks
Module 3: In-memory, temporal, and JSON features
• Understanding In-Memory OLTP and memory-optimised tables
• Using memory-optimised table variables and temporary structures
• Working with system-versioned temporal tables
• Importing, querying, and exporting data with native JSON functionality
Module 4: Security and high availability
• Protecting sensitive information with Always Encrypted
• Implementing row-level security
• Configuring dynamic data masking
• Understanding enhanced Always On availability groups and failover options
Day 2: Analytics, reporting, and hybrid environments
Module 5: Operational analytics and Columnstore
• Combining transactional and analytical workloads
• Understanding clustered and non-clustered Columnstore indexes
• Using operational analytics with near real-time data
• Evaluating performance, storage, and workload considerations
Module 6: Business intelligence and R integration
• Exploring enhancements to SQL Server Analysis Services Tabular
• Using DirectQuery for near real-time analysis
• Overview of improvements to SQL Server Integration Services and Master Data Services
• Running R scripts and supporting analytical use cases within SQL Server
Module 7: Reporting Services and mobile reporting
• Introduction to the enhanced SQL Server Report Server
• Creating and managing paginated reports
• Understanding mobile reporting capabilities
• Designing reports with SQL Server Mobile Report Publisher
Module 8: Azure and hybrid SQL Server environments
• Understanding Stretch Database and hybrid data storage
• Configuring enhanced Backup to Azure
• Evaluating SQL Server migration options for Microsoft Azure
• Integrating SQL Server with Azure Data Factory and SQL Server Integration Services
Hands-on learning with expert instructors at your location for organizations.
Master new skills guided by experienced instructors from anywhere.
