If you want to get information about the Microsoft SQL Server Training & Certification as well as Topics covered in Advanced SQL Server Training, then here I am telling you about it, as you want.



Microsoft SQL Server Technical Training
20461 Querying Microsoft SQL Server®

10774 Querying Microsoft SQL Server 2012

10775 Administering Microsoft SQL Server 2012 Databases

10776 Developing Microsoft SQL Server 2012 Databases

10777 Implementing a Data Warehouse with Microsoft SQL Server 2012

10778 Implementing Data Models and Reports with Microsoft SQL Server 2012

20462 Administering Microsoft® SQL Server® Databases

20463 Implementing a Data Warehouse with Microsoft® SQL Server®

20464 Developing Microsoft® SQL Server® Databases

20465 Designing a Data Solution with Microsoft SQL Server

20466 Implementing Data Models and Reports with Microsoft® SQL Server®

20467 Designing Self-Service Business Intelligence and Big Data Solutions


SQL Server Internals — Advanced Training
Topics covered include:
SQL Server Architecture and Metadata

Concurrency Control: Locking, Blocking and Row Versioning

In-memory OLTP

Index and Query Tuning

Physical Storage Structures

Index Design and Tuning

Query Processing and Query Plans

Optimization and Recompilation


What You Will Learn
Optimize and tune queries

Create and alter stored procedures

Troubleshoot security

Write automation scripts

Troubleshoot performance issues

Implement reporting solutions by using SQL Server Reporting Services

Implementing multidimensional databases by using SQL Server Analysis Services

Creating tabular semantic data models for analysis by using SQL Server Analysis Services

Create visualizations of data by using Power View

Create data mining solutions by using SQL Server Analysis Services

Create and alter indexes

Maintain database integrity

Optimize indexing strategies

Create and alter tables

Maintain indexes

Create and modify constraints

Create and alter views

Create and alter user-defined functions (UDFs)

Control execution plans

Work with XML data

Implement full-text search