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-464 Developing Microsoft SQL Server 2012 Databases

LIVE LAB:

Microsoft 70-464 Developing Microsoft SQL Server 2012 Databases

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

Overview

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.

Vendor:   Microsoft
Vendor Id:   70-464
Version:   1
Level:   Intermediate
Learning Time:   690  Minutes

Exercises

  1. Create and Alter Tables
  2. Total Learning Time is 40  Minutes and module version is 3

    Exercises:
    • Introduction
    • Create Schema and Tables
    • Create Temporary Tables and Table Variables
    • Summary
  3. Design Implement and Troubleshoot Security
  4. Total Learning Time is 30  Minutes and module version is 1

    Exercises:
    • Introduction
    • Implement Security
    • Summary
  5. Design the Locking Granularity Level
  6. Total Learning Time is 30  Minutes and module version is 1

    Exercises:
    • Introduction
    • Implement Transactions and Isolation Levels
    • Summary
  7. Maintain Indexes
  8. Total Learning Time is 30  Minutes and module version is 1

    Exercises:
    • Introduction
    • Explore Index Statistics and Rebuild/Reorganize indexes
    • Summary
  9. Implement DataTypes
  10. Total Learning Time is 40  Minutes and module version is 1

    Exercises:
    • Introduction
    • Data Types such as CLR, GUID, SPARSE, Spatial & LOB
    • Use Sparse Columns
    • Summary
  11. Create Modify Constraints
  12. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Create Constraints
    • Modify Constraints
    • Test Constraints for Performance Implications
    • Summary
  13. Work with XML Data
  14. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Create XML Schema Collection
    • Import and Export XML Data
    • Transform and Modify XML Data
    • Summary
  15. Write Automation Scripts
  16. Total Learning Time is 70  Minutes and module version is 1

    Exercises:
    • 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
  17. Design T-SQL Table-Valued and Scalar Functions
  18. Total Learning Time is 40  Minutes and module version is 1

    Exercises:
    • Introduction
    • Work with Scalar and Table Valued Function
    • Implement Set Based Vs Procedural Approach
    • Summary
  19. Create and Alter Views
  20. Total Learning Time is 40  Minutes and module version is 1

    Exercises:
    • Introduction
    • Create and Modify Views
    • Implement Partitioned View
    • Summary
  21. Create and Alter Indexes
  22. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Implement Full Text and Filtered Index
    • Create Non Clustered and Column Store Index
    • Implement Semantic Index
    • Create Filtered Statistics and Full Statistics
    • Summary
  23. Optimize and Tune Queries
  24. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Tuning Queries
    • Use Recursive CTE
    • Implement Full Text Search and Use Hints to Control Execution Plans
    • Summary
  25. Capture and Analyzie Estimation Plan
  26. Total Learning Time is 30  Minutes and module version is 1

    Exercises:
    • Introduction
    • Use Actual and Estimated Execution Plans
    • Summary
  27. TroubleShoot and Resolve Performance Problems
  28. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Manage Large MDF and LDF Files
    • Demonstrate Troubleshooting Replication
    • Troubleshoot Data Access Problems
    • Summary
  29. Optimize Indexing Strategies
  30. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Analyze indexes, Use Included Columns
    • Use Indexing for Data Warehousing Data Sets to Optimize Query Performance
    • Use Indexing for OLTP Data Sets to Optimize Query Performance
    • Summary
  31. Collect Performance and System Information
  32. Total Learning Time is 30  Minutes and module version is 1

    Exercises:
    • Introduction
    • Collect Performance Information using Dynamic Management Views and SQL Server Profiler
    • 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: 
    690
    + 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 (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top