成为一名 SQL 数据工程师 - 数据分析师
- 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
- 2. Create a database in multiple systems
- 4. What is T-SQL
- 5. Creating a database object
- 6. Creating a table object
- 7. Perform a Create Operation ( Inserting Data)
- 8. Perform a Read Operation
- 9. Perform Update Operation
- 10. Perform a Delete Operation
- 5. Manipulating Data with SQL Functions
- 3. CONCAT() Function
- 4. CHARACTER LENGTH Function
- 10. T-SQL CASE Expression
- 11. T-SQL SUBSTRING Function
- 12. T-SQL CONVERT Function
- 13. T-SQL CAST Function
- 6. SQL Joins and Subqueries
- 2. LEFT JOIN
- 3. INNER JOIN
- 4. RIGHT JOIN
- 5. SELF JOIN
- 6. What is a Subquery
- 7. Nested subqueries
- 8. SQL Views
- 9. Query Views
- 7. Working with Data in SQL
- 5. Backup MySQL Databases
- 6. Restore MySQL Databases
- 8. Data Analysis and Descriptive Statistics in SQL
- 3. COUNT() Aggregate Function
- 4. SUM() Aggregate Function
- 5. AVG () Aggregate Function
- 6. MIN() Aggregate Function
- 7. MAX() Aggregate Function
- 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
- 2. Tableau Public Desktop
- 3. Tableau Public Desktop Overview Part 1
- 4. Tableau Public Desktop Overview Part 2
- 5. Tableau Online
- 6. Tableau Data Sources
- 7. What is Power BI Desktop
- 8. Install Power BI Desktop
- 9. Explore Power BI Desktop Interface
- 14. SQL Best Practices Performance Optimization Triggers Stored Procedures
- 4. Introduction to triggers using PostgreSQL Database
- 5. Creating your first trigger - part 1
- 6. Creating your first trigger - part 2
- 7. Creating your first trigger - part 3
- 8. Managing triggers