MENU
Vorwort
Kurse
Implementing a Data Warehouse with Microsoft® SQL Server® 2012
Interesse für den Kurs

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 den Kategorien zugeordnet: Microsoft Official Course
DatabázeMicrosoft SQLMS SQL 2012/2014
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:

28.05. 01.06.2018 Bratislava
1 000 EUR (Ohne MwSt.)
11.06. 15.06.2018 Praha
25 450 CZK (Ohne MwSt.)
18.06. 22.06.2018 Bratislava 1 000 EUR (Ohne MwSt.) Bestellen
18.06. 22.06.2018 Brno
25 450 CZK (Ohne MwSt.)
09.07. 13.07.2018 Praha 25 450 CZK (Ohne MwSt.) Bestellen
09.07. 13.07.2018 Bratislava 1 000 EUR (Ohne MwSt.) Bestellen
16.07. 20.07.2018 Brno 25 450 CZK (Ohne MwSt.) Bestellen