MCSA SQL SERVER 2016 Business Intelligence

Description

Duration: 5 days

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 toolbox.

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:

20767B: Implementing a SQL Data Warehouse (Exam 70-767)
20768B: 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 column store indexes, Implementing, and Debugging SSIS packages. Implementing, Customizing, and testing Cubes for analysis.

This course helps people prepare for exams 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 column store 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.

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands-on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

StartFinishPublic PricePublic Enroll Private PricePrivate Enroll
9/23/20249/27/2024
10/14/202410/18/2024
11/4/202411/8/2024
11/25/202411/29/2024
12/16/202412/20/2024
1/6/20251/10/2025
1/27/20251/31/2025
2/17/20252/21/2025
3/10/20253/14/2025
3/31/20254/4/2025
4/21/20254/25/2025
5/12/20255/16/2025
6/2/20256/6/2025
6/23/20256/27/2025
7/14/20257/18/2025
8/4/20258/8/2025
8/25/20258/29/2025
9/15/20259/19/2025
10/6/202510/10/2025
10/27/202510/31/2025
11/17/202511/21/2025
12/8/202512/12/2025
12/29/20251/2/2026

Curriculum

  • Module 1: Introduction to Data Warehousing
  • Module 2: Planning Data Warehouse Infrastructure
  • Module 3: Designing and Implementing a Data Warehouse
  • Module 4: Columnstore Indexes
  • Module 5: Implementing an Azure SQL Data Warehouse
  • Module 6: Creating an ETL Solution
  • Module 7: Implementing Control Flow in an SSIS Package
  • Module 8: Debugging and Troubleshooting SSIS Packages
  • Module 9: Implementing an Incremental ETL Process
  • Module 10: Enforcing Data Quality
  • Module 11: Using Master Data Services
  • Module 12: Extending SQL Server Integration Services (SSIS)
  • Module 13: Deploying and Configuring SSIS Packages
  • Module 14: Consuming Data in a Data Warehouse
  • Module 15: Introduction to Business Intelligence and Data Modeling
  • Module 16: Creating Multidimensional Databases
  • Module 17: Working with Cubes and Dimensions
  • Module 18: Working with Measures and Measure Groups
  • Module 19: Introduction to MDX
  • Module 20: Customizing Cube Functionality
  • Module 21: Implementing a Tabular Data Model by Using Analysis Services
  • Module 22: Introduction to Data Analysis Expression (DAX)
  • Module 23: Performing Predictive Analysis with Data Mining