Kurz je určen pro ...
Audience 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.
[Kurz] Program kurzu (obsah přednášky/semináře/rekvalifikace/studia) ...
Goals 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
* 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
Outline Module 1: Introduction to Data Warehousing Describe data warehouse concepts and architecture considerations. Lessons
- Overview of Data Warehousing
- Considerations for a Data Warehouse Solution
Lab : Exploring a Data Warehouse Solution After completing this module, you will be able to:
- Describe the key elements of a data warehousing solution
- Describe the key considerations for a data warehousing solution
Module 2: Planning Data Warehouse Infrastructure This module describes the main hardware considerations for building a data warehouse. Lessons
- Considerations for Building a Data Warehouse
- Data Warehouse Reference Architectures and Appliances
Lab : Planning Data Warehouse Infrastructure After completing this module, you will be able to:
- Describe the main hardware considerations for building a data warehouse
- Explain how to use reference architectures and data warehouse appliances to create a data warehouse
Module 3: Designing and Implementing a Data Warehouse This module describes how you go about designing and implementing a schema for a data warehouse. Lessons
- Logical Design for a Data Warehouse
- Physical Design for a Data Warehouse
Lab : Implementing a Data Warehouse Schema After completing this module, you will be able to:
- Implement a logical design for a data warehouse
- Implement a physical design for a data warehouse
Module 4: Columnstore Indexes This module introduces Columnstore Indexes. Lessons
- Introduction to Columnstore Indexes
- Creating Columnstore Indexes
- Working with Columnstore Indexes
Lab : Using Columnstore Indexes After completing this module, you will be able to:
- Create Columnstore indexes
- Work with Columnstore Indexes
Module 5: Implementing an Azure SQL Data Warehouse This module describes Azure SQL Data Warehouses and how to implement them. Lessons
- Advantages of Azure SQL Data Warehouse
- Implementing an Az