Support

SQL 2005 Integration Services Training Course | Designing an ETL Solution Architecture

5 sessions available starting from $1,360.00

Subject: Microsoft Sql Server

Ages: All ages

Skill level: All difficulty levels

Course Code: 2795
Course Duration: 2 days

This two-day instructor-led (Level 300) course will teach Business Intelligence (BI) professionals to design an extract, transform, and load (ETL) solution that supports their BI solution. Students will learn how to plan an ETL solution, and specifically how to design and implement a SQL Server Integration Services (SSIS) based ETL solution. They will also learn how to monitor, optimise, and deploy an SSIS solution. The course focuses on the planning and design aspects of an ETL solution and does not teach students how to create SSIS packages or how to use the development tools provided with SQL Server 2005.

Skills Gained

After completing this course, students will be able to:

• Plan data transfer and staging solutions for an ETL operation...

see more

Course Code: 2795
Course Duration: 2 days

This two-day instructor-led (Level 300) course will teach Business Intelligence (BI) professionals to design an extract, transform, and load (ETL) solution that supports their BI solution. Students will learn how to plan an ETL solution, and specifically how to design and implement a SQL Server Integration Services (SSIS) based ETL solution. They will also learn how to monitor, optimise, and deploy an SSIS solution. The course focuses on the planning and design aspects of an ETL solution and does not teach students how to create SSIS packages or how to use the development tools provided with SQL Server 2005.

Skills Gained

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
• Optimise an SSIS solution
• Deploy and operate an SSIS solution

Course Modules

Module 1: Planning for ETL
In this module, Students will learn how to plan the way in which data will be transferred and staged in an ETL solution.

Module 2: Planning an SSIS Solution
In this module, students will learn how to plan an SSIS-based ETL solution. Specifically, they will learn how to plan SSIS packages, how to plan an effective package development process, and how to design the control flow within the packages.

Module 3: Designing Data Flow
In this module, students will learn how to design data flows that extract, transform, and load data. They will also learn about factors to consider when working with slowly changing dimensions (SCDs) and when implementing custom SCD transformations.

Module 4: Logging, Error Handling and Reliability
In this module, students will learn how to incorporate logging, error handling, and reliability into your SSIS package designs. The module covers standard logging, custom logging, and log reporting. The module also teaches students how to implement error handling and how to handle bad data. Finally, the module shows students how to implement a transaction strategy, use checkpoints, and handle restarts and rollbacks.

Module 5: Optimising an SSIS Solution
In this module students will learn how to monitor and optimize SSIS performance. They will also learn how to scale-out SSIS packages.

Module 6: Deploying and Operating an SSIS Solution
This module describes considerations for deploying an SSIS solution into a production environment. It also discusses some of the issues related to operations and management that you must consider when planning an SSIS solution.

Who Should Attend

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.

Prerequisites

Before attending this course, students must have:

• Hands-on experience with database development tasks. For example:
• Creating Transact-SQL queries
• Writing and optimising advanced queries (for example, queries that contain complex joins or subqueries)
• Creating database objects such as tables, views, and indexes
• Be 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 Monitor
• Microsoft SQL Server Profiler

see less

Choose from 5 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $1,360.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $1,360.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $1,360.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $1,360.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $1,360.00

Type

  • Class / Group Sessions



Reviews

John Weber
Good experience!
  • 5/5 stars

I took CCNA class in MIS. It was pretty good, the course was hands-on and teacher was instructional. I was also...
John Weber

see all reviews »


My Other Listings

SharePoint 2010 Training Course | Overview for End Users
SharePoint 2010 Training Course | Overview for End Users
5 sessions available starting from $2,040.00
Designing Security for Microsoft Networks 3 Day Course
Designing Security for Microsoft Networks 3 Day Course
6 sessions available starting from $1,800.00
Implementing Microsoft Office SharePoint Server 2007 Training Course
Implementing Microsoft Office SharePoint Server 2007 Training Course
1 session available for $2,040.00

see all listings »


Found In