SQL - ETL 开发人员 - T-SQL - 存储过程 - ETL - SSIS
SQL - ETL Developer - T-SQL - Stored Procedures - ETL - 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
- 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