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:

27.08. 31.08.2018 Praha
25 450 CZK (bez DPH)
03.09. 07.09.2018 Ostrava
25 450 CZK (bez DPH)
03.09. 07.09.2018 Brno
25 450 CZK (bez DPH)
03.09. 07.09.2018 Bratislava 1 000 EUR (bez DPH) objednať
17.09. 21.09.2018 Košice 1 000 EUR (bez DPH) objednať
17.09. 21.09.2018 Praha 25 450 CZK (bez DPH) objednať
01.10. 05.10.2018 Bratislava 1 000 EUR (bez DPH) objednať
01.10. 05.10.2018 Brno 25 450 CZK (bez DPH) objednať
15.10. 19.10.2018 Praha 25 450 CZK (bez DPH) objednať
22.10. 26.10.2018 Bratislava 1 000 EUR (bez DPH) objednať