Designing a ETL Solution Architecture Using MS SQL Server 2005 (M2795)
Seminar
In Frankfurt Am Main, Karlsruhe, Nürnberg und an 4 weiteren Standorten
Beschreibung
-
Kursart
Seminar
-
Niveau
Anfänger
-
Ort
-
Dauer
2 Tage
Plan data transfer and staging solutions for an ETL operation, Plan an SSIS Solution, Design and implement data flows, Incorporate logging, error handling, and reliability into a package, Optimize an SSIS solution, Deploy and operate an SSIS solution
Standorte und Zeitplan
Lage
Beginn
Beginn
Beginn
Beginn
Beginn
Beginn
Beginn
Beginn
Hinweise zu diesem Kurs
Before attending this course, students must:
Creating Transact-SQL queries
Writing and optimizing advanced queries (for example, queries that contain complex joins or ...
Meinungen
Inhalte
Before attending this course, students must:
Creating Transact-SQL queries
Writing and optimizing advanced queries (for example, queries that contain complex joins or subqueries)
Creating database objects such as tables, views, and indexes
Have foundational understanding of Datawarehousing
Be familiar with SQL Server 2005 features, tools, and technologies.
Must understand the difference between replication and ETL.
Already know how to use:
Microsoft SQL Server Business Intelligence Development Studio
Microsoft SQL Server Management Studio
Planning for ETL
Planning an ETL Solution
Planning an SSIS Solution
Implementing SSIS Packages
Designing Data Flow
Implementing Data Flow
Logging, Error Handling, and Reliability
Implementing Reliable Packages
Optimizing an SSIS Solution
Optimizing Packages
Deploying and Operating an SSIS Solution
Deploying and Managing Packages
Designing a ETL Solution Architecture Using MS SQL Server 2005 (M2795)