SQL Server Integration Services (SSIS) Basic kursus

You will learn

In course in Integration Services (SSIS) you will learn how to create ETL (Extract Transform and Load) solutions with Microsoft SQL Server Integration Services. You will learn how to extract data from different data sources and consolidate and cleanse the data before loading it into dimension - and fact tables in a Data Warehouse or Data Mart. You will also learn how to create robust packages and projects with logging and error handling and you will learn how to design and plan a deployment strategy for your projects. You will also learn how to manage and configure a SSIS catalog and secure access to your projects.

After completing this course you will be able to:

• Create SQL Server Integration Services solutions
• Create and implement Control Flows
• Create and implement Data Flows
• Create Event Handlers
• Manage error handling
• Design and plan a Deployment Strategy
• Schedule Execution of Packages
• Secure Access to Packages and Projects

You get

During the course

• Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
• A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
• A course material you can use as an encyclopedia after the course and downloads of course exercises.
• All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant on Gråbrødretorv, cake, candy and off cause Wi-Fi to your devices.
• A course certificate as a proof of your new skills.

After the course

• Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
• We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course.

Get the best benefit from the course

This course is a part of 4D's unique collection of English conducted courses and the primary audience for this course are Business Intelligence Developers who wants to be able to implement and maintain business intelligence solutions.

This is a technical course and we expect that you have attended our "Business Intelligence Grundlæggende" and SQL Basic course or have acquired similar experience about business intelligence, dimensional data modelling and SQL. Knowledge of programming with e.g. VB scripting is an advantage as well.

Course Details