SQL/ETL Developer - T-SQL/Stored Procedures/ETL/SSIS
3.9 (100 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,522 students enrolled

SQL/ETL Developer - T-SQL/Stored Procedures/ETL/SSIS

Develop an ETL solution using SSIS
3.9 (100 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,522 students enrolled
Last updated 6/2020
English
English [Auto]
Current price: $44.99 Original price: $74.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Install Microsoft SQL Server
  • Install SQL SERVER Data Tools - SSDT
  • Install Visual Studio
  • Download and attach sample database
  • Aggregate Functions
  • Analytic Functions
  • Rank Functions
  • Extract data from multiple tables
  • Create stored procedures
  • Create a new SSIS project
  • Develop and implement ETL process with SSIS
  • Test and Run SSIS Package
Course content
Expand all 71 lectures 06:31:59
+ Introduction
8 lectures 30:05
What is T-SQL
10:27
What is SSIS
03:24
What is a Data Warehouse
03:06
What is a Schema
02:50
Please Read
00:18
+ Setup Visual Studio
5 lectures 27:44
What is Visual Studio
04:32
Minimum Installation Requirements for visual studio 2019
04:27
Installing Visual Studio 2019
08:15
Installing SQL Server Data Tools
04:09
Installing Designers for SSIS,SSAS,SSRS
06:21
+ SQL Server Setup
10 lectures 01:00:18
What is SQL Server
02:57
SQL Server 2019 Hardware | Software Installation Requirements
04:21
SQL Server Editions
04:45
Download SQL Server Developer Edition
04:31
Install SQL Server 2019 Developer Edition
09:43
Installing SQL Server Management Studio
05:48
Connecting to SQL Server with SSMS
07:46
SQL Server Configuration Manager
08:10
Installing adventureworks 2016
06:28
Installing adventureworks 2016DW database
05:49
+ T-SQL Functions
19 lectures 01:49:43
AVG Aggregate Function
07:52
MIN Aggregate Function
06:50
MAX Aggregate Function
06:49
SUM Aggregate Function
07:17
COUNT Aggregate Function
09:24
GROUPING Aggregate Functions
08:10
VAR Aggregate Function
02:40
VARP Aggregate Function
02:20
RANK Function
04:45
NTILE Function
04:47
ROW Number function
05:42
DENSE RANK Function
05:38
Analytic Function Syntax
04:19
LEAD Analytic Function
07:49
LAG Analytic Function
06:35
LAST_VALUE Analytic Function
05:01
First _Value Analytic Function
04:45
CUME_DIST Analytic Function
04:22
PERCENTILE_DISC Analytic Function
04:38
+ Extracting Data From Multiple Tables
4 lectures 42:46
Extracting data using an INNER Join
10:36
Extracting data using a LEFT Outer Join
12:26
Extracting data using a RIGHT OUTER Join
09:30
Extracting data using an FULL OUTER Join
10:14
+ T-SQL Stored Procedure
7 lectures 29:09
Introduction to stored procedures
08:43
Creating stored procedures
07:33
Modifying stored procedures
02:07
Properties page of a stored procedure
04:35
Viewing dependencies of a stored procedure
02:14
Deleting a stored procedure
01:31
Viewing definition of a stored procedure
02:26
+ CRUD Stored Procedures
7 lectures 23:19
What is CRUD
01:20
Naming Convention
00:56
Basic Application Design Structure
02:51
Stored Procedure For CREATE CRUD Operation
06:20
Stored Procedure For READ CRUD Operation
03:32
Stored Procedure For UPDATE CRUD Operation
04:44
Stored Procedure For DELETE CRUD Operation
03:36
+ Developing ETL with SSIS
11 lectures 01:08:55
How to create a new SSIS Project with vs2019
01:41
Create a new SSIS project
05:35
Add a Flat File Connection Manager
06:26
Remap Column Data Types
11:12
Add and Configure OLE DB Connection Manager
03:39
Add a Data Flow Task
05:02
Add and configure Flat File Source
04:28
Add and Configure Lookup Transformation
11:29
Add and Configure Lookup For DateKey Transformation
09:28
Add and Configure OLE DB Destination
07:53
Test and Run Package
02:02
Requirements
  • Basic knowledge of T-SQL
  • Basic knowledge of SQL
  • Basic knowledge of Microsoft SQL Server
Description

A common problem that organizations face is how to gathering data from multiple sources, in multiple formats, and move it to one or more data stores. The destination may not be the same type of data store as the source, and often the format is different, or the data needs to be shaped or cleaned before loading it into its final destination.

Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data according to business rules, and load it into a destination data store.

SQL Server Integration Services (SSIS) is a useful  and powerful Business Intelligence Tool . It is best suited to work with SQL Server Database . It is added to SQL Server Database when you install SQL Server Data Tools  (SSDT)which adds the Business Intelligence Templates to Visual studio that is used to create Integration projects.


SSIS can be used for:

  •  Data Integration

  •  Data Transformation

  •  Providing solutions to complex Business problems

  •  Updating data warehouses

  •  Cleaning data

  •  Mining data

  •  Managing SQL Server objects and data

  •  Extracting data from a variety of sources

  •  Loading data into one or several destinations

What You Will Learn ....

  •  How to install SQL Server Database

  •  How to download and attach a database to SQL Server

  •  How to download and install SQL Server Data Tools

  •  How to Create a New Integration Services Project

  •  How to add and Configuring a Flat File Connection Manager

  •  How to add and Configuring an OLE DB Connection Manager

  •  How to add a Data Flow Task to the Package

  •  How to add and Configuring the Flat File Source

  •  How to add and Configuring the Lookup Transformations

  •  How to Create Integration Services Tasks

  •  How to Create  New Connection Manager

  •  How to Write data to a SQL Server database

  •  How to Execute a package from SQL Server Data Tools

  •  How to Control Data Flow for Flat Files

  •  How to test  Packages 

  • SQL Functions

  • T-SQL Stored procedures

  • Extracting data from multiple tables





Who this course is for:
  • Beginners to ETL Process
  • Beginners to SSIS