Audience: IT Professionals | Technology: SQL Server | Level: 300
This course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.
At course completion
After completing this course, students will be able to:
- Provision a Database Server.
- Upgrade SQL Server.
- Configure SQL Server.
- Manage Databases and Files (shared).
|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 a Data Extraction Solution|
|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|