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

JOIN AN UPCOMING CLASS FOR THIS COURSE