SQL Experts Please Guide

Nov 2, 2020 3 Comments

I want to learn how internally SQL works... Like when we write a query, first the from clause picks the data, then select clause filters the data etc.. I want to understand this for all the clauses and for nested query. This might help me to optimize my queries and understand the data transformation and selection as a set.

Could you share any online course on advanced SQL or some text resource where I can better understand the working of SQL?

Thanks in advance.
#sql

comments

Want to comment? LOG IN or SIGN UP
TOP 3 Comments
  • Start off with a Database internals book like Database System A complete book by Hecto Garcia Molina and work through part 2 (database system implementation) with special on the chapters that interest you (looks like you are more interested in query execution and query optimization). Follow it up with required chapters from Principles of Distributed Database systems by Ozsu. But this book talks about MPP databases and not much about the cloud native database design which is the main USP of Snowflake. To understand that go through some papers on Snowflake’s design (there are a couple in Sigmod and VLDB). Also some research is going on in this area of Cloud DBs at MIT, Berkeley, Stanford so you can look through them (off the top of my head- read Rebecca Taft’s PhD dissertation on elastic DBs in the cloud, also there were a couple of dissertations on Sparks query engine from Berkeley - the one by Reynolds Xin is good, there are others as well just browse through Berkeley EECS dissertations)
    Nov 2, 2020 0
  • Uber
    whober!

    Go to company page Uber

    whober!
    Refer free SQL course on Udacity,it's worth your time!
    Nov 2, 2020 0
  • OpenTable / Data
    Bright23

    Go to company page OpenTable Data

    PRE
    Google, Facebook
    Bright23
    Code with Mosh SQL course is good to start with!
    Nov 2, 2020 0