Course Details
Course Outline
1 - Introduction to Database Development
Navigate the SQL Server PlatformPerform SQL Server Database Development Tasks
2 - Designing & Implementing Tables
Design, Create and Alter TablesUnderstand the Different Data TypesCreate and Manage SchemasLab: Designing and implementing tables
3 - Advanced Table Designs
Partition and Compress DataCreate Temporal TablesLab: Using advanced table designs
4 - Ensuring Data Integrity through Constraints
Enforce Data IntegrityAdd and Test ConstraintsImplement Data Domain, Entity and Referential IntegrityLab: Using Data Integrity Through Constraints
5 - Introduction to Indexes
Understand Core Indexing ConceptsLearn about Data and Index Types – Including Heaps, Clustered, Nonclustered, Single Column and Composite IndexesDevelop Heaps and Clustered and Covered IndexesLab: Implementing Indexes
6 - Designing Optimized Index Strategies
Learn About Index Strategies, Managing Indexes and Execution PlansWork with the Database Engine Tuning Advisor Use the Query Store to Identify and Fix QueriesLab: Optimizing Indexes
7 - Columnstore Indexes
Interpret, Create and Work with Columnstore IndexesBuild a Memory Optimized Columnstore TableLab: Using Columnstore Indexes
8 - Designing and Implementing Views
Create and Manage ViewsUnderstand Performance Considerations for ViewsSet up Standard and Updateable ViewsLab: Designing and Implementing Views
9 - Designing and Implementing Stored Procedures
Create and Work with Stored ProceduresBuild and Implement Parameterized Stored ProceduresControl Execution ContextLab: Designing and Implementing Stored Procedures
10 - Designing and Implementing User-Defined Functions
Understand the Types of Functions, Alternatives and Key Considerations for ImplementationDesign and Implement Scalar and Table-Valued FunctionsLab: Designing and Implementing User-Defined Functions
11 - Responding to Data Manipulation via Triggers
Design and Implement DML Triggers Learn about Advanced Trigger ConceptsCreate, Test and Improve Audit TriggersLab: Responding to Data Manipulation by Using Triggers
12 - Using In-Memory Tables
Work With Memory-Optimized TablesEstablish Natively Compiled Stored ProceduresLab: Using In-Memory Database Capabilities
13 - Implementing Managed Code in SQL Server
Learn about CLR Integration in SQL ServerImplement and Publish CLR AssembliesLab: Implementing Managed Code in SQL Server
14 - Storing and Querying XML Data in SQL Server
Understand XML and XML SchemasStore XML Data and Schemas in SQL ServerImplement the XML Data TypeUse the Transact-SQL FOR XML StatementGet Started with XQuery and Shredding XMLLab: Storing and Querying XML Data in SQL Server
15 - Storing and Querying Spatial Data in SQL Server
Store and Query Spatial DataWork with SQL Server Spatial Data TypesApply Spatial Data to ApplicationsLab: Working with SQL Server Spatial Data
16 - Storing and Querying BLOBs and Text Documents in SQL Server
Understand Considerations for Working with BLOB DataStore Unstructured Data Using FILESTREAMPerform Full-Text SearchesLab: Storing and Querying BLOBs and Text Documents in SQL Server
17 - SQL Server Concurrency
Learn how to Create Concurrency in SQL Server Execute Transactions and Lock Internals to Establish ConcurrencyLab: SQL Server Concurrency
18 - Performance and Monitoring
Work with Extended EventsView and Interpret Live Query Statistics and MetricsOptimize Database File ConfigurationLab: Monitoring, Tracing, and Baselining
Actual course outline may vary depending on offering center. Contact your sales representative for more information.