4 ms·

For beginner learning? https://sqlbolt.com/ https://sqlbolt.com/ is a decent place to start.

• agumonkey 3y ago
  Intermediate and advanced too, if you can, that would be lovely.
  • ndriscoll 3y ago
    https://modern-sql.com/ https://modern-sql.com/ has some info about more recent additions to SQL to make life easier/write higher level or more composable queries. Once you have the basics of SQL down (like how to write a query), you want to understand what the database actually does with your queries, so you can predict what the query plan "ought to be"/what you want, and you can read the query plans to try to understand why you did or didn't get the plan you expect. https://use-the-index-luke.com/ https://use-the-index-luke.com/ And then once you understand the fundamentals, your database's manual is the place to go. Especially different index types (including their internals!) and what kinds of queries they support. The above link goes into depth about b-trees, but there are other types, and you can use b-trees as a reference point to contrast with others. https://www.postgresql.org/docs/current/index.html https://www.postgresql.org/docs/current/index.html
    • agumonkey 3y ago
      thank's a lot