This module is used to introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts.
This modules describes the design and implementation of tables. (Note: partitioned tables are not covered).
This module describes more advanced table designs.
This module describes the design and implementation of constraints.
This module describes the concept of an index and discusses selectivity, density and statistics. It covers appropriate data type choices and choices around composite index structures.
This module includes covering indexes and the INCLUDE clause, hints, padding / fillfactor, statistics. It also execution plans and the DTE Lessons.
This module introduces Columnstore indexes.
This module describes the design and implementation of views.
This module describes the design and implementation of stored procedures.
This module describes the design and implementation of functions, both scalar and table-valued. (Also discusses where they can lead to performance issues).
This module describes the design and implementation of triggers.
This module covers the creation of in-memory tables and native stored procedures. Furthermore, advantages of in-memory tables are discussed, for example the removal of transaction blocking.
This module describes the implementation of and target use-cases for SQL CLR integration.
This module covers the XML data type, schema collections, typed and un-typed columns and appropriate use cases for XML in SQL Server.
This module describes spatial data and how this data can be implemented within SQL Server.
This module covers full text indexes and queries.
Curs Updating Your Skills to SQL Server 2016 – Curs 10986
Curs 10990 Analyzing Data with SQL Server Reporting Services
Curs 20761 Querying Data with Transact-SQL
Curs 20764 Administering a SQL Database Infrastructure
Curs 20765 Provisioning SQL Databases
Curs 20767 Implementing a SQL Data Warehouse
Curs 55170 Writing Reports with Report Designer and SSRS 2016 Level 2
Curs 55069 PowerShell for SQL Server Administrators