MCSA: SQL 2016 Business Intelligence Development

Code: 7899

6 days

List Tuition : $4,095.00 USD

Course Overview

    Download PDF Certification Path

MCSA: SQL 2016 Business Intelligence Development Certification validates your 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. This certification will qualify you for a position as a BI developer.

This  Boot Camp provides students hands-on experience with SQL Server 2016. The boot camp will highlight what is new in SQL Server 2016 in comparison to SQL Server 2012/2014. It provides guidance on designing, implementing and populating Data Warehouses in SQL 2016. As well as working with cubes and other data models in SQL Server Analysis Services 2016.

This course incorporates content from Microsoft Official Courses (MOC):

  • Implementing a SQL Data Warehouse (20767B)
  • Developing SQL Data Models (20768B)

Two Exam Vouchers are Included (Unlimited Retakes)

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

Learn More About MCSA: SQL 2016 Business Intelligence Development Certification

The primary audience for this course is individuals who have at least 2 years' experience of working with relational databases. This experience should include:

  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

After completing this course, students will be able to:

  • 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
  • Microsoft Certified Trainers
  • Microsoft Official Course Material
    • Implementing a SQL Data Warehouse (20767B)
    • Developing SQL Data Models (20768B)
  • Exam Voucher(s) Included with Class
    • Exam 70-767 Implementing a SQL Data Warehouse
    • Exam 70-768 Developing SQL Data Models
  • Exam Pass Guarantee: Unlimited Retakes Until You Pass the Exam
  • Work in virtual labs that provide real-world experience
  • For Virtual Classes Learn at your own pace from your home, office, or any place that has an Internet connection
  • Repeat part or all of the class at no additional cost, often for up to a year
  • Work in virtual labs that provide real-world experience
  • Certification of Completion at the End of Class
  • Water, Soda, and Snacks Provided in Class
  • Time intensive accelerated training for teams with budget and time
  • Access to practice labs after the class

Request a Discounted Quote




Bring Training to You

Request schedule for this course

Request a Quote for this Class

We provide government and government contractor discounts, please request a quote

Schedule



total option: 0

Hotel and Travel can be included on your quote.
For immediate response, you can call 1-855-515-2170 or we will provide a quote within 4 business hours. Travel must be booked 14 days before training for rate to apply.

Learn How to Become a Managed Learning Member

Request a Quote

Thank you for requesting a quote, we will be in touch shortly with a quote. If you need immediate assistance, please call 855-515-2170.

Request Other Date

Request date or location you need

Don’t see the date or location you need? Contact us and let us know, we are adding dates and locations daily.