MENU
Úvod
Kurzy
Implementing a Data Warehouse with Microsoft® SQL Server® 2012
záujem o kurz

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óriách: Microsoft Official Course
DatabázeMicrosoft SQLMS SQL 2012/2014
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:

31.12.2018 04.01.2019 Praha
25 450 CZK (bez DPH)
07.01. 11.01.2019 Bratislava
1 000 EUR (bez DPH)
07.01. 11.01.2019 Brno
25 450 CZK (bez DPH)