Extracting and Transforming Data in SSIS
Focused View
Emilio Melo
2:45:35
38 View
01 - Course Overview.mp4
01:24
02 - What Is SSIS.mp4
03:58
03 - Installing SSIS and Its Prerequisites.mp4
05:37
04 - Creating a New Project and Understanding the SSIS Interface.mp4
06:31
05 - Module Summary.mp4
00:41
06 - Creating Connection Managers.mp4
02:29
07 - Creating Connection Managers (Demo).mp4
03:03
08 - Creating Tasks.mp4
02:37
09 - Linking Tasks.mp4
03:49
10 - Linking Tasks (Demo).mp4
03:39
11 - Executing a Package.mp4
01:23
12 - Module Summary.mp4
00:54
13 - Working with Variables.mp4
04:47
14 - Working with Variables (Demo).mp4
04:33
15 - Containers and Loops.mp4
02:00
16 - Sequence Containers.mp4
03:25
17 - For foreach Containers.mp4
01:20
18 - For Loop Container.mp4
04:25
19 - For Each Loop Container.mp4
03:37
20 - The Execute SQL Task.mp4
02:00
21 - The Execute SQL Task (Demo).mp4
07:53
22 - Module Summary.mp4
00:57
23 - The Bulk Insert Task.mp4
02:24
24 - The Bulk Insert Task (Demo).mp4
05:58
25 - Working with Files.mp4
03:10
26 - Running Other Packages.mp4
01:18
27 - Running Other Packages (Demo).mp4
02:31
28 - Executing External Processes.mp4
01:23
29 - Executing External Processes (Demo).mp4
02:32
30 - Executing Scripts.mp4
00:58
31 - Executing Scripts (Demo).mp4
02:48
32 - Sending Emails.mp4
01:23
33 - Sending Emails (Demo).mp4
04:45
34 - Module Summary.mp4
00:52
35 - SSIS Sources and Destinations.mp4
07:18
36 - SSIS Sources.mp4
10:37
37 - SSIS Destinations.mp4
05:51
38 - Copying and Deriving Columns.mp4
01:01
39 - Copying and Deriving Columns (Demo).mp4
04:34
40 - Converting Data Types.mp4
01:39
41 - Converting Data Types (Demo).mp4
03:14
42 - Sorting Data.mp4
01:36
43 - Sorting Data (Demo).mp4
01:55
44 - Performing Lookups.mp4
02:24
45 - Performing Lookups (Demo).mp4
04:18
46 - Module Summary.mp4
00:45
47 - Merge and Union All.mp4
01:32
48 - Merge (Demo).mp4
02:39
49 - Conditional Splits.mp4
01:14
50 - Conditional Splits (Demo).mp4
03:29
51 - Union All.mp4
02:00
52 - Multicast.mp4
02:44
53 - Adding the Destinations.mp4
04:20
54 - Module Summary.mp4
01:21
Description
SSIS is the main on-premises ETL (Extract, Transform, and Load) tool from Microsoft, and it's heavily utilized for data engineering on SQL Server. In this course, you'll learn how to install and configure SSIS, and develop ETL packages with it.
What You'll Learn?
- Building a data warehouse
- Ransforming unstructured or semi-structured files into valuable insights, or
- Loading massive amounts of information for data sciences operations
Data engineering is in the backbone of advanced analytics, business intelligence, and machine learning activities, and is also one of the most exciting and rewarding professions in the IT industry today.
SSIS is the main SQL Server tool for achieving ETL (Extract, Transform, and Load) goals, whether you are:
First, you'll discover how to use conditional logic and loops to control your data flow.
Next, you'll delve into integrating data from sources other than databases. Then, you'll explore additional processes, scripts, and packages to expand your ETL capabilities beyond SSIS.
Finally, you'll learn how to transform data using Data Flow operations, and pipe data by Split, Merge, and Union operations.
By the end of this tutorial, you'll be able to use SSIS to execute fundamental ETL processes.
More details
User Reviews
Rating
average 0
Focused display
Category
Emilio Melo
Instructor's CoursesEmilio Melo is a globetrotting IT professional with projects in over 15 countries, mostly focused on Microsoft software. After 15 years of On Premises experience in Infrastructure, Data and Collaboration, he became fascinated by Cloud technologies and the incredible transformation potential it brings.
Pluralsight
View courses PluralsightPluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.
- language english
- Training sessions 54
- duration 2:45:35
- level average
- Release Date 2023/10/11
