Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com
Phone: +27 10 020 2067

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Microsoft 70-461: Querying SQL Server 2012

LIVE LAB:

Microsoft 70-461: Querying SQL Server 2012

Practical exercises in a live environment to help you get real-world, hands-on experience.

Overview

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, Querying data by using SELECT statements, Implement sub-queries, Design views, Implement data types, modifying data (INSERT, UPDATE, and DELETE statements), Combine datasets, Work with functions, Manage transactions, Query and Manage XML Data, Working with Functions, Modifying Data and Troubleshooting / Optimizing Queries. These same tasks will help you understand the objectives and competencies required by the Querying Microsoft SQL Server 2012 certification exam. Update: Lab now includes a SQL 2014 device.

Vendor:   Microsoft
Vendor Id:   70-461
Version:   1
Level:   Intermediate
Learning Time:   550  Minutes

Exercises

  1. Create and alter tables using Transact SQL syntax
  2. Total Learning Time is 30  Minutes and module version is 6

    Exercises:
    • Introduction
    • Working with Tables
    • Summary
  3. Create and alter views
  4. Total Learning Time is 40  Minutes and module version is 6

    Exercises:
    • Introduction
    • Working with Views
    • Encrypting the text of the view
    • Summary
  5. Create and modify constraints
  6. Total Learning Time is 40  Minutes and module version is 8

    Exercises:
    • Introduction
    • Working with Constraints
    • Adding DEFAULT Definitions
    • Summary
  7. Create and alter DML triggers
  8. Total Learning Time is 50  Minutes and module version is 6

    Exercises:
    • Introduction
    • Implementing DML Triggers
    • INSTEAD OF Trigger
    • Creating a trigger to handle multiple records in a session
    • Summary
  9. Query data by using SELECT statements
  10. Total Learning Time is 50  Minutes and module version is 5

    Exercises:
    • Introduction
    • Working with SELECT Statements
    • Build Dynamic SQL Statements
    • Demonstrating the Working of Primary Key, Foreign Key, Check, and Default Constraints
    • Summary
  11. Implementing Sub queries
  12. Total Learning Time is 50  Minutes and module version is 3

    Exercises:
    • Introduction
    • Creating Subqueries
    • Interpreting the Query Execution Plan
    • Use Common Table Expression
    • Summary
  13. Implementing Data Types
  14. Total Learning Time is 40  Minutes and module version is 2

    Exercises:
    • Introduction
    • Use Appropriate Data Types
    • Demonstrate Pros and Cons of Data Types
    • Summary
  15. Implementing Aggregate Queries
  16. Total Learning Time is 40  Minutes and module version is 3

    Exercises:
    • Introduction
    • Analytic Functions
    • Work with Ranking Functions
    • Summary
  17. Query and Manage XML Data
  18. Total Learning Time is 40  Minutes and module version is 3

    Exercises:
    • Introduction
    • XML Data Type
    • Create XML Schema Collection in a Database
    • Summary
  19. Modifying Data
  20. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Creating and Altering Stored Procedures
    • Modify Data using INSERT, UPDATE and DELETE Statements
    • Combining Data Sets
    • Summary
  21. Working with Functions
  22. Total Learning Time is 30  Minutes and module version is 1

    Exercises:
    • Introduction
    • User-Defined Functions
    • Summary
  23. Optimizing Queries
  24. Total Learning Time is 40  Minutes and module version is 2

    Exercises:
    • Introduction
    • Reading and interpreting Query Plans
    • Reading IO statistics
    • Summary
  25. Troubleshooting Queries
  26. Total Learning Time is 50  Minutes and module version is 2

    Exercises:
    • Introduction
    • Manage Transactions
    • Evaluating Row-Based Operations vs. Set Based Operations
    • Implementing Error Handling
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
USD 295 USD 120 59% OFF
  • No of hours: 
    550
    + Minutes of practical exercises
  • Gain practical experience with real-world scenarios
  • Access to real hardware & software in real time
  • Experiment & put theory to practice
  • Includes exercises designed to prepare for exams.
  • 12 Months access
  • 10-Day money-back guarantee
Back to Top