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.
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.
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.
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
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
– Students who are interested in database