<aside> 🍔
目錄 - 重點摘錄
</aside>
Copyright ©Hy.C CC BY-NC-SA 4.0 | 禁止商業用途 | 轉載標記出處 | 改編作品必須在相同條款下分享。
上課範例程式
2026寒假專班課程完整程式碼 - https://github.com/Chen11111112/Flask_E-commerce.git
<aside> 🗺️
SQL THE COMPLETE ROADMAP — FROM BASICS TO SCALE
Most SQL tutorials teach syntax. Real engineers think in execution plans. Write better queries. Design better systems. Build at scale.
</aside>
| 章 | 主題 | 核心內容 |
|---|---|---|
| 01 | Query Foundations | SELECT · WHERE · ORDER BY · GROUP BY · HAVING · LIMIT |
| 02 | Joins | INNER · LEFT · RIGHT · FULL · SELF · CROSS + DDL/DML |
| 03 | Advanced Querying | Subqueries · CTEs · Window Functions · CASE WHEN · UNION · Recursive |
| 04 | Database Design | Normalization · PK/FK · Constraints · ER Diagrams · Trigger |
| 05 | Performance Optimization | Indexing · Execution Plans · Partitioning · Materialized Views |
| 06 | Transactions | ACID · Locks · Isolation Levels · Deadlocks · Concurrency |
| 07 | Scaling Databases | Replication · Sharding · Read Replicas · Connection Pooling · Caching |