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.
Objective
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
instances.
· Describe the fundamental concepts and terminology for AlwaysOn Availability Groups.
· Explain how work with AlwaysOn Availability Groups.
· Describe SQL Server replication.