Developing SQL Databases M20762

Introduction to Database Development: Introduction to the SQL Server Platform - SQL Server Database Development Tasks

Designing and Implementing Tables: Designing Tables - Data Types - Working with Schemas - Creating and Altering Tables

Advanced Table Designs: Partitioning data - Compressing Data - Temporal Tables

Ensuring Data Integrity through Constraints: Enforcing data Integrity - Implementing Domain Integrity - Implementing Entity and Referential Integrity

Introduction to Indexes: Core Indexing Concepts - Data Types and Indexes - Single Column and Composite Indexes

Designing Optimized Index Strategies: Index Strategies - Managing Indexes - Execution Plans - The Database Engine Tuning Advisor - Query Store

Columnstore Indexes: Introduction to Columnstore indexes - Creating Columnstore indexes - Working Columnstore indexes

Designing and Implementing Views: Introduction to views - Creating and managing views - Performance considerations for views

Designing and Implementing Stored Procedures: Introduction to Stored Procedures - Working with Stored Procedures - Implementing Parameterized Stored Procedures - Controlling Execution Context

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

Responding to Data Manipulation via Triggers: Designing DML Triggers - Implementing DML Triggers - Advanced Trigger Concepts

Using In-Memory Tables: In-Memory tables - Native Stored Procedures

Implementing Managed Code in SQL Server: Introduction to SQL CLR Integration - Importing and Configuring Assemblies - Implementing SQL CLR Integration

Storing and Querying XML Data in SQL Server: Introduction to XML and XML Schemas - Storing XML Data and Schemas in SQL Server - Implementing the XML Data Type - Using the T-SQL FOR XML Statement - Getting Started with xQuery

Working with SQL Server Spatial Data: Introduction to Spatial Data - Working with SQL Server Spatial Data Types - Using Spatial Data in Applications

Storing and Querying Blobs and Text Documents in SQL Server: Considerations for BLOB Data - Working with FileStream - Using Full-Text Search

SQL Server Concurrency: Concurrency and Transactions - Locking Internals

Performance and Monitoring: Extended Events - Working with extended Events - Live Query Statistics - Optimize Database File Configuration - Metrics