15
值得收藏！史上最好的 SQL 知识图示[编程的日常]
source link: https://zhuanlan.zhihu.com/p/87253932
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
值得收藏！史上最好的 SQL 知识图示[编程的日常]
☑编程 ☑读书 ☑翻译 ☑太极
国外博主 Julia Evans 发布了一系列的 SQL 知识图示，非常有爱，浅显直白。我把这些图示收集在这里，供大家学习参考。这些图示堪称史上最有爱最直白的 SQL 知识讲解了，感谢 Julia Evans！
- SQL tricks: single quote your strings
- SQL tricks: find duplicates
- sql tricks: concatenate multiple rows into a single row
- how sql joins work
- a different way to explain sql joins
- how group by works
- sql tips: you can group by anything
- WHERE tips
- how indexes make your queries fast
- sql tips: get the difference from the previous row
- sql queries run in this order
- sql tips: i heard you like queries so i put more queries in your query (aka "subqueries")
- SQL window functions: how OVER() works
- sql tricks: COALESCE
- how NULL works
- row-oriented vs column-oriented databases
- sql tips: 3 ways to count
- questions to ask about your data
- sql exercises idea: take a table and some queries and write down the results by hand
- sql query steps
- the steps in a left join
- use x IS NULL, not x = NULL
真是非常棒的 SQL 资料！
（持续更新，敬请关注）
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK