值得收藏!史上最好的 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 资料!

(持续更新,敬请关注)

发布于 2019-10-18

文章被以下专栏收录

    田园将芜胡不归,这里记录技术与生活——自己喜欢的编程技术,触动自己的点点滴滴感悟。 微博:@2gua