Total Lessons
20 Lessons
Program Duration
6 Weeks Only
Learning Format
Data integration using SSIS
Course Overview
Data integration using SQL Server Integration Services (SSIS)
₹999.00 – ₹7,999.00
This course will help you work with Integration Services packages in the context of a data warehouse development project to perform extract, transform, and load operations.
This 6 -week duration course will teach you how to apply Integration Services features to build packages that support the extract, transform, and load operations of a data warehouse.
It covers design patterns for staging data and for loading data into fact and dimension tables. In addition, this course describes how to enhance ETL packages with data cleansing techniques and offers insight into the buffer architecture of the data flow engine to help package developers get the best performance from packages.
Offline Course
(Self-Paced)
- 35 hrs of self-learning
- 4-months of LMS Access
- 35 hrs of self-driven exercises/quiz
Online Course
(Trainer Driven Virtual Sessions)
- Live sessions of 35 hrs
- 35 hrs of guided exercises/quiz
- Guided Project and Viva presentation
- 4-months of LMS Access
Description
Learn to use Integration Services to solve complex business problems, loading data warehouses, cleansing and mining data, and managing SQL Server objects.
Additional information
| Classes | Self-Paced Course, Trainer Driven Course |
|---|
Related products
-
Sale!
Core Python
₹999.00 – ₹7,999.00 Enroll Now This product has multiple variants. The options may be chosen on the product page -
Sale!
Data Science using Python
₹999.00 – ₹9,999.00 Enroll Now This product has multiple variants. The options may be chosen on the product page -
Sale!
Generative AI
Original price was: ₹2,999.00.₹999.00Current price is: ₹999.00. Enroll Now This product has multiple variants. The options may be chosen on the product page -
Sale!
Data Analytics using Tableau
₹999.00 – ₹7,999.00 Enroll Now This product has multiple variants. The options may be chosen on the product page
Key Highlights
Trainer Driven Courses
- Access to Question Bank/Exams
- LMS Access for 4 months post enrolment
- Access to Lagozon Technology Team
- Training/Internship Certificates
- Live sessions from Data Engineers/ data scientists and leads from Lagozon Technologies daily
- Access to last 2 days of recorded live session videos for viewing purposes
- Guidance for job readiness and Post Internship Support
- Guidance for technical certifications
- Option for hiring top 3 students as Data Analyst
Self-Paced Courses
- Access to Question Bank/Exams
- LMS Access for 4 months post enrolment
- Course completion certificate
Course Curriculum
- Introduction to SSIS
- Creating a Project and Package
- Developing the Flow Task
- Managing SSIS Projects
- Connections and Variables in a Package
- Sharing Connections between Packages
- Usage of Projects Parameters in Expressions
- Creating the Catalog
- Deploying the Catalog
- Extract and Transform Data
- Executing Packages with an Environment
- Implementing and Transforming a Data Flow
- Lookup, Conditional Split and OLEDB Command
- Using Data Viewer
- Loading Data and Implementing Control Flow
- Executing T-SQL or Stored Procedures
- Configure and Deploy SSIS Packages
- Deploying SSIS Solutions
- Environments and Mapping
- Industry Relevant Project
Skills Covered
Microsoft SQL
ETL
Microsoft Business Intelligence
Integration Services
Data Warehouse
Who can apply?
- Anyone who is passionate to learn and enhance skills in data analytics
- IT/ Non-IT Professionals
- College Graduates
- BI Professionals
- Project Managers
- Engineers from all Non-IT branches – including Civil. Mechanical, Electrical
- MBA and BBA Students from all specializations
- BCA/MCA
Technology Partners and Alliances
Reviews
There are no reviews yet.