Uploaded July 2026 | Updated September 2026, 3 weeks ago
DP-800 is not just about writing SQL. It’s about delivering database solutions that are secure, fast, and deployable in modern engineering environments. In this session, we’ll focus on the engineering practices that turn your database work into production-ready solutions.
0:00 Welcome & Housekeeping
1:18 Speaker Introductions
3:05 Data Days, Certification Vouchers & Study Groups
6:02 SQL AI Promptathon & Community Opportunities
8:48 Moderators & Live Chat Support
10:15 DP-800 Exam Overview
13:06 Module 1: Data Security & Compliance
13:46 Encryption Strategies in SQL
18:58 Encryption Layers: TDE, Column-Level & Always Encrypted
21:40 Dynamic Data Masking & Row-Level Security
25:31 Secure Access & Object-Level Permissions
28:52 Auditing & Compliance
31:41 Choosing the Right Security Control
34:41 Module 2: Database Performance Optimization
35:14 Azure SQL Service Tiers & Pricing Models
37:57 Isolation Levels & Concurrency
41:10 Execution Plans & Dynamic Management Views
44:01 Query Store & Performance Insights
45:32 Blocking & Deadlocks
48:08 Module 3: CI/CD with SQL Database Projects
48:46 DACPACs, Source Control & Schema Drift
52:02 GitHub Actions, Azure DevOps & Automated Testing
53:10 Data API Builder & Integrations
55:28 Change Tracking, CDC & Event-Driven Patterns
57:25 Key Takeaways & Exam Tips
58:43 DP-800 Study Resources & Practice Assessment
1:00:49 Session Wrap-Up
1:01:43 Feedback Survey & Closing Remarks
[eventID:27382]
DP-800 is not just about writing SQL. It’s about delivering database solutions that are secure, fast, and deployable in modern engineering environments. In this session, we’ll focus on the engineering practices that turn your database work into production-ready solutions.
0:00 Welcome & Housekeeping
1:18 Speaker Introductions
3:05 Data Days, Certification Vouchers & Study Groups
6:02 SQL AI Promptathon & Community Opportunities
8:48 Moderators & Live Chat Support
10:15 DP-800 Exam Overview
13:06 Module 1: Data Security & Compliance
13:46 Encryption Strategies in SQL
18:58 Encryption Layers: TDE, Column-Level & Always Encrypted
21:40 Dynamic Data Masking & Row-Level Security
25:31 Secure Access & Object-Level Permissions
28:52 Auditing & Compliance
31:41 Choosing the Right Security Control
34:41 Module 2: Database Performance Optimization
35:14 Azure SQL Service Tiers & Pricing Models
37:57 Isolation Levels & Concurrency
41:10 Execution Plans & Dynamic Management Views
44:01 Query Store & Performance Insights
45:32 Blocking & Deadlocks
48:08 Module 3: CI/CD with SQL Database Projects
48:46 DACPACs, Source Control & Schema Drift
52:02 GitHub Actions, Azure DevOps & Automated Testing
53:10 Data API Builder & Integrations
55:28 Change Tracking, CDC & Event-Driven Patterns
57:25 Key Takeaways & Exam Tips
58:43 DP-800 Study Resources & Practice Assessment
1:00:49 Session Wrap-Up
1:01:43 Feedback Survey & Closing Remarks
[eventID:27382]
