Developing SQL Databases
This course is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability.
Exam 70-762 Developing SQL Databases
This course is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability.
Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.
Course Content
Design and implement database objects (25–30%)
- Design and implement a relational database schema
- Design and implement indexes
- Design and implement views
- Implement columnstore indexes
Implement programmability objects (20–25%)
- Ensure data integrity with constraints
- Create stored procedures
- Create triggers and user-defined functions
Manage database concurrency (25–30%)
- Implement transactions
- Manage isolation levels
- Optimize concurrency and locking behavior
- Implement memory-optimized tables and native stored procedures
Optimize database objects and SQL infrastructure (20–25%)
- Optimize statistics and indexes
- Analyze and troubleshoot query plans
- Manage performance for database instances
Monitor and trace SQL Server baseline performance metrics