BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//HasGeek//NONSGML Funnel//EN
DESCRIPTION:Rootconf discussions on databases
X-WR-CALDESC:Rootconf discussions on databases
NAME:Fearless Joins: Just enough SQL to be effective
X-WR-CALNAME:Fearless Joins: Just enough SQL to be effective
REFRESH-INTERVAL;VALUE=DURATION:PT12H
SUMMARY:Fearless Joins: Just enough SQL to be effective
TIMEZONE-ID:Asia/Kolkata
X-PUBLISHED-TTL:PT12H
X-WR-TIMEZONE:Asia/Kolkata
BEGIN:VEVENT
SUMMARY:Introduction to Rootconf\, and today's session
DTSTART:20200901T133000Z
DTEND:20200901T133500Z
DTSTAMP:20260421T210228Z
UID:session/WXKA47tELLBQ7yEMVmyZJo@hasgeek.com
SEQUENCE:0
CREATED:20200817T075215Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T075215Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Introduction to Rootconf\, and today's session in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Fearless joins: just enough SQL to be effective
DTSTART:20200901T133500Z
DTEND:20200901T141000Z
DTSTAMP:20260421T210228Z
UID:session/9T4pn5pyUgF62uhVc4TPmZ@hasgeek.com
SEQUENCE:3
CATEGORIES:40 mins full talk,Database
CREATED:20200817T075225Z
DESCRIPTION:We roughly cover these main ideas:\n\n1. Why is it called a jo
 in and what exactly does it mean?\n2. The concepts behind "inner/outer" an
 d "left/right" and how DB engines determine which rows will be in resultse
 t\n3. The technique of "one at a time" in building large\, complex joins\n
 \nThere will simple practical examples\, and visual represenation of the j
 oins.\n\n**Useful links:**\n\n1. https://postgres-workshop.com/\n2. https:
 //info.pagnis.in/blog/2017/08/19/deconstructing-sql-queries/ \n3. My most 
 popular talk that talks about understanding RDBMS as a foundational skill 
 for career development: https://speakerdeck.com/swanandp/the-well-rounded-
 engineer\n\n### Speaker bio\n\nSenior backend engineer\, leader\, and ment
 or\, with a focus on web application development and relational databases.
  I have been using and teaching MySQL\, PostgreSQL for over 10 years.\n
LAST-MODIFIED:20240123T123750Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
URL:https://hasgeek.com/rootconf/just-enough-sql-to-be-effective/schedule/
 fearless-joins-just-enough-sql-to-be-effective-9T4pn5pyUgF62uhVc4TPmZ
BEGIN:VALARM
ACTION:display
DESCRIPTION:Fearless joins: just enough SQL to be effective in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Q&A session
DTSTART:20200901T141000Z
DTEND:20200901T142500Z
DTSTAMP:20260421T210228Z
UID:session/PzSHeBP7XwSimFrESuFFWe@hasgeek.com
SEQUENCE:0
CREATED:20200817T075235Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T075247Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Q&A session in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Closing\; announcement of database discussions on Rootconf
DTSTART:20200901T142500Z
DTEND:20200901T143000Z
DTSTAMP:20260421T210228Z
UID:session/BEKt9XE1sQ2ShNJqSdhyVQ@hasgeek.com
SEQUENCE:0
CREATED:20200817T075319Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T075319Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Closing\; announcement of database discussions on Rootconf in 
 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
END:VCALENDAR