MCSE Data Mgmt & Analytics (Business Intelligence) w/ MCSA SQL 2012 / 2014 Training & Certification Boot Camp – 12 Days

6 Days

Description

Certification:

  • MCSE: Data Mgmt & Analytics - Business Intelligence
  • MCSA: SQL Server 2012 / 2014

Exams Included & Administered During Camp:

  • 70-461:: Querying Microsoft SQL Server
  • 70-462: Administering a Microsoft SQL Server Database
  • 70-463: Implementing Data Warehouses with Microsoft SQL Server
  • 70-466: Implementing Data Models and Reports with Microsoft SQL Server

What's Included:

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

Please note: You must have achieved the MCSA: SQL Server 2012 Certification to achieve the MCSE: Data Platform Certification

The MCSE Data Mgmt & Analytics (Business Intelligence) w/ MCSA SQL 2012 / 2014 boot camp replaces the MCSE Business Intelligence certification. This 12 day comprehensive deep dive into the SQL Server covering topics such as writing queries, administration, data warehousing, building SSAS cubes and models for reporting. This instructor led face to face training camp will teach you the skills needed to support a SQL environment.

The MCSA SQL boot camp incorporates Microsoft Official Courses -

20461 Querying Microsoft SQL Server
20462 Administering Microsoft SQL Server Databases
20463 Implementing a Data Warehouse with Microsoft SQL Server
20466 Implementing Data Models and Reports with Microsoft SQL Server

While attending this training program - you take four exams to test and certify for the MCSE Data Mgmt & Analytics w/ MCSA SQL 2012 / 2014 official certification. If your goal is to learn how to use SQL Server and pass the certification exams (70-461, 70-462, 70-463 & 70-466) - you've found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives.

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.

Additionally, we limit our class sizes to 12 students with an average class size of 8.  The instructor to student ratio is an important aspect of the learning environment and strict self-imposed rule of our organization.

Our facilities are second to none. We use top end computer equipment - 20in monitors, cpu's with Intel Virtualization processors, 8 gigs (min) of memory. Students have executive chairs to ensure comfort for long bootcamp hours. Sudent desk allow plenty of room for student computer, personal laptop and book - each student has a large dedicated desk.

The campus is connected with a 150Mbs Verizon Fios Business Connection which provides a network open for internet access and VPN connections. We provide wired (CAT6) and wireless (b/g/n) connections.

Additionally, student break area has snacks including fruits, chips, baked goods and drinks.  Our lounge area provides plenty of comfortable seating and a 50in LED TV w/ Verizon Fios programming.

Students stay at Marriott & Hilton brand hotels which provide full suite amenities including flat panel tvs, microwave and refrigerator in every room. Students have access to 20+ restaurants within walking distance of the hotel.

If you chose not to rent a vehicle - we provide all transportation between airport/hotel/campus. Within 50 yards of the hotels - you will find BoneFish Grill, 5 Guys Burgers & Fries, Urban Flats, Moes, Jersey Mikes, Lee Roy Selmons, Pei Wei, Carrabas, Stonewood Grill, Ruby Tuesdays and more.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a MCSE Data Mgmt & Analytics (Business Intelligence) w/ MCSA SQL 2012 / 2014 Training & Certification Boot Camp – 12 Days class.

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

  • Topics covered in this boot camp:
    • 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
    • Describe the components, architecture, and nature of a BI solution.
    • Create a multidimensional database with Analysis Services.
    • Implement dimensions in a cube.
    • Implement measures and measure groups in a cube.
    • Use MDX Syntax.
    • Customize a cube.
    • Implement a Tabular Data Model in SQL Server Analysis Services.
    • Use DAX to enhance a tabular model.
    • Create reports with Reporting Services.
    • Enhance reports with charts and parameters.
    • Manage report execution and delivery.
    • Implement a dashboard in SharePoint Server with PerformancePoint Services.
    • Use Data Mining for Predictive Analysis.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a MCSE Data Mgmt & Analytics (Business Intelligence) w/ MCSA SQL 2012 / 2014 Training & Certification Boot Camp – 12 Days class.

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

Please note:You must have achieved the MCSA: SQL Server 2012 Certification to achieve the MCSE: Data Platform Certification

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a MCSE Data Mgmt & Analytics (Business Intelligence) w/ MCSA SQL 2012 / 2014 Training & Certification Boot Camp – 12 Days class.

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