Reduson.com

The Sneak Peek program provides early access to Pearson video products and is exclusively available to Safari subscribers. Content for titles in this program is made available throughout the development cycle, so products may not be complete, edited, or finalized, including video post-production editing.
Introduction
Module 1 Design and Implement Database Objects
Lesson 1: Design and Implement a Relational Database Schema
Lesson 2: Design and Implement Indexes
Lesson 3: Design and Implement Views
Lesson 4: Implement Columnstore Indexes

Module 2 Implement Programmability Objects
Lesson 5: Ensure Data Integrity with Constraints
Lesson 6: Create Stored Procedures
Lesson 7: Create Triggers and User-Defined Functions

Module 3 Manage Database Concurrency
Lesson 8: Implement Transactions
Lesson 9: Manage Isolation Levels
Lesson 10: Optimize Concurrency and Locking Behavior
Lesson 11: Implement Memory-Optimized Tables and Native Stored Procedures

Module 4 Optimize Database Objects and SQL Infrastructure
Lesson 12: Optimize Statistics and Indexes
Lesson 13: Analyze and Troubleshoot Query Plans
Lesson 14: Manage Performance for Database Instances
Lesson 15: Monitor and Trace SQL Server Baseline Performance Metrics

Screenshots



SCREENSHOTS: