Table of Contents

• Chapter 1 Design and implement database objects
• Skill 1.1: Design and implement a relational database schema
• Skill 1.2: Design and implement indexes
• Skill 1.3: Design and implement views
• Skill 1.4: Implement columnstore indexes
• Chapter 2 Implement programmability objects
• Skill 2.1 Ensure data integrity with constraints
• Skill 2.2 Create stored procedures
• Skill 2.3 Create triggers and user-defined functions
• Chapter 3 Manage database concurrency
• Skill 3.1: Implement transactions
• Skill 3.2: Manage isolation levels
• Skill 3.3: Optimize concurrency and locking behavior
• Skill 3.4: Implement memory-optimized tables and native stored procedures
• Chapter 4 Optimize database objects and SQL infrastructure
• Skill 4.1: Optimize statistics and indexes
• Skill 4.2: Analyze and troubleshoot query plans
• Skill 4.3: Manage performance for database instances
• Skill 4.4: Monitor and trace SQL Server baseline performance metrics

About the Author

Louis Davidson, Microsoft MVP (Data Platform), Senior Data Architect for CBN. Over 20 years of experience with SQL Server as an architect, developer, and writer.

Stacia Varga, Microsoft MVP (Data Platform) is a consultant, educator, mentor, and author specializing in data solutions since 1999. She provides consulting and custom education services through her company, Data Inspirations