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

Search: Boson Sites | Products

Preview our new look!

Microsoft > MCSE > Practice Lab for Microsoft 70-464

Practice Lab for Microsoft 70-464

About This Online Practice Lab:

Exam Number: 70-464
Exam Name: Developing Microsoft SQL Server 2012 Databases
Certifications: MCSE
Author: Boson
Single-User License  

70-464 Practice Lab

Practice Lab for Microsoft 70-464

See the Lab Videos to learn more.

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.

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

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

Microsoft 70-464 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.

70-464 Practice Lab 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

See all Microsoft | MCSE | Practice Labs | Practice Labs FAQ

Related Products

Developing Microsoft SQL Server 2014 Databases (Microsoft Course # 20464)
Implementing Data Models and Reports with Microsoft SQL Server 2014 (Microsoft Course #20466)

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.