SQL Server Integration Services (SSIS) - An Introduction

Learn the basics of SQL Server Integration Services (SSIS) - with Practical Activities.

4.50 (8729 reviews)
Udemy
platform
English
language
Other
category
instructor
SQL Server Integration Services (SSIS) - An Introduction
34,184
students
4 hours
content
Apr 2024
last update
$99.99
regular price

What you will learn

Do Extraction, Transform and Load (ETL) tasks.

You can use SQL Server tables, Excel spreadsheets and text files as your source.

You'll be able to change data types, add columns, aggregate, split, sort and join

You can then view what has been created, and save it to spreadsheet, database tables, or the clipboard.

Why take this course?

Reviews:

"Instructor is easy to follow. He gives very clear examples. Course moves quickly enough to be engaging without skipping over material." -- Sarah Hale

"This course works for me because it progresses with a level of detail that will be useful as I think through each step necessary to execute my own integration packages. There are several courses to choose from and I'm glad I chose this one." -- David McNickle

"Very good introductory course. Didn't really know what SSIS was until recently. Working through the course opened my eyes to past projects that would have benefited from an SSIS ETL package or two." -- Stephen Benton

Welcome to this course about SQL Server Integration Services.

In this course you'll be downloading and installing the latest 2022 SQL Server Developer – a full version for free, so that you can use it on your machine. And previous versions of SQL Server Developer have previously retailed for around $100, and now it’s free.   

So what is SSIS? It’s a way to automate in the importing and exporting and data – or ETL: extract, transform and load. It’s a very visual part of SSIS, using tasks, components and flowcharts, so it’s easy to learn the basics of it.  

We’ll start by extracting some data, and then loading it into another table. I’ll take nice as slow as we start to introduce transformations, such as aggregation, conditional split, merging and auditing. There’ll be plenty of practice activities too, so you can get to practice your new-found skills.

By the end of this course, you'll be confident in using the main Data Flow components and Control Flow tasks, and would be able to use it in your own work.

Screenshots

SQL Server Integration Services (SSIS) - An Introduction - Screenshot_01SQL Server Integration Services (SSIS) - An Introduction - Screenshot_02SQL Server Integration Services (SSIS) - An Introduction - Screenshot_03SQL Server Integration Services (SSIS) - An Introduction - Screenshot_04

Our review

🏫 **Global Course Rating:** 4.50/5 ## Pros: - 🚀 **Comprehensive Introduction to SSIS:** The course serves as an excellent introductory resource for beginners looking to understand the major components of SSIS. - ✨ **Clear Instructions and Pacing:** The tutorials are explained in a straightforward, easy-to-understand manner with great pacing. - 🛠️ **Solid Practical Foundation:** Many users have reported solidifying their understanding through practices at the end of each section. - 👍 **Knowledgeable Instructor:** The instructor is knowledgeable and capable of articulating messages clearly, which is a significant plus for learners. - 🎓 **Beginner-Friendly:** The course structure, overall experience, and explanations are well-suited for new learners of SSIS. - 🌟 **Positive Learning Experience:** A majority of the recent reviews highlight a positive learning experience, with many expressing gratitude for the course content and teaching approach. ## Cons: - ⏳ **Outdated Content Warning:** Some users have pointed out that the course content is mostly from 2015, with recent updates or notes to address newer versions. This discrepancy may cause confusion and requires more clarity in the course description. - 🖨️ **Versioning Issues:** There are issues with versioning, particularly with Visual Studio, where instructions may not align with the latest versions (e.g., VS2022). Users recommend being aware of the version you are using and referring to comments for fixes. - 🔧 **Lack of Deployment Projects:** Some reviews mention a lack of detailed information on deploying projects or handling real-world use cases, which could enhance understanding. - 📚 **Repetitive Information:** Extraneous and repetitive information, such as windows sizing and naming conventions, is deemed unnecessary by some users. - 🤔 **Need for Prior Installation Guidance:** The course would benefit from a comprehensive introduction that covers all steps at the beginning before detailing each step, making it clearer why certain tools like SSMS, SSIS, etc., are needed. ## User Feedback Summary: Most users have found the course to be highly beneficial for beginners, with many praising the instructor's ability to explain concepts and the overall structure of the course. However, there are concerns about the outdated nature of some content and the potential confusion caused by versioning issues, especially for those using the latest versions of the tools. The course could be improved by ensuring all content is up-to-date and providing more in-depth coverage on deployment and use cases. Additionally, it would be helpful to streamline the installation guidance and avoid unnecessary repetitive information. Overall, while there are some areas for improvement, the course remains a solid choice for beginners looking to start with SSIS. Users recommend being mindful of the versioning issues and referring to updates in comments or recent user feedback when following along with the course material.

Charts

Price

SQL Server Integration Services (SSIS) - An Introduction - Price chart

Rating

SQL Server Integration Services (SSIS) - An Introduction - Ratings chart

Enrollment distribution

SQL Server Integration Services (SSIS) - An Introduction - Distribution chart
905246
udemy ID
7/14/2016
course created date
11/21/2019
course indexed date
Bot
course submited by