SQL Server Training / SQL Server 2016 Training
MOC 20767 - Implementing a SQL Data Warehouse
This SQL Server training class, Microsoft course 20767 - Implementing a SQL Data Warehouse, teaches attendees how to implement a data warehouse platform to support a business intelligence solution. Students learn how to create a data warehouse with Microsoft SQL Server and with Azure SQL Data Warehouse, implement ETL (Extract, Transform, and Load) with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Note: This class is appropriate for SQL Server 2016 and 2017.
Location and Pricing
Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us.
In addition, some courses are available as live, online classes for individuals. See a schedule of online courses.
SQL Server Training Objectives
After completing this course, students will be able to:
SQL Server Training Outline
Introduction to Data Warehousing
Overview of Data Warehousing
Considerations for a Data Warehouse Solution
Planning Data Warehouse Infrastructure
Considerations for Building a Data Warehouse
Data Warehouse Reference Architectures and Appliances
Designing and Implementing a Data Warehouse
Logical Design for a Data Warehouse
Physical Design for a Data Warehouse
Introduction to Columnstore Indexes
Creating Columnstore Indexes
Working with Columnstore Indexes
Implementing an Azure SQL Data Warehouse
Advantages of Azure SQL Data Warehouse
Implementing an Azure SQL Data Warehouse
Developing an Azure SQL Data Warehouse
Migrating to an Azure SQ Data Warehouse
Creating an ETL Solution
Introduction to ETL with SSIS
Exploring Source Data
Implementing Data Flow
Implementing Control Flow in an SSIS Package
Introduction to Control Flow
Creating Dynamic Packages
Debugging and Troubleshooting SSIS Packages
Debugging an SSIS Package
Logging SSIS Package Events
Handling Errors in an SSIS Package
Implementing an Incremental ETL Process
Introduction to Incremental ETL
Extracting Modified Data
Enforcing Data Quality
Introduction to Data Quality
Using Data Quality Services to Cleanse Data
Using Data Quality Services to Match Data
Using Master Data Services
Master Data Services Concepts
Implementing a Master Data Services Model
Managing Master Data
Creating a Master Data Hub
Extending SQL Server Integration Services (SSIS)
Using Custom Components in SSIS
Using Scripting in SSIS
Deploying and Configuring SSIS Packages
Overview of SSIS Deployment
Deploying SSIS Projects
Planning SSIS Package Execution
Consuming Data in a Data Warehouse
Introduction to Business Intelligence
Introduction to Reporting
An Introduction to Data Analysis
Analyzing Data with Azure SQL Data Warehouse
In addition to their professional experience, students should have least 2 years’ experience of working with relational databases, including:
Awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
All SQL Server training students receive Microsoft official courseware.
Software needed for each student PC:
Attendees will not need to install any software on their computer for this class. The class will be conducted in a remote environment that Accelebrate will provide; students will only need a local computer with a web browser with a stable Internet connection. Any recent version of Internet Explorer, Mozilla Firefox, or Google Chrome will be fine.
When you call us about purchasing this class, we will provide a live demo of the online lab environment so that you may explore the web browser interface in more detail.
For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor's screen simultaneously with working on their own.