Featured course: 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
instances.

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

· Explain how work with AlwaysOn Availability Groups.

· Describe SQL Server replication.