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

Jun 11-Jun 16 Dallas, TX Enroll
Jun 11-Jun 16 Live Online - CST Enroll
Jun 11-Jun 16 Live Online - PST Enroll
Jul 16-Jul 21 Live Online - EST Enroll
Aug 13-Aug 18 Dallas, TX Enroll
Aug 13-Aug 18 Live Online - CST Enroll
Aug 13-Aug 18 Live Online - PST Enroll
Sep 17-Sep 22 Live Online - EST Enroll
Sep 17-Sep 22 Live Online - PST Enroll
Oct 08-Oct 13 Dallas, TX Enroll
Oct 08-Oct 13 Live Online - CST Enroll
Oct 08-Oct 13 Live Online - PST Enroll
Nov 05-Nov 10 Atlanta, GA Enroll
Nov 05-Nov 09 Chandler, AZ Enroll
Nov 05-Nov 09 Live Online - EST Enroll
Nov 05-Nov 09 Live Online - MST Enroll
Nov 05-Nov 09 New York, NY Enroll
Dec 10-Dec 15 Chicago, IL Enroll
Dec 10-Dec 15 Dallas, TX Enroll
Dec 10-Dec 15 Fremont, CA Enroll
Dec 10-Dec 15 Live Online - CST Enroll
Dec 10-Dec 15 Live Online - PST 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

OR

MCSA: SQL Server 2016 Administration

OR

MCSA: SQL Server 2016 Development

OR

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