Category
Reviews
Available Time
Class Capacity
Module 1: Introduction to Database Development Introduction to the SQL Server Platform SQL Server Database Development Tasks Module 2: Designing and Implementing Tables Designing Tables Data Types Working with Schemas Creating and Altering Tables Partitioning Data Compressing Data Module 3: Ensuring Data Integrity through Constraints Enforcing Data Integrity Implementing Domain Integrity Implementing Entity and Referential Integrity Module 4: Introduction to Indexing Core Indexing Concepts Data Types and Indexes Single Column and Composite Indexes Module 5: Columnstore Indexes Introduction to Columnstore indexes Creating Columnstore Indexes Working with Columnstore Indexes Module 6: Designing and Implementing Views Introduction to Views Creating and Managing Views Performance Considerations for Views Module 7: Designing and Implementing Stored Procedures Introduction to Stored Procedures Working With Stored Procedures Implementing Parameterized Stored Procedures Controlling Execution Context Module 8: Designing and Implementing User-Defined Functions Overview of Functions Designing and Implementing Scalar Functions Designing and Implementing Table-Valued Functions Implementation Considerations for Functions Alternatives to Functions
Module 1: Introduction to Database Development
Module 2: Designing and Implementing Tables
Module 3: Ensuring Data Integrity through Constraints
Module 4: Introduction to Indexing
Module 5: Columnstore Indexes
Module 6: Designing and Implementing Views
Module 7: Designing and Implementing Stored Procedures
Module 8: Designing and Implementing User-Defined Functions