17 Sat 09:55 AM – 03:45 PM IST
In this workshop, we will learn the two foundational concepts that form a query and one robust technique of writing and composing queries, that works every single time.
Window functions? ✔️
Complex report like queries? ✔️
whereclauses since where clauses execute first.
This is not a SQL primer. Previous experience with SQL is a must. It is alright if you’ve only worked with ActiveRecord or Django.DB or Segment. But you should be able to write queries like aggregates and simple joins by yourself. For example:
SELECT post_id, COUNT(id) FROM articles GROUP BY post_id
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.
This is a paid workshop. Zoom link will be shared with participants prior to the workshop.
Swanand Pagnis is senior backend engineer, leader, and mentor, with a focus on web application development and relational databases. He has been using and teaching MySQL, PostgreSQL for over 10 years.
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
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
For inquiries about the workshop, contact +91-7676332020 or write to firstname.lastname@example.org