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

SQL/ETL Developer – T-SQL/Stored Procedures/ETL/SSIS, available at $64.99, has an average rating of 3.2, with 83 lectures, based on 235 reviews, and has 4106 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginners to ETL Process or Beginners to SSIS It is particularly useful for Beginners to ETL Process or Beginners to SSIS.

Enroll now: SQL/ETL Developer – T-SQL/Stored Procedures/ETL/SSIS

Summary

Title: SQL/ETL Developer – T-SQL/Stored Procedures/ETL/SSIS

Price: $64.99

Average Rating: 3.2

Number of Lectures: 83

Number of Published Lectures: 72

Number of Curriculum Items: 83

Number of Published Curriculum Objects: 72

Original Price: $64.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

Beginners to ETL Process
Beginners to SSIS

Target Audiences

Beginners to ETL Process
Beginners to SSIS

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: What is SQL

Lecture 3: What is ETL ?

Lecture 4: What is T-SQL

Lecture 5: What is SSIS

Lecture 6: What is a Data Warehouse

Lecture 7: What is a Schema

Lecture 8: Please Read

Chapter 2: Setup Visual Studio

Lecture 1: What is Visual Studio

Lecture 2: Minimum Installation Requirements for visual studio 2019

Lecture 3: Installing Visual Studio 2019

Lecture 4: Installing SQL Server Data Tools

Lecture 5: Installing Designers for SSIS,SSAS,SSRS

Chapter 3: SQL Server Setup

Lecture 1: What is SQL Server

Lecture 2: SQL Server 2019 Hardware | Software Installation Requirements

Lecture 3: SQL Server Editions

Lecture 4: Download SQL Server Developer Edition

Lecture 5: Install SQL Server 2019 Developer Edition

Lecture 6: Installing SQL Server Management Studio

Lecture 7: Connecting to SQL Server with SSMS

Lecture 8: SQL Server Configuration Manager

Lecture 9: Installing adventureworks 2016

Lecture 10: Installing adventureworks 2016DW database

Chapter 4: T-SQL Functions

Lecture 1: AVG Aggregate Function

Lecture 2: MIN Aggregate Function

Lecture 3: MAX Aggregate Function

Lecture 4: SUM Aggregate Function

Lecture 5: COUNT Aggregate Function

Lecture 6: GROUPING Aggregate Functions

Lecture 7: VAR Aggregate Function

Lecture 8: VARP Aggregate Function

Lecture 9: RANK Function

Lecture 10: NTILE Function

Lecture 11: ROW Number function

Lecture 12: DENSE RANK Function

Lecture 13: Analytic Function Syntax

Lecture 14: LEAD Analytic Function

Lecture 15: LAG Analytic Function

Lecture 16: LAST_VALUE Analytic Function

Lecture 17: First _Value Analytic Function

Lecture 18: CUME_DIST Analytic Function

Lecture 19: PERCENTILE_DISC Analytic Function

Chapter 5: Extracting Data From Multiple Tables

Lecture 1: Extracting data using an INNER Join

Lecture 2: Extracting data using a LEFT Outer Join

Lecture 3: Extracting data using a RIGHT OUTER Join

Lecture 4: Extracting data using an FULL OUTER Join

Chapter 6: T-SQL Stored Procedure

Lecture 1: Introduction to stored procedures

Lecture 2: Creating stored procedures

Lecture 3: Modifying stored procedures

Lecture 4: Properties page of a stored procedure

Lecture 5: Viewing dependencies of a stored procedure

Lecture 6: Deleting a stored procedure

Lecture 7: Viewing definition of a stored procedure

Chapter 7: CRUD Stored Procedures

Lecture 1: What is CRUD

Lecture 2: Naming Convention

Lecture 3: Basic Application Design Structure

Lecture 4: Stored Procedure For CREATE CRUD Operation

Lecture 5: Stored Procedure For READ CRUD Operation

Lecture 6: Stored Procedure For UPDATE CRUD Operation

Lecture 7: Stored Procedure For DELETE CRUD Operation

Chapter 8: Developing ETL with SSIS

Lecture 1: How to create a new SSIS Project with vs2019

Lecture 2: Create a new SSIS project

Lecture 3: Add a Flat File Connection Manager

Lecture 4: Remap Column Data Types

Lecture 5: Add and Configure OLE DB Connection Manager

Lecture 6: Add a Data Flow Task

Lecture 7: Add and configure Flat File Source

Lecture 8: Add and Configure Lookup Transformation

Lecture 9: Add and Configure Lookup For DateKey Transformation

Lecture 10: Add and Configure OLE DB Destination

Lecture 11: Test and Run Package

Lecture 12: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 17 votes
2 stars: 22 votes
3 stars: 57 votes
4 stars: 60 votes
5 stars: 79 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu