Practice Lab: 70-762 - Developing SQL Databases

Practice Lab
Online Practice Labs, easily accessed from anywhere at any time, are the foundation to practical hands-on skills development enabling users to access real live equipment in a safe test environment.


The 70-762 Practice Lab will provide you with the necessary platform to gain hands on skills for 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.

Learning Objectives
Learning Time: 25 hours

  • 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
PlatformOperating SystemBrowser
Chrome 39 Firefox 34 Internet Explorer 10 and 11 Safari 8
PC W7 x86 X X X
W7 x64 X X X
W8.1 x86 X X X
W8.1 x64 X X X
MAC OSX 10.9 X X X
OSX 10.10 X X X
LINUX Linux x86 X X
Linux x64 X X
Surface Pro Windows 8 X X X
PlatformOperating SystemBrowser
Safari 8 Android Chrome 39 Internet Explorer RT Internet Explorer 11
iPad* IOS 8 X X
iPhone 5 or higher* IOS 8 X X
iPhone 4* IOS 7 X X
Android Tablet* 4.0 or higher X X
Android Phone* 4.0 or higher X X
Lumia 920 or higher* Windows Phone 8.1 X
Surface Windows RT X

*Online use only with these devices

Download System Requeriments

  • Win7, Win8.1, Linux 64 bits, MAC OSX 10.9 and 10.10
  • We no longer support XP