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

سرفصل های دوره

Develop an ETL solution using SSIS

1. Introduction

1. Introduction

2. What is SQL

3. What is ETL

4. What is T-SQL

5. What is SSIS

6. What is a Data Warehouse

7. What is a Schema

8. Please Read.html

2. Setup Visual Studio

1. What is Visual Studio

2. Minimum Installation Requirements for visual studio 2019

3. Installing Visual Studio 2019

4. Installing SQL Server Data Tools

5. Installing Designers for SSIS,SSAS,SSRS

3. SQL Server Setup

1. What is SQL Server

2. SQL Server 2019 Hardware Software Installation Requirements

3. SQL Server Editions

4. Download SQL Server Developer Edition

5. Install SQL Server 2019 Developer Edition

6. Installing SQL Server Management Studio

7. Connecting to SQL Server with SSMS

8. SQL Server Configuration Manager

9. Installing adventureworks 2016

10. Installing adventureworks 2016DW database

4. T-SQL Functions

1. AVG Aggregate Function

2. MIN Aggregate Function

3. MAX Aggregate Function

4. SUM Aggregate Function

5. COUNT Aggregate Function

6. GROUPING Aggregate Functions

7. VAR Aggregate Function

8. VARP Aggregate Function

9. RANK Function

10. NTILE Function

11. ROW Number function

12. DENSE RANK Function

13. Analytic Function Syntax

14. LEAD Analytic Function

15. LAG Analytic Function

16. LAST VALUE Analytic Function

17. First Value Analytic Function

18. CUME DIST Analytic Function

19. PERCENTILE DISC Analytic Function

5. Extracting Data From Multiple Tables

1. Extracting data using an INNER Join

2. Extracting data using a LEFT Outer Join

3. Extracting data using a RIGHT OUTER Join

4. Extracting data using an FULL OUTER Join

6. T-SQL Stored Procedure

1. Introduction to stored procedures

2. Creating stored procedures

3. Modifying stored procedures

4. Properties page of a stored procedure

5. Viewing dependencies of a stored procedure

6. Deleting a stored procedure

7. Viewing definition of a stored procedure

7. CRUD Stored Procedures

1. What is CRUD

2. Naming Convention

3. Basic Application Design Structure

4. Stored Procedure For CREATE CRUD Operation

5. Stored Procedure For READ CRUD Operation

6. Stored Procedure For UPDATE CRUD Operation

7. Stored Procedure For DELETE CRUD Operation

8. Developing ETL with SSIS

1. How to create a new SSIS Project with vs2019

2. Create a new SSIS project

3. Add a Flat File Connection Manager

4. Remap Column Data Types

5. Add and Configure OLE DB Connection Manager

6. Add a Data Flow Task

7. Add and configure Flat File Source

8. Add and Configure Lookup Transformation

9. Add and Configure Lookup For DateKey Transformation

10. Add and Configure OLE DB Destination

11. Test and Run Package

12. Thank You.html

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy