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.

Visit

Setiabudi 2 Building. 6th Floor. Unit 606. Jl. HR. Rasuna Said. Kav. 62. Jakarta Selatan. Indonesia

 

Call

T: +62-21-521-0793
F: +62-21-521-0794

 

Contact         @ExecuTrain_JKT

sales@executrain.co.id

  • w-tbird

 2013 by ExecuTrain of Jakarta.