LIVEINAR - Implementing a SQL Data Warehouse
Kurs
Online
Beschreibung
-
Kursart
Kurs
-
Methodik
Online
-
Dauer
5 Tage
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.
Meinungen
Themen
- Design
- SQL
- Hardware
Inhalte
- 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
Zusätzliche Informationen
*+ At least 2 years? experience of working with relational databases, including:
*+ Designing a normalized database.
*+ Creating tables and relationships.
*+ Querying with Transact-SQL.
*+ Some exposure to basic programming constructs (such as looping and branching).
*+ An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
LIVEINAR - Implementing a SQL Data Warehouse