Microsoft BI – SQL Server Integration Service (SSIS) Course
Microsoft BI – SQL Server Integration Service (SSIS) Course, available at $19.99, has an average rating of 1, with 12 lectures, based on 1 reviews, and has 6 subscribers.
You will learn about MSBI – Microsoft Business Intelligence SSIS – SQL Server Integration Services Building data warehouse Building dimensional data model This course is ideal for individuals who are Programmers or Business Analyst or BI professional or Students It is particularly useful for Programmers or Business Analyst or BI professional or Students.
Enroll now: Microsoft BI – SQL Server Integration Service (SSIS) Course
Summary
Title: Microsoft BI – SQL Server Integration Service (SSIS) Course
Price: $19.99
Average Rating: 1
Number of Lectures: 12
Number of Published Lectures: 12
Number of Curriculum Items: 12
Number of Published Curriculum Objects: 12
Original Price: ₹3,299
Quality Status: approved
Status: Live
What You Will Learn
- MSBI – Microsoft Business Intelligence
- SSIS – SQL Server Integration Services
- Building data warehouse
- Building dimensional data model
Who Should Attend
- Programmers
- Business Analyst
- BI professional
- Students
Target Audiences
- Programmers
- Business Analyst
- BI professional
- Students
This course covers SSIS from Basics to Advanced Levels
SSIS – SQL Server Integration Services
SSIS:
SSIS makes it easy to create robust and complex solutions for extracting, Transforming and Loading the data.
These will help you to design, create, deploy and manage packages that address everyday business requirements.
SSIS can be used for data migration as well as data integration purpose.
Sections in SSIS Designer:
Control Flow:
Work flow of task execution / order of tasks execution.
Controlling the flow of SSIS package execution.
Data Flow: ETL
It contains extracting the data from one more sources with the help of source adapters, performing transformations and loading the data into one more destinations with the help of destination adapters.
Event Handlers:
It allows you to implement error handling and debugging of control flow tasks in SSIS packages.
Package Explorer:
It allows you to browse the package contents. Package contains tasks, precedence constraints, log providers, variables, event handlers and connection managers.
Parameters:
Parameters are the replacement for configurations that are in the current version of SSIS. It allows you to assign values to properties within packages at the time of package execution.
Connection Manager:
It maintains all connections used by the different tasks and adapters in the package.
A connection manager is a logical representation of a connection
Course Curriculum
Chapter 1: SSIS Tutorials
Lecture 1: Introduction to Ms-BI and Building Data Warehouse
Lecture 2: Understanding Data flow task, OLE DB source and Merge Join
Lecture 3: Understanding Derived Column Transformation and OLE DB Destination
Lecture 4: Transferring data from multiple source to SQL Destination
Lecture 5: Understanding Union All and Data Conversion Transformation
Lecture 6: Aggregate Transformation
Lecture 7: Conditional Split Transformation
Lecture 8: Union All Transformation
Lecture 9: OLEDB Command Transformation
Lecture 10: Row count and Script Component Transformation
Lecture 11: Multi Cast Transformation
Lecture 12: Slowly Changing Dimension Transformation
Instructors
-
Amit Kumar
Technology Consultant, Corporate BI and Analytics Trainer
Rating Distribution
- 1 stars: 1 votes
- 2 stars: 0 votes
- 3 stars: 0 votes
- 4 stars: 0 votes
- 5 stars: 0 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024