651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

MCSA SQL 2016 Business Intelligence Development Training & Certification Boot Camp Classroom Live Sarasota, FL April 02, 2018

Price: $4,995

This course runs for a duration of 6 Days.

The class will run daily from 9:00am EST to 5:00pm EST.

Class Location: Sarasota - Sarasota, FL.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

The Microsoft Official MCSA SQL 2016 Business Intelligence Development certification boot camp is a 6 day comprehensive deep dive into the SQL Server covering topics such as extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes.

The Microsoft SQL 2016 Business Intelligence Development boot camp incorporates Microsoft Official Courses -

While attending this training program - you take two exams to test and certify for the official Microsoft Certified Solutions Associate (MCSA) SQL 2016 Business Intelligence Development certification. If your goal is to learn how to use SQL Server 2016 and pass the certification exams (70-767 / 70-768) - you've found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives. Click MCSA SQL 2016 Business Intelligence Development to download course outline.

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.

Certifications

  • MCSA: SQL 2016 Business Intelligence Development

Exams Included & Administered During Camp:

  • 70-767: Implementing a SQL Data Warehouse
  • 70-768:  Developing SQL Data Models

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

Course Overview

Topics covered in this boot camp:

  • Describe the key elements of a data warehousing solution
  • Describe the main hardware considerations for building a data warehouse
  • Implement a logical design for a data warehouse
  • Implement a physical design for a data warehouse
  • Create columnstore indexes
  • Implementing an Azure SQL Data Warehouse
  • Describe the key features of SSIS
  • Implement a data flow by using SSIS
  • Implement control flow by using tasks and precedence constraints
  • Create dynamic packages that include variables and parameters
  • Debug SSIS packages
  • Describe the considerations for implement an ETL solution
  • Implement Data Quality Services
  • Implement a Master Data Services model
  • Describe how you can use custom components to extend SSIS
  • Deploy SSIS projects
  • Describe BI and common BI scenarios

 

  • 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 database
  • Use DAX to query a tabular model
  • Use data mining for predictive analysis

Prerequisites