Microsoft > MCSE > Practice Lab for Microsoft 70-464

Practice Lab for Microsoft 70-464

Exam Number
Exam Name
Developing Microsoft SQL Server 2012 Databases

70-464 Practice Lab

The Practice Lab for Microsoft 70-464 provides access* to real computer equipment that is networked together and conveniently accessible over the internet. Practice Labs 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-464 certification exam.
The 70-464 Practice-Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012. By completing the lab tasks you will improve your practical skills in managing tables with complex statements, implementing database security and manage transactions and isolation levels. You will also maintain indexes, implement different data types, modifying constraints and working with XML data. Finally you will create automation scripts, manage views and indexes, tune queries and use estimation plans. These same tasks will help you understand the objectives and competencies required by the MCSE: Developing Microsoft SQL Server 2012 Databases certification exam.
See our Practice Labs Youtube Playlist to learn how to purchase, activate and access Boson Practice Labs.
*A Practice Lab purchase includes access for one (1) year from activation.
Practice Lab for Microsoft 70-464
See the Lab Videos to learn more.

Exam Info

Candidates for this exam are database professionals who build and implement databases across organizations and ensure high levels of data availability. Responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; insuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.
The 70-464: Developing Microsoft SQL Server 2012 Databases exam counts as credit toward the MCSE: Database Platform certification.

Benefits of Online Practice Labs

  • Provide dedicated live equipment without the risk or expense
  • Help improve practical IT skills
  • Can help you learn the knowledge needed to pass the certification exam
  • Are accessible through the internet anytime, from anywhere

Course Modules

Create and Alter Tables

  • Introduction
  • Create Schema and Tables
  • Create Temporary Tables and Table Variables
  • Summary

Design Implement and Troubleshoot Security

  • Introduction
  • Implement Security
  • Summary

Design the Locking Granularity Level

  • Introduction
  • Implement Transactions and Isolation Levels
  • Summary

Maintain Indexes

  • Introduction
  • Explore Index Statistics and Rebuild/Reorganize indexes
  • Summary

Implement DataTypes

  • Introduction
  • Data Types such as CLR, GUID, SPARSE, Spatial & LOB
  • Use Sparse Columns
  • Summary

Create Modify Constraints

  • Introduction
  • Create Constraints
  • Modify Constraints
  • Test Constraints for Performance Implications
  • Summary

Work with XML Data

  • Introduction
  • Create XML Schema Collection
  • Import and Export XML Data
  • Transform and Modify XML Data
  • Summary

Write Automation Scripts

  • Introduction
  • Write Automation Script to Perform Database Backup
  • Write Automation Script to Shrink Database
  • Write Automation Script to Remedy Index Fragmentation
  • Write Automation Script to Check Disk Space
  • Write Script to Automate Execution of SSIS Package
  • Summary

Design T-SQL Table-Valued and Scalar Functions

  • Introduction
  • Work with Scalar and Table Valued Function
  • Implement Set Based Vs Procedural Approach
  • Summary

Create and Alter Views

  • Introduction
  • Create and Modify Views
  • Implement Partitioned View
  • Summary

Create and Alter Indexes

  • Introduction
  • Implement Full Text and Filtered Index
  • Create Non Clustered and Column Store Index
  • Implement Semantic Index
  • Create Filtered Statistics and Full Statistics
  • Summary

Optimize and Tune Queries

  • Introduction
  • Tuning Queries
  • Use Recursive CTE
  • Implement Full Text Search and Use Hints to Control Execution Plans
  • Summary

Capture and Analyzie Estimation Plan

  • Introduction
  • Use Actual and Estimated Execution Plans
  • Summary

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.