SQL - ETL 开发人员 - T-SQL - 存储过程 - ETL - SSIS
上次更新时间：2024-11-27
课程售价: 2.9 元
联系右侧微信客服充值或购买课程
课程内容
1. Introduction
2. Setup Visual Studio
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
6. T-SQL Stored Procedure
7. CRUD Stored Procedures
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
课程内容
8个章节 , 70个讲座
1. Introduction
2. Setup Visual Studio
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
6. T-SQL Stored Procedure
7. CRUD Stored Procedures
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