70-762: Developing SQL Databases


SKU: LPL-157 Category:

The 70-762 Practice Lab will provide you with the necessary platform to gain hands on skills Microsoft SQL Server 2016. By completing the lab tasks, you will improve your practical skills in designing and implementing database objects, implementing programmability objects, managing database concurrency and optimizing database objects and SQL infrastructure.

These same tasks will help you understand the objectives and competencies required by the Microsoft 70-762 Developing SQL Databases exam.

About Practice Labs

In today’s world of complex computer systems and technologies it’s essential that both those new to IT and seasoned professionals alike gain hands on experience. Our state-of-the-art platform brings training theory to life giving the user greater depth of technology ensuring their ability to demonstrate how to use and understand vendor products and software.

Get the hands on learning you need without spending significant amounts of money on your own equipment. We deliver real equipment with the ease and convenience of your web browser, allowing you to develop real world IT skills.


  • Risk free platform to develop practical IT skills in all the latest technologies
  • Real world and exam related practical tasks
  • Real equipment NOT simulations
  • Simply accessed from a web browser, anytime, anywhere – 24/7

Learning Objectives

Designing a Relational Database Schema
Creating Indexes
Best Practices in Index Creation
Creating and Implementing Views
Creating Columnstore Indexes
Maintaining Columnstore Indexes
Creating Constraints
Effects of Contraints on DML Statements
Creating Stored Procedures with Parameters
Error Handling and Streamlining Stored Procedures
Creating Triggers
Creating User-Defined Functions
Impact of Transactions on DML Statements
Implicit and Explicit Transactions – Creating Savepoints
Manage Isolation Levels
Serializable and Snapshot
Identifying and Analyzing Locking Issues
Implementing Memory-Optimized Tables and Native Stored Procedures
Optimizing Statistics
Optimizing Indexes
Optimizing Query Plans Part 1
Optimizing Query Plans Part 2
Monitoring Performance using SQL Trace and Extended Events
Optimizing Performance for Database Instances Part 1
Optimizing Performance for Database Instances Part 2