MCSA SQL SERVER 2016 Business Intelligence

Description

MCSA SQL 2016 Business Intelligence Development    

The Academy of South Florida offers the fastest, most effective method to learn the industry-standard, fundamental features of Microsoft SQL Server that have made Microsoft's premiere database solution a worldwide leader in data-driven business and application infrastructure.

With this SQL Server 2016 boot camp, you will gain valuable insight into the new, powerful capabilities that SQL Server 2016 adds to a database developer and administrator's solutions tool box.

MCSA: SQL 2016 Business Intelligence certification covers everything from designing, installing, configuring, and maintaining a Microsoft Database environment, to implementing and troubleshooting database objects. This program covers all material and exams necessary to achieve an MCSA in SQL 2016 Business Intelligence.

This 5-day boot camp is a combination of the following official Microsoft courses:
• 20767A: Implementing a SQL Data Warehouse (Exam 70-767)
• 20768A: Developing SQL Data Models (Exam 70-768)


This course provides students with the technical skills required to build a data warehouse solution. Designing, Implementing and building a data warehouse solution on Azure. Creating colunstore indexes, Implementing and Debugging SSIS packages. Implementing, Customizing and testing Cubes for analysis.

This course helps people prepare for exam 70-767. This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-768. Database Developing and warehousing is a solution organizations use to centralize business data for reporting and analysis. This instructor-led course focuses on teaching individuals how to create a data warehouse with SQL Server 2016, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.


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

Prerequisites

Students should have at least two years of experience in the IT field and should already have the following technical knowledge:

• Networking fundamentals, including Transmission Control Protocol /Internet Protocol (TCP/IP), User Datagram Protocol (UDP), and Domain Name System (DNS)
• Microsoft Active Directory Domain Services (AD DS) principles
• Windows Server 2012 R2 fundamentals

Microsoft Windows Client essentials; for example, working knowledge of Windows 7 and/or Windows 8.

Contact Us

THE ACADEMY

1.800.482.3172

FTL: 954.351.7040

MIA: 305.648.2000


Request More Information

 

Current Promotions!

 

  _____________________________________

 

 

 

 

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for our Email Newsletter!

          

 

Top
  • Follow us on
  • Facebook Academy Page
  • Twitter Academy Page