Course details
This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
Course Outline
1 - Introduction to SQL Server 2008 Integration Services
- Overview of SQL Server Integration Services
- Using Integration Services Tools
2 - : Developing Integration Services Solutions
- Creating an Integration Services Solution
- Using Variables
- Building and Running a Solution
3 - Implementing Control Flow
- Control Flow Tasks
- Control Flow Precedent Constraints
- Control Flow Containers
4 - Implementing Data Flow
- Data Flow Sources and Destinations
- Basic Data Flow Transformations
- Advanced Data Flow Transformations
- Data Flow Paths
5 - Implementing Logging
- Overview of Integration Services Logging
- Using Logging
6 - Debugging and Error Handling
- Debugging a Package
- Implementing Error Handling
7 - Implementing Checkpoints and Transactions
- Implementing Checkpoints
- Implementing Transactions
8 - Configuring and Deploying Packages
- Package Configurations
- Preparing and Deploying Packages
9 - Managing and Securing Packages
- Managing Packages
- Securing Packages
Target Audience: This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services.
Related Certifications:
- Microsoft Certified Solutions Associate (MCSA): SQL Server 2008
- Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance
Course Location
About New Horizons Ireland
With a very convenient location next to Jervis street in Dublin 1, we offer a wide range of IT and business skills courses and we can also send our instructors to your location.
We are 100% Irish owned, but we are also part of the largest independent IT Training Provider, New Horizons Computer Learning Centres who deliver more courses than any other IT training company.
Because we're local, we understand the needs of business and individuals in our community. Whether you choose to take classes in person or online, you're always welcome to call or stop by.
See all New Horizons Ireland courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Database Global CoursesEUR 14
EUR 130Duration: 2 Hours - Administering Microsoft SQL Server 2012 Databases Global EdulinkEUR 93
EUR 658Duration: Upto 16 Hours