Special Offers | My Account | Log In
  0 items in your cart

Search: Boson Sites | Products

Preview our new look!

Microsoft > MCSA > Practice Lab for Microsoft 70-762

Practice Lab for Microsoft 70-762

About This Online Practice Lab:

Exam Number: 70-762
Exam Name: Developing SQL Databases
Certifications: MCSA
Author: Boson
Single-User License  

Microsoft 70-762 Practice Lab

70-740 Practice Labs
See the Lab Videos to learn more.
The Practice Lab for Microsoft 70-762 provides access* to real computer equipment that is networked together and conveniently accessible over the internet. Practice Labs include include include multiple pieces of equipment that you can configure. This lab includes instructions that will guide you as you learn the concepts and technologies covered on the Microsoft 70-762 certification exam.

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.

These same tasks will help you understand the objectives and competencies required by the MCSA : Developing SQL Databases (70-762) certification exam.

*A Practice Lab purchase includes access for one (1) year from activation.

70-762 Practice Lab Course Modules

  • 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

Microsoft 70-762 Certification Exam

The Developing SQL Databases (70-762) exam is a requirement for the Microsoft Certified Solutions Associate (MCSA) certification.

See all Microsoft | MCSA | Practice Labs | Practice Labs FAQ

Related Products

MCSA SQL 2016 Database Development Bootcamp

Be the first to review this product. If you have used this product, you can review it on your account page. You must be logged in to review products.