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.
Der Kurs ist der Kategorie zugeordnet: |
Databáze → Microsoft SQL → MS SQL Microsoft |
Kursstufe: Fortgeschritten
Course duration: 5 days
Kursinhalt:
- 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
Erforderliche Kenntnisse: 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.
.Kurstermine:
Das ist natürlich nicht mehr in unserem Angebot. Für weitere Informationen oder wenn Sie Interesse an der Durchführung kontaktieren Sie uns unter skoleni@pcdir.cz oder Telefon +420 543 533 610.