Formation : Designing an ETL Solution Architecture using SQL Server 2005 Integration Services
Se former
avec EduGroupe
- Renseignements :
- Durée : 0 Jour
- Type : En centre (inter)
- Diplômant : Non
- Prix H.T. € :
N.C.
- Objectifs :
- After completing this course, students will be able to: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.
- Public visé :
- This course is intended for experienced Business Intelligence (BI) professionals. The target students for this course already have experience of using the SQL Server 2005 tools to implement ETL functionality, but need to develop their understanding of design principles and best practices when planning, implementing, and deploying an ETL solution.
- Pré-requis :
- Before attending this course, students must:Have hands-on experience with database development tasks. For example:Creating Transact-SQL queriesWriting and optimizing advanced queries (for example, queries that contain complex joins or subqueries)Creating database objects such as tables, views, and indexesBe familiar with SQL Server 2005 features, tools, and technologies. In particular, they must have built an SSIS package.Have foundational conceptual understanding of data warehousing, data marts, and Business Intelligence. Students must be well-versed on the subjects of data warehousing, data marts, and BI, and preferably have read at least one book by Ralph Kimball or Bill Inmon.Have a conceptual understanding of ETL processes.Have foundational understanding of Microsoft Windows security. For example, how groups, delegation of credentials, and impersonation function in a security context.Have foundational understanding of Web-based architecture. For example, SSL, SOAP, and IIS-what they are and what their role is.Already know how to use: Microsoft Office Visio - Microsoft SQL Server Business Intelligence Development Studio - Microsoft SQL Server Management Studio - Performance MonitorMicrosoft SQL Server Profiler
- Module 1: Planning for ETLIdentifying Data Sources and DestinationsEvaluating Source DataIdentifying Staging RequirementsLab 1: Planning an ETL SolutionIdentifying ETL RequirementsExamining Source DataModule 2: Planning an SSIS SolutionPlanning PackagesPlanning Package DevelopmentDesigning Package Control FlowLab 2: Implementing SSIS PackagesDesigning an SSIS SolutionCreating a Package TemplateImplementing SSIS PackagesModule 3: Designing Data FlowUnderstanding Data FlowDesigning Data Flow OperationsHandling Data ChangesLab 3: Implementing Data FlowDesigning Data FlowImplementing Data FlowModule 4: Logging, Error Handling, and ReliabilityLogging ETL OperationsHandling Errors in SSISImplementing Reliable ETL Processes with SSISLab 4: Implementing Reliable PackagesImplementing LoggingImplementing Error HandlingImplementing Transactions and CheckpointsModule 5: Optimizing an SSIS SolutionMonitoring SSIS PerformanceOptimizing SSIS PackagesScaling Out SSIS PackagesLab 5: Optimizing PackagesMonitoring SSISOptimizing an SSIS PackageModule 6: Deploying and Operating an SSIS SolutionDeploying SSIS PackagesOperating an SSIS SolutionLab 6: Deploying and Managing PackagesDeploying an SSIS SolutionBacking Up an SSIS Package
