Module 1: Introduction to Database Development
This module introduces database development and
the key tasks that a database developer would typically perform.
- Introduction to the SQL
Server Database Development Tasks
Lab : Introduction to Database Development
Module 2: Designing and Implementing Tables
This module explains how to design, create, and alter tables. Also it
focuses on working with schema.
and Altering Tables
Lab : Designing and Implementing Tables
Module 3: Ensuring Data Integrity through Constraints
This module explains how to enforce data integrity and implement domain
integrity to maintain high quality data. Also it focuses on implementing Entity
and Referential Integrity.
Entity and Referential Integrity
Lab : Ensuring Data Integrity through Constraints
Module 4: Introduction to Indexing
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.
Types and Indexes
Column and Composite Indexes
Lab : Implementing Indexes
Module 5: Designing Optimized Index Strategies
This module explains covering indexes and the INCLUDE clause as well as the use
of padding, hints and statistics. The module also covers the use of the
Database Engine Tuning Advisor and index-related dynamic management views to
assess indexing strategies.
with Execution Plans
- Using the
Lab : Designing Optimized Index Strategies
Module 6: Column store Indexes
This module explains columnstore indexes and how to use them to maximize the
performance and scalability of database applications.
to Columnstore indexes
with Columnstore Indexes
Lab : Using Columnstore Indexes
Module 7: Designing and Implementing Views
This module introduces Views, and explains how to create and manage Views. Also
it focuses on the performance consideration for Views.
and Managing Views
Considerations for Views
Lab : Designing and Implementing Views
Module 8: Designing and Implementing Stored Procedures
This module describes the potential advantages of the use of stored procedures
along with guidelines on creating them.
to Stored Procedures
With Stored Procedures
Parameterized Stored Procedures
Lab : Designing and Implementing Stored
Module 9: Designing and Implementing User-Defined Functions
This module explains how to design and implement user-defined functions that
enforce business rules or data consistency, and modify and maintain existing
functions written by other developers.
and Implementing Scalar Functions
and Implementing Table-Valued Functions
Considerations for Functions
Lab : Designing and Implementing User-Defined
Module 10: Responding to Data Manipulation via Triggers
This module, explains what DML triggers are and how they enforce data
integrity. Also it focusses on the different types of triggers available, and
how to define triggers in a database.
Lab : Responding to Data Manipulation via
Module 11: Using In-Memory Tables
This module covers the creation of in-memory tables and native stored
procedures and discusses the advantages and disadvantages of using in-memory
Lab : In-Memory OLTP
Module 12: Implementing Managed Code in SQL Server 2014
This module explains how to use CLR integrated code to create user-defined
database objects that are managed by the .NET Framework.
to SQL CLR Integration
and Configuring Assemblies
SQL CLR Integration
Lab : Implementing Managed Code in SQL Server
Module 13: Storing and Querying XML Data in SQL Server
This module introduces XML and shows how XML data can be stored within SQL
Server and then queried, including queries written in a language called XQuery.
to XML and XML Schemas
XML Data and Schemas in SQL Server
the XML Data Type
- Using the
T-SQL FOR XML Statement
Started with XQuery
Lab : Storing and Querying XML Data in SQL Server
Module 14: Working with SQL Server 2014 Spatial Data
This module introduces Spatial Data, and explains how to work with SQL Server
Spatial Data Types.
to Spatial Data
with SQL Server Spatial Data Types
Spatial Data in Applications
Lab : Working with SQL Server Spatial Data
Module 15: Incorporating Data Files into Databases
Data with Stored Procedures
FILESTREAM and File Tables
Lab : Implementing a Solution for Storing Data