Sep 2020
31 Mon
1 Tue 07:00 PM – 08:00 PM IST
2 Wed
3 Thu
4 Fri
5 Sat
6 Sun
Sep 2020
31 Mon
1 Tue 07:00 PM – 08:00 PM IST
2 Wed
3 Thu
4 Fri
5 Sat
6 Sun
Submitted Aug 16, 2020
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.
If you work with SQL, you invariably come across questions like:
We aim to “decomplect” joins in this session i.e. build up an understanding of the invariants that are behind SQL joins, and work out any join clause using them. If you pay sufficiennt attention, by the end of the 30 minutes, you will be able to very confidently explain the difference between adding a condition in JOIN
clause vs adding that same condition in a WHERE
clause and when to use which construct. Amongst other things.
We roughly cover these main ideas:
There will simple practical examples, and visual represenation of the joins.
This is not a SQL primer. Prior experience in writing a query is needed. Experience with ActiveRecord
, Django.DB
is fine.
A willingness to unlearn and relearn is needed.
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.
Sep 2020
31 Mon
1 Tue 07:00 PM – 08:00 PM IST
2 Wed
3 Thu
4 Fri
5 Sat
6 Sun
Hosted by
Login to leave a comment
Kiran Jonnalagadda
@jace
SQL Antipatterns by Bill Karwin is the best book I've read on the subject. It describes a collection of recurring problems with the obvious but wrong solution, followed by the correct solution. This approached worked for me because it explained SQL relative to a problem I already understood. This may be something to consider.
Swanand Pagnis
@swanand SubmitterEditor
I have a slightly different style of teaching, a more first principles approach and I do cover examples, but adding common mistakes, anti-patterns and showing how the first principles help would be a good addition to this talk. I've noted it down.