Submissions

If you work with SQL, you invariably come across questions like:

  1. What is a lateral join?
  2. When do I pick what kind of join?
  3. Rectangular join? What?
  4. What happens if you mix inner and outer joins together?

With simple practical examples, and visual represenation of the joins, Swanand Pagnis will cover:

  1. Why is it called a join and what exactly does it mean?
  2. The concepts behind “inner/outer” and “left/right” and how DB engines determine which rows will be in ResultSet.
  3. The technique of “one at a time” in building large, complex joins.

About the speaker: 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.

Participation: Zoom link will be shared with registered participants. Or, you can watch the livestream on this page.
Registered participants can leave comments/questions on the Comments section for the speaker to address during the session.

Contact details: For inquiries, call 7676332020 or email info@hasgeek.com. Follow @rootconf on Twitter or subscribe to https://hasgeek.com/rootconf

Hosted by

Rootconf is a community-funded platform for activities and discussions on the following topics: Site Reliability Engineering (SRE). Infrastructure costs, including Cloud Costs - and optimization. Security - including Cloud Security. more

Accepting submissions

Not accepting submissions

Swanand Pagnis

Fearless Joins: Just enough SQL to be effective

SQL joins strike terror in the hearts of some developers. Some others can write their out of them, but never truly grok them and get stuck when things go wrong. We will undo the damage done by that useless venn diagram. Yup, the same one you’re thinking of. more
  • 2 comments
  • Confirmed & scheduled
  • 16 Aug 2020
Duration of the session:: 40 mins full talk Category of talk: Database

Hosted by

Rootconf is a community-funded platform for activities and discussions on the following topics: Site Reliability Engineering (SRE). Infrastructure costs, including Cloud Costs - and optimization. Security - including Cloud Security. more