Course Duration
4 Weekends
Course Price
₦ 50,000.00
Course Level
Beginner-Intermediate
Course Overview
SQL Server Integration Service is a fast and flexible data warehousing tool used for data extraction, transformation, and data loading. It makes it easy to load the data from one database to another database such as SQL Server, Oracle, Excel file, etc.
This training course was designed to help you understand all aspects of SQL Server Integration Services (SSIS), the ETL tool of choice for SQL Server users. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and you’re prepared to build real world applications using this SQL Server application.
What You Will Learn
- Install and configure components of SSIS
- Create a well-designed package of Business Intelligence Studio
- Understand using different tasks on control flow elements, including various containers
- Use a data flow task to perform an ETL operation
- Write data to multiple destinations
- Write scripts that go beyond basic built-in tasks and ETL processes
- Learn the best practices that will make it easier to maintain a package over task lifecycle
- Administer the storage and security of packages
Course Requirements
- A working PC
- Prior experience with SQL Server
Target Audience
- The target audience of this class is developers, architects or IT professionals who have basic SQL skills.
