- Home
- /
- Rechenzentrum, Netzwerke & Cloud
- /
- Enterprise Services
- /
- Microsoft
- /
- Microsoft SQL Server 2016
- /
- Implementing a SQL Data...
Implementing a SQL Data Warehouse
Schulungsinhalt
– 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
Zielgruppe
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.
Seminarziele
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
Vorkenntnisse
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
– 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.
Seminardauer
Preis
Präsenzseminar/FLEXINAR®:
LIVEINAR®:
Individual Training: Preis auf Anfrage
Inhouse Training: Preis auf Anfrage
Seminarnummer
Martin Heubeck
Group Leader Sales
- martin.heubeck@protranet.de
Beratungszentrale und Buchungshotline:
- 0800 3400311
- beratung@protranet.de
Kataloge
Formate
