SQL for the Potterhead
Being able to query data with SQL is very powerful — apart from querying and analyzing data, there is lots of work that goes into making queries performant, and scaling database systems. That’s why it’s important to have a good grasp on the SQL basics when you get started.
At the end of this workshop, you will walk away knowing how to:
- Query data using simple SELECT and WHERE clauses
- Perform table JOINs
- Be able to think about performance, by using the EXPLAIN clause.
- Read and understand SQL documentation
- Understand window functions, specifically the
ROW_NUMBER OVER PARTITIONmethod
About Kamya Shethia
Kanya Shethia is a New York based Software Engineer and works at Etsy. She loves learning new things, and has had the chance to work on the frontend, backend, and recently made the transition to data engineering!