掌握 SQL - 从简单到高级的 200 多个查询
上次更新时间：2024-11-16
课程售价: 2.9 元
联系右侧微信客服充值或购买课程
课程内容
1. Introduction
2. Employees Management System
- 1. Understand the database model
- 2. Create tables and populate data
- 3. Get filtered data via WHERE clause
- 4. Referencing an alias and concatenate columns
- 5. Using conditional logic with CASE expression
- 6. Using ORDER BY, LIMIT and RANDOM
- 7. Find NULL values and transform into real values
- 8. Searching for patterns
- 9. Sorting on data dependent key
- 10. Staking tables together
3. Hierarchical Queries
4. Working with numbers
5. Date Arithmetic
6. Advances Searching
7. Window Functions
8. Metadata Queries
9. International Debt Analysis
课程内容
10个章节 , 45个讲座
1. Introduction
2. Employees Management System
- 1. Understand the database model
- 2. Create tables and populate data
- 3. Get filtered data via WHERE clause
- 4. Referencing an alias and concatenate columns
- 5. Using conditional logic with CASE expression
- 6. Using ORDER BY, LIMIT and RANDOM
- 7. Find NULL values and transform into real values
- 8. Searching for patterns
- 9. Sorting on data dependent key
- 10. Staking tables together