E-DB01: Mastering Microsoft SQL Server 2014 Database 

This 5-days instructor-led course provides students with the knowledge and skills to master a Microsoft SQL Server 2014 database implementation.


After completing this course, students will be able to:

·         Configure SQL Server databases and storage.

·         Monitor SQL Server.

·         Trace SQL Server activity.

·         Perform ongoing database maintenance.

·         Explain core indexing concepts.

·         Describe single-column and composite indexes.

·         Describe the different table structures in SQL Server.

·         Implement clustered indexes.

·         Implement nonclustered indexes.

·         Explain the core concepts related to the use of execution plans

·         Describe the role of the most common execution plan elements

·         Work with execution plans

·         Design effective nonclustered indexes

·         Explain how to monitor performance and create a performance baseline

·         Create columnstore indexes.

·         Describe the considerations for updating tables with non-clustered columnstore indexes.

·         Design and implement memory-optimized tables.

·         Create native stored procedures.

·         Describe the core concepts and options for implementing high availability in SQL Server 2014.

·         Describe how to implement high availability for individual databases by using log shipping.

·         Describe the key benefits and features of Windows Server Failover Clustering.

·         Describe how to use SQL Server AlwaysOn Failover Cluster Instances to maintain high availability for SQL Server

·         Describe the fundamental concepts and terminology for AlwaysOn Availability Groups.

·         Explain how work with AlwaysOn Availability Groups.

·         Describe SQL Server replication.