English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 4 Hours | 2.34 GB
Learn the basics of SQL Server Integration Services (SSIS) – with Practical Activities. Useful for 70-763 certification.
Welcome to this course about SQL Server Integration Services.
In this course you’ll be downloading and installing the latest 2016 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.
What you’ll 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.
Table of Contents
2 Introduction to Udemy
3 Do you already have SSIS
4 Do you want auto-translated subtitles in more languages
5 Welcome to Udemy
Installing SSIS in Visual Studio 2019
6 Downloading SQL Server Developer 2019
7 Installing SQL Server Developer 2019
8 Installing SQL Server Management Studio
9 Installing Visual Studio 2019
10 Installing SSIS in Visual Studio 2019
11 Is your Visual Studio a trial version No!
12 Running SSMS and SSIS
13 Looking around SSIS
14 Can’t see the SSIS Toolbox
Level 1 Creating simple Extract and Load tasks
16 Data Flow Task
17 Connection Manager
18 OLE DB Source Task
19 OLE DB Destination
20 Data Viewer
21 Practice Activity – Extract and Load
22 Problems with Connection Manager – reminder
23 Problems with Connection Manager
Adding a bit of Transforming
24 Implicit Conversions
25 Data Conversion
26 Derived Column task
27 Practice Activity – Altering Data Type
30 Conditional Split
31 Error handling
32 Row Sampling and Percentage Sampling
33 Practice Activity – Aggregation
35 Adding an Excel source
36 Add Text source and Excel destination
37 Practice Activity – Percentage Sampling and Conditional Split
38 Union All
39 Merge and solving Mapping problems
40 Add some auditing
41 Adding different destinations
42 Practice Activity – Different data sources, sort, merge and auditing
Adding Control Flow Tasks
43 Adding Variables and Row Count
44 Script component
45 Bonus – An overview of SQL Server
46 Well done!
Old Video – Installing Visual Studio 2017
47 Installing Visual Studio 2017 and SSDT (SQL Server Data Tools)
48 Is your VIsual Basic a trial version No!