You are here

MCSA 70-762 Developing Databases Review | Learn 70-762 Developing Databases

70-762 Developing Databases

70-762 Developing Databases exam is intended for database professionals who build and implement databases across organizations and maintain 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.

In this course you learn Design and implementation of database objects, Implement Programmability objects, Manage database concurrency, Optimize database objects and SQL infrastructure.


Course Content

Section-1 Introduction

It contains introduction of the course and information about 70-762 exam.

Section-2 Fundamentals of SQL

In this section you learn about database, schema, process of database design, normalization, create and alter table statements, data types, computed columns and dynamic data masking.

Section-3 Indexes

In this section you learn about index, terms used in indexes, clustered index, non-clustered index, covering index, unique index, filtered index, columnstore index, clustered columnstore index, non-clustered columnstore index.

Section-4 Views

In this section you learn about views, indexed view and partitioned view.

Section-5 Data Integrity with Constraints

In this section you learn about primary key, foreign key, cascading operations, unique constraints, check constraints, with check with nocheck and nocheck option, default constraint.

Section-6 Stored Procedures

In this section you learn about stored procedures, input and output parameters in stored procedure, table-valued parameters, implementation of return code in stored procedure.


Section-7 Error handling and Transaction control

In this section you learn about error handling and transaction control, throwing and error, handling an error, transaction control logic in error handling

Section-8 Triggers

In this section you learn about triggers, DML trigger, DDL Trigger, Database-Level DDL Trigger, Server-Level DDL Trigger, Logon Trigger.

Section-9 User-defined Functions

In this section you learn about user-defined functions like simple table-valued function, inline table-valued function, multistatement table-valued function.

Section-10 Practice Test

In section some questions based on concept discuss in this course.


In upcoming update of this course you learn many more like transactions, concurrency problems, isolation levels, deadlocks etc.


Who is the target audience?

– Software Developers

– Web Developers

– IT Professionals who wish to gain Microsoft Certification

– Programmers

– Students who are interested in database


Leave a Reply