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


Search: Boson Sites | Products
Microsoft > MCSA | MCSE > Practice Lab for Microsoft 70-461

Practice Lab for Microsoft 70-461

About This Online Practice Lab:

Exam Numbers: 70-461
Exam Name: Querying Microsoft SQL Server 2012
Certifications: MCSA, MCSE
Author: Boson

70-461 Practice Lab

Practice Labs for Microsoft 70-461
See the Lab Videos to learn more.
The Practice Lab for Microsoft 70-461 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-461 certification exam.

The 70-461 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 Create and Alter Tables, Query Data by Using SELECT Statements, Implement Subqueries, Design Views, Implement Data Types, Modify Data (INSERT, UPDATE, and DELETE Statements), Combine Datasets, Work with Functions, Manage Transactions, Query and Manage XML Data, Working with Functions, Modifying Data and Troubleshoot/Optimize Queries.

These same tasks will help you understand the objectives and competencies required by the Querying Microsoft SQL Server 2012 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
  • Allow you to share labs – great for instructors or students
  • Are accessible through the internet anytime, from anywhere

Microsoft 70-461 Exam Info

The 70-461: Querying Microsoft SQL Server 2012 counts as credit toward the following certification(s):
  • MCSA: SQL Server 2012
  • MCSE: Data Platform
  • MCSE: Business Intelligence

70-461 Practice Lab Course Modules

Create and Alter Tables Using Transact SQL Syntax

  •     Working with Tables

Create and Alter Views

  • Working with Views
  • Encrypting the text of the view

Create and Modify Constraints

  • Working with Constraints
  • Adding DEFAULT Definitions

Create and Alter DML Triggers

  • Implementing DML Triggers
  • INSTEAD OF Trigger
  • Creating a trigger to handle multiple records in a session

Query Data by Using SELECT Statements

  • Working with SELECT Statements
  • Build Dynamic SQL Statements
  • Demonstrating the Working of Primary Key, Foreign Key, Check, and Default Constraints

Implementing Subqueries

  • Creating Subqueries
  • Interpreting the Query Execution Plan
  • Use Common Table Expression

Implementing Data Types

  • Use Appropriate Data Types
  • Demonstrate Pros and Cons of Data Types

Implementing Aggregate Queries

  • Analytic Functions
  • Work with Ranking Functions

Query and Manage XML Data

  • XML Data Type
  • Create XML Schema Collection in a Database

Modifying Data

  • Creating and Altering Stored Procedures
  • Modify Data using INSERT, UPDATE and DELETE Statements
  • Combining Data Sets

Working with Functions

  • User-Defined Functions

Optimizing Queries

  • Reading and interpreting Query Plans
  • Reading IO statistics

Troubleshooting Queries

  • Manage Transactions
  • Evaluating Row-Based Operations vs. Set Based Operations
  • Implementing Error Handling

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


Related Products

ExSim-Max for Microsoft 70-461
MCSA: SQL Server 2012 Training
MCSA: SQL 2014 with MCSE: Data Platform Training

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.


MIC-PL-70461-01