Implementing a Data Warehouse with Microsoft® SQL Server® 2012 (MOC10777)
Build the skills to implement a Business Intelligence data warehouse for your organization. This instructor led course discusses how to cleanse and integrate data sources into a data warehouse. You will perform hands-on tasks in a virtual lab environment. This course maps to the skills and knowledge measured by Microsoft Exam 70-463, and in conjunction with on-the-job experience, can help prepare you for the exam.
Kurz je zaradený v kategórii: |
Databáze → Microsoft SQL → MS SQL Microsoft |
Náročnosť kurzu: pokročilý
Délka kurzu: 5 dní
Náplň kurzu:
- Introduction to Data Warehousing
- Data Warehouse Hardware
- Designing and Implementing a Data Warehouse
- Creating an ETL Solution with SSIS
- Implementing Control Flow in an SSIS Package
- Debugging and Troubleshooting SSIS Packages
- Implementing an Incremental ETL Process
- Incorporating Data from the Cloud into a Data Warehouse
- Enforcing Data Quality
- Using Master Data Services
- Extending SQL Server Integration Services
- Deploying and Configuring SSIS Packages
- Consuming Data in a Data Warehouse
Predpokladané znalosti: 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.
.Termíny kurzu:
Tento kurz už nie je v našej ponuke. Pre viac informácií alebo ak máte záujem o realizáciu nás kontaktujte na skoleni@pcdir.cz alebo telefónu +420 543 533 610.