MCSE Data Platform Boot Camp

Quantity

$3,595.00

Add to Cart

New Age Technologies has been delivering Authorized Training since 1996. We offer Microsoft’s full suite of authorized courses including courses pertaining to Microsoft MCSE Data Platform Boot Camp, Microsoft Office, Sharepoint, SQL, Exchange and more. If you have any questions or can’t seem to find the Microsoft class that you are interested in, contact one of our Microsoft Training Specialists. Invest in your future today with Microsoft training from New Age Technologies.

✉ Microsoft Training Specialist | ☏ 502.909.0819

---

EXCLUSIVE BENEFIT:

This course includes a twelve-month subscription to these exclusive benefits:

• 12 months of anytime access to your course labs and lab environment
• 12 months of 24/7 access to mentoring via chat, email, and phone
• 12 months of on-demand access to indexed, searchable recordings of your Online Live class
• 12 months of unlimited retakes of your class
• 30 days of access to the online Microsoft Press E-Reference Library, including all training kits, exam references, and rapid review books
• 30 days of access to a recommended Microsoft reading List designed by our instructors, including topics and chapters within the Microsoft Press E-Reference Library
• 12 months of access to certification practice exams from Transcender that provide realistic Microsoft exam simulations in online and downloadable versions
• 12 months of access to recorded “Power Hours” — an online review session covering key exam objectives conducted by our expert instructors – for each exam

---

COURSE INFORMATION

MCSE Data Platform Boot Camp Overview:

MCSE Data Platform Boot Camp helps you acquire hands-on skills for on-premise and cloud environments and prepare you for the MCSE: Data Platform certification exams. The questions on the MCSE: Data Platform exams include content covering both versions of SQL Server 2012 and 2014.

This boot camp includes all the certification exam vouchers required for certification, along with one free retake voucher for each exam, if needed. It also includes access to our Microsoft Boot Camp Exclusives, providing indispensable certification exam prep.

Although not required to attend this boot camp, it should be noted that in order to qualify for the MCSE: Data Platform certification, candidates must either hold or obtain an MCSA: SQL Server 2012 certification as well.

MCSE Data Platform Boot Camp incorporates content from Microsoft Official Courses (MOC):

• Developing Microsoft SQL Server Databases (M20464)
• Updating Your SQL Server 2008 Skills to SQL Server 2014 (M10977)

You Will Cover the Objectives for these Exams:

• 70-464: Developing Microsoft SQL Server Databases
• 70-465: Designing Database Solutions for Microsoft SQL Server

Who Should Attend:

• IT Professionals with at least three years of hands-on experience implementing and administering database systems
• Database Administrators, Systems Engineers, Systems Analysts and Technical Consultants who have completed the MCSA: SQL Server 2012 certification or have equivalent knowledge
• IT Professionals who want to prepare for the MCSE: Data Platform certification

MCSE Data Platform Boot Camp Prerequisites:

Before attending this course, you must have the following:

• MCSA: SQL Server 2012 certification or equivalent knowledge
• Three years of hands-on experience working in a SQL Server environment
• Basic knowledge of the Microsoft Windows operation system and its core functionality

MCSE Data Platform Boot Camp Objectives:

After successfully completing this course, you will be able to:

• The technical skills required to develop Microsoft SQL Server Databases including:
• Database objectives
• Logical table design
• Indexing
• Query plans
• Procedure coding
• The knowledge and skills to design solutions for Microsoft SQL Server including:
• How to plan and design a database structure, storage, objects and servers
• How to design and monitor high performance, highly available data solutions, data migration, security and scalability
• Key topics and concepts addressed in the exams 70-464: Developing Microsoft SQL Server 2012 and 70-465: Designing Database Solutions for Microsoft SQL Server 2012

MCSE Data Platform Boot Camp Outline:

Exam 70-464: Developing Microsoft SQL Server Databases

Module 1: An Introduction to Database Development

• SQL Server Platform
• SQL Server Tools
• Configuring SQL Server Services
• Module 1 Lab:
• Database Development Introduction

Module 2: Designing and Implementing Tables

• Designing Tables
• Working with Schemas
• Creating and Altering Tables
• Module 2 Lab:
• Design and Implement Tables

Module 3: Ensuring Data Integrity through Constraints

• Enforcing Data Integrity
• Implementing Domain Integrity
• Implementing Entity and Referential Integrity
• Module 3 Lab:
• Ensure Data Integrity through Constraints

Module 4: Introduction to Indexes

• Core Indexing Concepts
• Single Column and Composite Indexes
• SQL Server Table Structures and Clustered Indexes
• Module 4 Lab:
• Create Indexes

Module 5: Advanced Indexing

• Execution Plan Concepts and Elements
• INCLUDE Clause, Padding, Hints, and Statistics
• Designing Effective Non-Clustered Indexes
• Performance Monitoring and the Database Engine Tuning Advisor
• Module 5 Lab:
• Plan for SQL Server 2014 Indexing

Module 6: In-Memory Database Capabilities

• Buffer Pool Extension
• Columnstore Indexes
• Module 6 Lab:
• In-Memory Database Capabilities

Module 7: Designing and Implementing Views

• Views
• Creating and Managing Views
• Performance Considerations for Views
• Module 7 Lab:
• Design and Implement Views

Module 8: Designing and Implementing Stored Procedures

• Stored Procedures
• Working with Stored Procedures
• Implementing Parameterized Stored Procedures
• Controlling Execution Context
• Module 8 Lab:
• Design and Implement Stored Procedures

Module 9: Designing and Implementing User-Defined Functions

• Functions
• Designing and Implementing Scalar and Table-Valued Functions
• Implementation Considerations for Functions
• Alternatives to Functions
• Module 9 Lab:
• Design and Implement User-Defined Functions

Module 10: Responding to Data Manipulation via Triggers

• Designing and Implementing DML Triggers
• Advanced Trigger Concepts
• Module 10 Lab:
• Respond to Data Manipulation via Triggers

Module 11: Using In-Memory Tables

• Memory-optimized Tables
• Natively compiled Stored Procedures
• Module 11 Lab:
• In-Memory Database Capabilities

Module 12: Implementing Managed Code in SQL Server

• SQL CLR Integration
• Importing and Cataloging Assemblies
• Implementing SQL CLR Integration
• Module 12 Lab:
• Implement Managed Code in SQL Server

Module 13: Storing and Querying XML Data in SQL Server

• XML and XML Schemas
• Storing XML Data and XML Schemas in SQL Sever
• Implementing XML Indexes
• Using the T-SQL for XML Statement
• Getting Started with Xquery
• Shredding XML
• Module 13 Lab:
• Store and Query XML Data in SQL Server

Module 14: Working with SQL Server Spatial Data

• Spatial Data
• Working with SQL Server Spatial Data Types
• Using Spatial Data in Applications
• Module 14 Lab:
• SQL Server Spatial Data

Module 15: Incorporating Data Files into Databases

• Considerations for Working with Data Files in SQL Server 2014
• Implementing FILESTREAM and FileTables
• Searching Data Files
• Module 15 Lab:
• Incorporating Data Files into Databases

Exam 70-465: Designing Database Solutions for Microsoft SQL Server

Module 1: Introduction to SQL Server 2014

• Overview of SQL Server 2014
• SQL Server 2014 Editions and Components
• Installing SQL Server 2014
• Enhancements to SQL Server Management Studio
• Module 1 Lab:
• Exploring SQL Server 2014

Module 2: What’s New in SQL Server Database Development

• Transact-SQL Enhancements and Functions
• Enhancements to Spatial Data Support
• Storing and Querying Documents with SQL Server 2014
• Module 2 Lab:
• Develop SQL Server 2014 Databases

Module 3: In-Memory Database Capabilities

• The Buffer Pool Extension
• Columnstore Indexes and Memory-Optimized Tables
• Module 3 Lab:
• Use In-Memory Database Capabilities

Module 4: Scripting SQL Server 2014

• Dynamic Management Views
• Manage SQL Server using PowerShell
• Module 4 Lab:
• Manage SQL Server with Scripts

Module 5: Implementing Security in Microsoft SQL Server 2014

• Security Management Enhancements
• Contained Databases
• Module 5 Lab:
• Implement Security

Module 6: High Availability and Data Recovery Enhancements

• AlwaysOn High Availability
• Enhancements to Data Recovery
• Module 6 Lab:
• Use AlwaysOn Availability Groups

Module 7: Introduction to Cloud Data Solutions

• Overview of Cloud Computing
• Microsoft Azure Services for Data
• Module 7 Lab:
• Use Microsoft Azure

Module 8: Microsoft Azure SQL Database

• Introduction to Microsoft Azure SQL Database
• Microsoft Azure SQL Database Security
• Implementing and Managing Databases
• Module 8 Lab:
• Microsoft Azure SQL Database

Module 9: SQL Server in Microsoft Azure Virtual Machines

• Introduction to Microsoft Azure Virtual Machines
• Microsoft Azure Virtual Machine Connectivity and Security
• Creating Databases in a Microsoft Azure Virtual Machine
• Module 9 Lab:
• SQL Server in Microsoft Azure Virtual Machines

---

Boost your salary by obtaining your Microsoft Certification: Microsoft Certified Systems Engineer (MCSE): Data Platform