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

Focused View

Bluelime Learning Solutions

6:31:41

60 View

1. Introduction

1. Introduction.mp4

01:50

2. What is SQL.mp4

02:29

3. What is ETL .mp4

05:41

4. What is T-SQL.mp4

10:27

5. What is SSIS.mp4

03:24

6. What is a Data Warehouse.mp4

03:06

7. What is a Schema.mp4

02:50

8. Please Read.html

2. Setup Visual Studio

1. What is Visual Studio.mp4

04:32

2. Minimum Installation Requirements for visual studio 2019.mp4

04:27

3. Installing Visual Studio 2019.mp4

08:15

4. Installing SQL Server Data Tools.mp4

04:09

5. Installing Designers for SSIS,SSAS,SSRS.mp4

06:21

3. SQL Server Setup

1. What is SQL Server.mp4

02:57

2. SQL Server 2019 Hardware Software Installation Requirements.mp4

04:21

3. SQL Server Editions.mp4

04:45

4. Download SQL Server Developer Edition.mp4

04:31

5. Install SQL Server 2019 Developer Edition.mp4

09:43

6. Installing SQL Server Management Studio.mp4

05:48

7. Connecting to SQL Server with SSMS.mp4

07:46

8. SQL Server Configuration Manager.mp4

08:10

9. Installing adventureworks 2016.mp4

06:28

10. Installing adventureworks 2016DW database.mp4

05:49

4. T-SQL Functions

1. AVG Aggregate Function.mp4

07:52

2. MIN Aggregate Function.mp4

06:50

3. MAX Aggregate Function.mp4

06:49

4. SUM Aggregate Function.mp4

07:17

5. COUNT Aggregate Function.mp4

09:24

6. GROUPING Aggregate Functions.mp4

08:10

7. VAR Aggregate Function.mp4

02:40

8. VARP Aggregate Function.mp4

02:20

9. RANK Function.mp4

04:45

10. NTILE Function.mp4

04:47

11. ROW Number function.mp4

05:42

12. DENSE RANK Function.mp4

05:38

13. Analytic Function Syntax.mp4

04:19

14. LEAD Analytic Function.mp4

07:49

15. LAG Analytic Function.mp4

06:35

16. LAST VALUE Analytic Function.mp4

05:01

17. First Value Analytic Function.mp4

04:45

18. CUME DIST Analytic Function.mp4

04:22

19. PERCENTILE DISC Analytic Function.mp4

04:38

5. Extracting Data From Multiple Tables

1. Extracting data using an INNER Join.mp4

10:36

2. Extracting data using a LEFT Outer Join.mp4

12:26

3. Extracting data using a RIGHT OUTER Join.mp4

09:30

4. Extracting data using an FULL OUTER Join.mp4

10:14

6. T-SQL Stored Procedure

1. Introduction to stored procedures.mp4

08:43

2. Creating stored procedures.mp4

07:33

3. Modifying stored procedures.mp4

02:07

4. Properties page of a stored procedure.mp4

04:35

5. Viewing dependencies of a stored procedure.mp4

02:14

6. Deleting a stored procedure.mp4

01:31

7. Viewing definition of a stored procedure.mp4

02:26

7. CRUD Stored Procedures

1. What is CRUD.mp4

01:20

2. Naming Convention.mp4

00:56

3. Basic Application Design Structure.mp4

02:51

4. Stored Procedure For CREATE CRUD Operation.mp4

06:20

5. Stored Procedure For READ CRUD Operation.mp4

03:32

6. Stored Procedure For UPDATE CRUD Operation.mp4

04:44

7. Stored Procedure For DELETE CRUD Operation.mp4

03:36

8. Developing ETL with SSIS

1. How to create a new SSIS Project with vs2019.mp4

01:41

2. Create a new SSIS project.mp4

05:35

3. Add a Flat File Connection Manager.mp4

06:26

4. Remap Column Data Types.mp4

11:12

5. Add and Configure OLE DB Connection Manager.mp4

03:39

6. Add a Data Flow Task.mp4

05:02

7. Add and configure Flat File Source.mp4

04:28

8. Add and Configure Lookup Transformation.mp4

11:29

9. Add and Configure Lookup For DateKey Transformation.mp4

09:28

10. Add and Configure OLE DB Destination.mp4

07:53

11. Test and Run Package.mp4

02:02

12. Thank You.html

Description

Develop an ETL solution using SSIS

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

Who is this for?

Beginners to ETL Process

Beginners to SSIS

What You Need to Know?

Basic knowledge of T-SQL

Basic knowledge of SQL

Basic knowledge of Microsoft SQL Server

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.