成为一名 SQL 数据工程师 - 数据分析师
上次更新时间：2024-10-31
课程售价: 2.9 元
联系右侧微信客服充值或购买课程
课程内容
2. Relational Databases Setup
- 2. SQL Server Editions (免费)
- 3. Download MS SQL Server (免费)
- 4. Install MS SQL Server
- 5. Install SQL Server Management Studio - SSMS
- 6. Connect SSMS to MS SQL Server
- 7. Restore sample database to MS SQL Server
- 8. MySQL Database Server Installation on Windows
- 9. MySQL Database Server Installation on Mac
- 10. Introduction to MySQL Workbench
- 11. Installing MySQL Workbench on Mac
- 12. Installing PostgreSQL on Windows
- 13. Installing PostgreSQL on Mac
- 14. Installing PgAdmin for PostgreSQL on Mac
- 15. Connect PgAdmin to PostgreSQL Database Server
- 16. Restore sample database to PostgreSQL Database Server
- 17. Download Oracle Database Server
- 18. Install Oracle Database Server
- 19. What is SQLPlus
- 20. Connect SQLPLus to Oracle
- 21. Create a new database user in Oracle with SQLPlus
- 22. Create a new table in Oracle with SQLPlus
- 23. What is Oracle SQL Developer
- 24. Download Oracle SQL Developer
- 25. Connect SQL Developer to Oracle
- 27. Download Sample Oracle Schemas
- 28. Unlock sample hr schema account
- 29. Connect sample schema account to Oracle
- 30. Unlock sample schema tables
4. SQL Syntax - Performing CRUD Operations
5. Manipulating Data with SQL Functions
6. SQL Joins and Subqueries
7. Working with Data in SQL
8. Data Analysis and Descriptive Statistics in SQL
9. Data Analysis using SQL window and Analytic functions
- 2. Introduction to Analytic Functions
- 3. Introduction to Ranking Functions
- 4. Basic Syntax for Analytic Functions
- 6. RANK() Function
- 7. DENSE_RANK() Function
- 8. ROW_NUMBER() Function
- 9. LAG() Function
- 10. LEAD() Function
- 11. FIRST_VALUE() Function
- 12. LAST_VALUE() Function
- 13. NTH_VALUE() Function
- 14. Using Multiple Ranking Functions
13. Introduction to Data Visualization
14. SQL Best Practices Performance Optimization Triggers Stored Procedures
课程内容
9个章节 , 82个讲座
2. Relational Databases Setup
- 2. SQL Server Editions (免费)
- 3. Download MS SQL Server (免费)
- 4. Install MS SQL Server
- 5. Install SQL Server Management Studio - SSMS
- 6. Connect SSMS to MS SQL Server
- 7. Restore sample database to MS SQL Server
- 8. MySQL Database Server Installation on Windows
- 9. MySQL Database Server Installation on Mac
- 10. Introduction to MySQL Workbench
- 11. Installing MySQL Workbench on Mac
- 12. Installing PostgreSQL on Windows
- 13. Installing PostgreSQL on Mac
- 14. Installing PgAdmin for PostgreSQL on Mac
- 15. Connect PgAdmin to PostgreSQL Database Server
- 16. Restore sample database to PostgreSQL Database Server
- 17. Download Oracle Database Server
- 18. Install Oracle Database Server
- 19. What is SQLPlus
- 20. Connect SQLPLus to Oracle
- 21. Create a new database user in Oracle with SQLPlus
- 22. Create a new table in Oracle with SQLPlus
- 23. What is Oracle SQL Developer
- 24. Download Oracle SQL Developer
- 25. Connect SQL Developer to Oracle
- 27. Download Sample Oracle Schemas
- 28. Unlock sample hr schema account
- 29. Connect sample schema account to Oracle
- 30. Unlock sample schema tables
4. SQL Syntax - Performing CRUD Operations
5. Manipulating Data with SQL Functions
6. SQL Joins and Subqueries
7. Working with Data in SQL
8. Data Analysis and Descriptive Statistics in SQL
9. Data Analysis using SQL window and Analytic functions
- 2. Introduction to Analytic Functions
- 3. Introduction to Ranking Functions
- 4. Basic Syntax for Analytic Functions
- 6. RANK() Function
- 7. DENSE_RANK() Function
- 8. ROW_NUMBER() Function
- 9. LAG() Function
- 10. LEAD() Function
- 11. FIRST_VALUE() Function
- 12. LAST_VALUE() Function
- 13. NTH_VALUE() Function
- 14. Using Multiple Ranking Functions