Designing and Developing SQL Database Solutions
Schema design, T-SQL programmability, JSON and development workflows for SQL Server, Azure SQL and SQL in Fabric, for the DP-800 exam.
MSAZ-300 12 lessons planned ▶ Video lessons coming soon
Offered by HSM University · Microsoft Certification Prep
Course content
- 1Designing tables, keys and constraintsComing
- 2Data types, including JSONComing
- 3Writing advanced T-SQLComing
- 4Views, functions and stored proceduresComing
- 5Transactions and error handlingComing
- 6Temporal and ledger tablesComing
- 7Graph and spatial dataComing
- 8SQL database projectsComing
- 9Source control and CI/CD for databasesComing
- 10GitHub Copilot for database developmentComing
- 11Calling REST endpoints from the databaseComing
- 12A development case studyComing
Requirements
Recommended background. You can start any course at any time.
Description
Schema design, T-SQL programmability, JSON and development workflows for SQL Server, Azure SQL and SQL in Fabric, for the DP-800 exam.