MS-MCSE-SQLDATA-DEV - FastTrack to MCSE Data Management and Analytics through SQL Development Boot Camp

Duration: 6 days

Price: $4,095.00

SATVs: 8

Unitek Training's FastTrack to MCSE Data Management and Analytics through SQL Development (SQL Server 2014) Boot Camp teaches students how to design and implement SQL Server 2014. After the boot camp, Earning the FastTrack to MCSE Data Management and Analytics through SQL Development will demonstrate your broad skill sets in building and administrating enterprise-scale data solutions both on-premises and in cloud environments. An MCSE Data Platform certification will display your expertise to implement database objects and programming objects, optimize and troubleshoot queries, design a troubleshooting and optimization solution, and design databases and database objects, structure, and security.

This boot camp prepares you for the following exams:

*Boot camp includes lunch, exam vouchers, and exam prep material where applicable.

Upcoming Boot Camps

Dec 10-Dec 15 Chicago, IL Enroll

Course Timings: 8:00 a.m. – 6:00 p.m. M–F

This Boot Camp requires that you meet the following prerequisites:

MCSA: SQL Server 2012/2014


MCSA: SQL Server 2016 Administration


MCSA: SQL Server 2016 Development


MCSA: SQL Server 2016 Business Intelligence Development

Boot Camp Outline

Introduction to SQL Server 2014 and its Toolset

Working with Data Types

Designing and Implementing Tables

Ensuring Data Integrity through Constraints

Planning for SQL Server 2014 Indexing

Implementing Table Structures in SQL Server 2014

Reading SQL Server 2014 Execution Plans

Improving Performance through Non- clustered Indexes

Designing and Implementing Views

Designing and Implementing Stored Procedures

Merging Data and Passing Tables

Designing and Implementing User-Defined Functions

Creating Highly Concurrent SQL Server 2014 Applications

Handling Errors in T-SQL Code

Responding to Data Manipulation via Triggers

Implementing Managed Code in SQL Server 2014

Storing XML Data in SQL Server 2014

Querying XML Data in SQL Server

Working with SQL Server 2014 Spatial Data

Working with Full-Text Indexes and Queries

Designing a Database Server Infrastructure

Designing a Logical Database Schema

Designing a Physical Database Implementation

Incorporating Data Files into Databases

Tuning Database Performance

Designing Database Security

Policy Based Management

Monitoring Server Health

Designing a Database Backup Solution

Automating Multi-Server Maintenance

Managing SQL Server with PowerShell

Replicating Data

Planning High Availability

This bootcamp includes the following courses

MS-20464 - Developing Microsoft SQL Server Databases See Details
MS-20465 - Designing a Data Solution with Microsoft SQL Server See Details