MCSE Data Mgmt & Analytics (Developer) w/ MCSA SQL 2012/2014 Training & Certification Boot Camp – 14 Days

14 Days

Description

Course Length: 14 days

Certifications:

  • MCSA: SQL Server 2012
  • MCSE: Data Platform

Exams Included & Administered During Camp:

  • 70-461: Querying Microsoft SQL Server 2012
  • 70-462: Administering a Microsoft SQL Server 2012 Database
  • 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012
  • 70-464: Developing Microsoft SQL Server 2012 Databases
  • 70-465: Designing Database Solutions for Microsoft SQL Server 2012

What's Included:

  • Airfare To/From Sarasota or Tampa
  • 5 Microsoft Test Vouchers
  • Microsoft Training Books
  • 14 Nights of Lodging
  • 5 Retake Vouchers (if needed)
  • Microsoft Study Labs & Simulations
  • Ground Transportation
  • Onsite Prometric Testing Center
  • Instructor Led Classroom Training

The MCSE Data Mgmt & Analytics (Developer) w/ MCSA SQL 2012/2014 certification boot camp is a 14 day comprehensive deep dive into the SQL Server covering topics such as writing queries, administration and data warehousing.  This instructor led face to face training camp will teach you the skills needed to support a SQL 2012 environment.

The Data Platform Certification boot camp incorporates Microsoft Official Courses -

20461 Querying Microsoft SQL Server 2012
20462 Administering Microsoft SQL Server 2012 Databases
20463 Implementing a Data Warehouse with Microsoft SQL Server 2012
20464 Developing Microsoft SQL Server Databases
20465 Designing Database Solutions for Microsoft SQL Server 2012

We have developed a comprehensive training format which focuses on learning beyond the core content accessible to any Microsoft training provider. Our program incorporates interactive demonstrations with explanations which go beyond the content of the book. Additional content, videos, labs & demonstrations are provided to expand on advanced topics - providing additional insight and perspective.

As a Microsoft Certified Partner with Gold Learning Competency - we adhere to the strict guidelines, standards and requirements to use Microsoft's exclusive curriculum. Our standards go beyond the "minimum requirements" set forth by Microsoft.

We leverage our partnership benefits of courseware customization to build end to end technology solutions. The idea is for students to leave with practical skills which can be implemented immediately when leave class.

Our training program offers solutions before the course by providing you with pre-study materials / pre-class remote lab access, during the course with industry leading instructors and after the course with continued access to the lab environment.

We have developed a comprehensive training format which focuses on learning beyond the core content accessible to any Microsoft training provider. Our program incorporates interactive demonstrations with explanations which go beyond the content of the book. Additional content, videos, labs & demonstrations are provided to expand on advanced topics - providing additional insight and perspective.

As a Microsoft Certified Partner with Gold Learning Competency - we adhere to the strict guidelines, standards and requirements to use Microsoft's exclusive curriculum. Our standards go beyond the "minimum requirements" set forth by Microsoft.

We leverage our partnership benefits of courseware customization to build end to end technology solutions. The idea is for students to leave with practical skills which can be implemented immediately when leave class.

Our training program offers solutions before the course by providing you with pre-study materials / pre-class remote lab access, during the course with industry leading instructors and after the course with continued access to the lab environment.

CAMPUS - We have invested $150,000 into a complete training center construction build out. Larger classrooms, no sound transference between training rooms, new desk / executive leather chairs & great common areas.

CLASSROOM SERVERS - Each of our students work on a dedicated Dell 8500 / 8700 with an Intel i7 (4th generation), minimum of 16GB memory (Most with 32 GB) and most with 512GB SSD drives.

CAMPUS INTERNET - The campus is connected with a 300Mbs Verizon Fios Business Connection which provides complete internet (including VPN) access for students.

COMMON AREA - Unlike any training facility ever - breakroom with Mame Aracde, high end "kitchen" breakroom with snacks, drinks (Starbucks Coffee, 100% juices, sodas, etc) and breathtaking terrace.

LODGING - We use the Marriott Fairfield Inn & Suites Lakewood Ranch.  This "upgraded" hotel offers extremely comfortable beds, great breakfast and very fast (Verizon) internet access.

NEAR BY AMENITIES - Many shops, restuarants and grocery options are available within walking distance.  Additionally - the hotel provided scheduled shuttle services. Restuarants like Bone Fish Grill, Ruby Tuesday's, Five Guys, Chipotle, Quiznos, Chili's and over 20 additional choices in the immediate area. All of these options are offered in a pedestrian walking village.

Upcoming Classes

Classroom Live
October 28, 2017

Sarasota, FL or Virtual LIVE
$8,995.00
14 Days    9:00am EST - 5:00pm EST
view class details and enroll
Classroom Live
December 02, 2017

Sarasota, FL or Virtual LIVE
$8,995.00
14 Days    9:00am EST - 5:00pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

  • After completing this boot camp, students will be able to:
    • Describe the basic architecture and concepts of Microsoft SQL Server 2014.
    • Understand the similarities and differences between Transact-SQL and other computer languages.
    • Write SELECT queries
    • Query multiple tables
    • Sort and filter data
    • Describe the use of data types in SQL Server
    • Modify data using Transact-SQL
    • Use built-in functions
    • Group and aggregate data
    • Use subqueries
    • Use table expressions
    • Use set operators
    • Use window ranking, offset and aggregate functions
    • Implement pivoting and grouping sets
    • Execute stored procedures
    • Program with T-SQL
    • Implement error handling
    • Implement transactions
    • Describe core database administration tasks and tools.
    • Install and configure SQL Server 2014.
    • Configure SQL Server databases and storage.
    • Plan and implement a backup strategy.
    • Restore databases from backups.
    • Import and export data.
    • Monitor SQL Server.
    • Trace SQL Server activity.
    • Manage SQL Server security.
    • Audit data access and encrypt data.
    • Perform ongoing database maintenance.
    • Automate SQL Server maintenance with SQL Server Agent Jobs.
    • Configure Database Mail, alerts and notifications.
    • Describe data warehouse concepts and architecture considerations.
    • Select an appropriate hardware platform for a data warehouse.
    • Design and implement a data warehouse.
    • Implement Data Flow in an SSIS Package.
    • Implement Control Flow in an SSIS Package.
    • Debug and Troubleshoot SSIS packages.
    • Implement an ETL solution that supports incremental data extraction.
    • Implement an ETL solution that supports incremental data loading.
    • Implement data cleansing by using Microsoft Data Quality Services.
    • Implement Master Data Services to enforce data integrity.
    • Extend SSIS with custom scripts and components.
    • Deploy and Configure SSIS packages.
    • Describe how BI solutions can consume data from the data warehouse.
    • Introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts.
    • Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types.
    • Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered).
    • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints.
    • Determine appropriate single column and composite indexes strategies.
    • Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure.
    • Read and interpret details of common elements from execution plans.
    • Design effective non-clustered indexes.
    • Design and implement views
    • Design and implement stored procedures.
    • Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses.
    • Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues).
    • Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency.
    • Use both traditional T-SQL error handling code and structured exception handling.
    • Design and implement DML triggers
    • Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.
    • Store XML data and schemas in SQL Server.
    • Perform basic queries on XML data in SQL Server.
    • Work with the GEOGRAPHY and GEOMETRY data types
    • Implement and query a full-text index.
    • Assess an existing enterprise environment.
    • Plan and implement Policy-Based Management.
    • Describe the considerations for consolidating workloads with SQL Server 2014.
    • Describe considerations for including SQL Server 2014 in a private cloud.
    • Use Microsoft Azure storage with SQL Server 2014.
    • Implement and configure databases in Microsoft Azure SQL Database.
    • Implement and configure databases in Microsoft Azure virtual machines.
    • Describe high availability technologies in SQL Server 2014 and implement log shipping.
    • Describe Windows Server Failover Clustering and Implement an AlwaysOn Failover Cluster Instance.
    • Implement an Always On Availability Group.
    • Plan high availability and disaster recovery solutions.
    • Plan and implement database replication.

Upcoming Classes

Classroom Live
October 28, 2017

Sarasota, FL or Virtual LIVE
$8,995.00
14 Days    9:00am EST - 5:00pm EST
view class details and enroll
Classroom Live
December 02, 2017

Sarasota, FL or Virtual LIVE
$8,995.00
14 Days    9:00am EST - 5:00pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

Upcoming Classes

Classroom Live
October 28, 2017

Sarasota, FL or Virtual LIVE
$8,995.00
14 Days    9:00am EST - 5:00pm EST
view class details and enroll
Classroom Live
December 02, 2017

Sarasota, FL or Virtual LIVE
$8,995.00
14 Days    9:00am EST - 5:00pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date