Read more
2 Month/20 Hours Price:85000
80,000
ETL with Microsoft SQL Server Integration Services (SSIS)
Microsoft SQL Server Integration Services (SSIS) is a platform for building high-performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing. In this course, you’ll extract data from a wide variety of data sources, such as files and relational data sources, perform data integration and transformation solutions, and load data into single or multiple destinations. You will solve complex business problems using best practices and troubleshooting techniques.
At the end of this course, you will be comfortable building an ETL package, moving data around systems, Transforming data using SSIS controls like Fuzzy Lookup, Web service tasks, Email Tasks etc. and configuring and deploying production quality packages with tasks like SSIS logging and checkpoint tasks.
Microsoft SQL Server Integration Services (SSIS) features graphical tools and wizards for:
Building and debugging packagesTasks for performing workflow functions
Executing SQL statements
Data sources and destinations for extracting and loading data
Transformations for cleaning, aggregating, merging, and copying data
Integrate, transform and load data into single or multiple destinations
Course Key Learning (24 Credit hrs)
Deciding on full or incremental loadingIsolating ETL data, Creating an ETL script, ETL abstraction layers
The design environment, Control flows, Data sources
Data transformations, Data destinations
Precedence constraints, Connection managers
Execute SQL tasks, Progress/execution results, Resetting destination database
Data flows, Data flow paths, Error output paths
Configuring data sources and destinations
Executing SSIS packages, Deploying SSIS packages
Course Topics
Module 1 – ETL Processing
ETL OverviewETL Tools
Data Sources and Destinations
Creating Example Databases
Module Summary
Module 2 – ETL With SQL Programming
ETL ScriptsTransformations
Implementing ETL with SQL Objects
Programming an ETL Process with SQL
Module Summary
Module 03 – ETL Processing with SSIS
Creating SSIS ProjectsProgramming SSIS Packages
Execute SQL Tasks
Implementing SSIS Packages
Creating an ETL Process with SSIS
Module Summary
Module 04 – SSIS Data Flows
Creating Data FlowsData Flow Transformations
Performance Options
Creating an SSIS ETL Package Using Data Flow Tasks
Module Summary
Module 05 – Deployment and Troubleshooting
Error HandlingDeployment
Module Summary
Final Assessment
This course requires that you meet the following prerequisites:
A familiarity with Basic SQL Query and Transactional statements (select, insert, update, delete)Working knowledge of relational databases
Some experience with database design
International Student FEE : USD 1,000 | 3,750 AED | 3,750 SAR
Job Interview Preparation (Soft Skills Questions & Answers)
Tough Open-Ended Job Interview QuestionsWhat to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview
Stay connected even when you’re apart
Join our WhatsApp Channel – Get discount offers
500+ Free Certification Exam Practice Question and Answers
Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Join Internships and Referral Program (click for details)
Work as Freelancer or Full-Time Employee (click for details)
Flexible Class Options
Week End Classes For Professionals SAT | SUN
Corporate Group Training Available
Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Oracle HCM Cloud – Fusion Human Capital Management
ETL with Microsoft SQL Server Integration Services (SSIS)
0 Reviews