← DP-800 study guideNext domain
Domain 1 – Design and Develop Database Solutions (35–40%)
8 lessons, each ending with a practice scenario
Log in to save your progress.
- ✓1.1 — Design Tables, Data Types and IndexesEvery other skill on this exam (security, performance, AI search) rests on well-typed tables with the right indexes. Questions describe a workload (OLTP lookups, analytics scans or both) and ask for the table and index design that fits.
- ✓1.2 — Specialized Tables: In-Memory, Temporal, External, Ledger and GraphSQL platforms offer table types for specific problems. The exam gives you a requirement (history, tamper evidence, extreme throughput, data in a lake, relationships) and expects the matching table type.
- ✓1.3 — JSON Columns, JSON Indexes and JSON FunctionsModern SQL platforms treat JSON as a first-class citizen: a native json data type, JSON indexes, and a full set of functions to build, query and shred JSON. DP-800 expects you to pick the right function for each task.
- ✓1.4 — Constraints, Sequences and PartitioningConstraints keep data correct, sequences generate numbers in a controlled way, and partitioning keeps very large tables manageable.
- ✓1.5 — Views, Functions, Stored Procedures, Triggers and Error HandlingProgrammability objects package logic in the database, close to the data, reusable, and securable with GRANT EXECUTE or GRANT SELECT. DP-800 also expects robust error handling.
- ✓1.6 — CTEs, Window Functions and Correlated QueriesAdvanced T-SQL on DP-800 means reading and writing common table expressions, window functions and correlated subqueries, and knowing which produces the requested result.
- ✓1.7 — Regular Expressions, Fuzzy String Matching and Graph QueriesNewer SQL platforms add native regular expressions and fuzzy matching, two big helps for cleansing text before it feeds search and AI. Graph tables add pattern matching across relationships.
- ✓1.8 — Design SQL Solutions with AI-Assisted ToolsDP-800 expects you to use GitHub Copilot and Copilot in Fabric productively and safely: enable them, steer them with instruction files, connect them to databases through the Model Context Protocol (MCP), and understand the security impact.
Domain recapQuick overview of all lessons
- Design tables, data types, rowstore and columnstore indexes
- Choose specialized tables: in-memory, temporal, external, ledger and graph
- Store and query JSON with the json type, JSON indexes and JSON functions
- Enforce integrity with constraints; use sequences and partitioning
- Write views, functions, stored procedures and triggers with solid error handling
- Write advanced T-SQL: CTEs, window functions, correlated queries, regular expressions, fuzzy matching and graph MATCH queries
- Use GitHub Copilot, Copilot in Fabric and MCP safely
Domain 2: Secure, optimize, and deploy database solutions →