Kurs: SQL Server 2012 - Implementing a Data Warehouse with Microsoft SQL Server 2012 (ref. kurs 10777)

Pris: 22500,-Varighet: 5 dager

Aktuelle SQL Server 2012 - Implementing a Data Warehouse with Microsoft SQL Server 2012 (ref. kurs 10777) kurs

Ingen planlagte kurs?
Vi har for tiden ingen planlagte kurs i SQL Server 2012 - Implementing a Data Warehouse with Microsoft SQL Server 2012 (ref. kurs 10777), men send oss en epost, eller ring oss på 32 20 09 90, så finner vi en løsning!

This 5-day instructor-led course describes how to implement a BI platform to support information worker analytics. Students will learn how to create a data warehouse with SQL Server “Denali”, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. This course helps people prepare for the exam 70-463.

Målsetting SQL Server 2012 - Implementing a Data Warehouse with Microsoft SQL Server 2012 (ref. kurs 10777) kurs

After completing this course, students will be able to:
•Describe data warehouse concepts and architecture considerations.
•Select an appropriate hardware platform for a data warehouse.
•Design and implement a data warehouse.
•Implement Data Flow in an SSIS Package.
•Implement Data Flow in an SSIS Package.
•Debug and Troubleshoot SSIS packages.
•Implement an SSIS solution that supports incremental DW loads and changing data.
•Integrate cloud data into a data warehouse ecosystem infrastructure.
•Implement data cleansing by using Microsoft Data Quality Services.
•Implement Master Data Services to enforce data integrity at source.
•Extend SSIS with custom scripts and components.
•Deploy and Configure SSIS packages.
•Describe how information workers can consume data from the data warehouse

Forkunnskaper SQL Server 2012 - Implementing a Data Warehouse with Microsoft SQL Server 2012 (ref. kurs 10777) kurs

In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:
•10774A: Writing Queries with Microsoft SQL Server Transact-SQL

Dokumentasjon SQL Server 2012 - Implementing a Data Warehouse with Microsoft SQL Server 2012 (ref. kurs 10777) kurs

Microsoft Official Documentation eller MS Press.

Kursinnhold SQL Server 2012 - Implementing a Data Warehouse with Microsoft SQL Server 2012 (ref. kurs 10777) kurs

Se link til originalkurset her.

Metodikk SQL Server 2012 - Implementing a Data Warehouse with Microsoft SQL Server 2012 (ref. kurs 10777) kurs

Gateway tilbyr praktisk og virkelighetsnær opplæring.

I tillegg til å jobbe med kurs og opplæring, er våre instruktører også konsulenter som jobber med utvikling og problemløsninger i den aktuelle programvare. Dette betyr at instruktørene kjenner den praktiske bruk av programmet i ulike bedriftsmiljøer.

Vi har som oftest små grupper på kurs, slik at kursleder kan ta seg av hver enkelt. Alle deltakere får egen PC under kurset. Kursleder vil vise ulike teknikker på storskjerm, deltakerne vil deretter få oppgaver der de kan prøve ut disse teknikkene.