Become a Member   |   Contact Us   |   Marketplace   |   Sign In
Online Store: Real LIVE Practice-Labs
Main Storefront

Hands-on Practice Lab – 70-762 Developing SQL Databases

Item Options
Price: $99.00
Quantity: *

Overview: 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.

Duration: 25 hours

Lab 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

Lab Features Include:

  • Access LIVE Labs Online Anytime
    Practice anywhere, any time - 24/7 online access with no client software
  • Step-by-Step Instruction
    Easy to follow step-by-step instructions guide you through your practice exercises
  • Safe and Convenient Practice Environment
    Experiment and practice concepts with zero hassle and zero risk with no boundaries
  • Real Equipment in Real Time
    Access to REAL equipment with no restrictions and full administrator privileges, live in real time
  • Exam Prep
    Exercises are designed to address the questions you'll face on your certification exam
  • Practical Experience
    The most authentic experience possible in a lab environment with real-world scenarios and exercises
  • Hands-On Interactivity
    Retain your knowledge and feel confident in your new skills by practicing as you learn
  • Pro-Active Support
    Pro-active and comprehensive support services will assist you in resolving any technical issues you encounter connecting to your Real LIVE Practice-Labs
  • Certificate
    We'll send you a certificate to display your total hours of hands-on practical experience with Real LIVE Practice-Labs to employers