SQL Masterclass

SQL Masterclass

Hands-on online workshop designed to help you develop intuitive fluency in SQL

Tickets

Loadingโ€ฆ

Swanand Pagnis

Swanand Pagnis

@swanand

Workshop: SQL Masterclass Part 1 ๐Ÿ‘ฉ๐Ÿผโ€๐Ÿ’ป๐Ÿ‘จ๐Ÿผโ€๐Ÿ’ป

Submitted Aug 14, 2020

Never again get stuck writing queries โœ…

A SQL workshop designed to help you develop intuitive fluency in SQL. Learn the two foundational concepts that form a query and one robust technique of writing and composing queries, that works every single time.

Joins? โœ”๏ธ
Aggregates? โœ”๏ธ
Window functions? โœ”๏ธ
Complex report like queries? โœ”๏ธ
...and more

Learnings from 14+ years of working with relational databases, distilled into a series of online workshops.

Outline

Syllabus ๐Ÿ“–

  1. Structure: All SELECT queries have exactly the same structure. Understand it once and you can read and understand /any/ query.
  2. Lifecycle: what executes first? What values, functions are available in what parts of a query? e.g. you cannot use select aliases in where clauses since where clauses execute first.
  3. Approach: Using our understanding from 1 and 2, we will learn a methodical approach that allows us to write any query systematically and efficiently. As a nice side effect, this approach also yields very performant queries.

Format ๐Ÿ““

  • Hands-on workshop, instant feedback
  • Develop the right approach by working on exercises in the class
  • Spaced repetition to cement your knowledge after the class is over
  • A community of peers to learn together

Words from previous attendees โญ

I have been using ORMs for the last 10 years. I was never comfortable with raw SQL queries. Attending Swanandโ€™s workshop gave a me clear understanding of how databases work. How to think about joins and how to write raw queries without fear. I would highly recommend his workshop to anyone working with databases.

- Pratyush Mittal, Founder & CEO, Screener.in

Attended this last time. Quite insightful. This workshop is a gem if youโ€™re looking to solidify your foundations in Postgres and SQL.

- Kiran Gangadharan, Partner and Consultant @ Nilenso.in

This workshop made me confident enough to write big queries; recently wrote a 200+ lines query for a data migration.

- Aboobacker MK, Senior Software Engineer, Sephora

Swanandโ€™s workshop was a gloves off treatment of the power of postgreSQL. In two days, we had written very large queries, multiple migration scripts while making sure that we could revert back to the old version of the database if needed, different kinds of views and exposed ourselves to several features of the database which I was not aware of.
I can, without reservation, say that it was very high value for money and it significantly improved my skills with postgreSQL. Highly recommended.

- Noufal Ibrahim, Founder @hamon_in & @thelycaeum

Requirements

This is not a SQL primer and previous experience with SQL is required.

When you read a query like

SELECT post_id, COUNT(id) FROM articles GROUP BY post_id

you shouldnโ€™t draw a blank. Itโ€™s okay if you donโ€™t understand everything that is going on here. But this workshop will work the best for you if you are familiar with this or queries like this.

Speaker bio

Senior backend engineer, leader, and mentor, with a focus on web application development and relational databases. I have been using and teaching MySQL, PostgreSQL for over 10 years.

Comments

Hybrid access (members only)

Hosted by

We care about site reliability, cloud costs, security and data privacy