BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//HasGeek//NONSGML Funnel//EN
DESCRIPTION:Hands-on online workshop designed to help you develop intuitiv
 e fluency in SQL
X-WR-CALDESC:Hands-on online workshop designed to help you develop intuiti
 ve fluency in SQL
NAME:SQL Masterclass
X-WR-CALNAME:SQL Masterclass
REFRESH-INTERVAL;VALUE=DURATION:PT12H
SUMMARY:SQL Masterclass
TIMEZONE-ID:Asia/Kolkata
X-PUBLISHED-TTL:PT12H
X-WR-TIMEZONE:Asia/Kolkata
BEGIN:VEVENT
SUMMARY:Introduction to the Workshop and Trainer
DTSTART:20200919T042500Z
DTEND:20200919T043000Z
DTSTAMP:20260421T101827Z
UID:session/4Prf6Sm9CQHEP45JXfu54n@hasgeek.com
SEQUENCE:0
CREATED:20200817T094555Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T111931Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Introduction to the Workshop and Trainer in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Workshop: SQL Masterclass Part 1 👩🏼‍💻👨🏼‍💻
DTSTART:20200919T043000Z
DTEND:20200919T053000Z
DTSTAMP:20260421T101827Z
UID:session/YWJUezMtSJhXC5L55Am1BE@hasgeek.com
SEQUENCE:2
CREATED:20200817T094616Z
DESCRIPTION:## Syllabus 📖\n1. *Structure:* All SELECT queries have exac
 tly the same structure. Understand it once and you can *read and understan
 d* /any/ query.\n2. *Lifecycle:* what executes first? What values\, functi
 ons are available in what parts of a query? e.g. you cannot use `select` a
 liases in `where` clauses since where clauses execute first. \n3. *Approac
 h:* Using our understanding from 1 and 2\, we will learn a methodical appr
 oach that allows us to write any query systematically and efficiently. As 
 a nice side effect\, this approach also yields very performant queries.\n\
 n## Format 📓\n- Hands-on workshop\, instant feedback\n- Develop the rig
 ht approach by working on exercises in the class\n- Spaced repetition to c
 ement your knowledge after the class is over\n- A community of peers to le
 arn together\n\n## Words from previous attendees ⭐\n\n_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 databas
 es work. How to think about joins and how to write raw queries without fea
 r. I would highly recommend his workshop to anyone working with databases.
 _\n\n\\- [Pratyush Mittal](https://twitter.com/faltoo)\, Founder & CEO\, [
 Screener.in](http://Screener.in)  \n\n_Attended this last time. Quite insi
 ghtful. This workshop is a gem if you're looking to solidify your foundati
 ons in Postgres and SQL._\n\n\\- [Kiran Gangadharan](https://twitter.com/k
 irang89)\, Partner and Consultant @ [Nilenso.in](http://Nilenso.in)  \n\n_
 This workshop made me confident enough to write big queries\; recently wro
 te a 200+ lines query for a data migration._\n\n\\- [Aboobacker MK](https:
 //twitter.com/_tachyons)\, Senior Software Engineer\, [Sephora](https://ww
 w.sephora.com/)\n\n\n_Swanand's workshop was a gloves off treatment of the
  power of postgreSQL. In two days\, we had written very large queries\, mu
 ltiple migration scripts while making sure that we could revert back to th
 e old version of the database if needed\, different kinds of views and exp
 osed ourselves to several features of the database which I was not aware o
 f._\n_I can\, without reservation\, say that it was very high value for mo
 ney and it significantly improved my skills with postgreSQL. Highly recomm
 ended._\n\n\\- [Noufal Ibrahim](https://twitter.com/noufalibrahim)\, Found
 er [@hamon_in](https://hamon.in/) & [@thelycaeum](https://thelycaeum.in/)\
 n\n### Speaker bio\n\nSenior backend engineer\, leader\, and mentor\, with
  a focus on web application development and relational databases. I have b
 een using and teaching MySQL\, PostgreSQL for over 10 years.\n
LAST-MODIFIED:20230810T072606Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
URL:https://hasgeek.com/rootconf/sql-masterclass/schedule/workshop-sql-mas
 terclass-part-1-YWJUezMtSJhXC5L55Am1BE
BEGIN:VALARM
ACTION:display
DESCRIPTION:Workshop: SQL Masterclass Part 1 👩🏼‍💻👨🏼‍
 💻 in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Short break
DTSTART:20200919T053000Z
DTEND:20200919T054500Z
DTSTAMP:20260421T101827Z
UID:session/ASc7RNhZAXw1BJwiZKLFxC@hasgeek.com
SEQUENCE:0
CREATED:20200817T094643Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T111935Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Short break in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Workshop: SQL Masterclass - continued
DTSTART:20200919T054500Z
DTEND:20200919T065000Z
DTSTAMP:20260421T101827Z
UID:session/AKdRaqT6WRPf1HW94H9beX@hasgeek.com
SEQUENCE:0
CREATED:20200817T094700Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T111937Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Workshop: SQL Masterclass - continued in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Short break
DTSTART:20200919T065000Z
DTEND:20200919T070000Z
DTSTAMP:20260421T101827Z
UID:session/QjDBVpf4t4zdGn4oiHNSUw@hasgeek.com
SEQUENCE:0
CREATED:20200817T100032Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T111939Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Short break in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Workshop: SQL Masterclass - continued
DTSTART:20200919T070000Z
DTEND:20200919T074500Z
DTSTAMP:20260421T101827Z
UID:session/LHuDXbGZLg8ZHAGPPf6uz5@hasgeek.com
SEQUENCE:0
CREATED:20200817T094739Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T111941Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Workshop: SQL Masterclass - continued in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Lunch break
DTSTART:20200919T074500Z
DTEND:20200919T083000Z
DTSTAMP:20260421T101827Z
UID:session/9A1pwRqtWiS7fDbXJM6gyg@hasgeek.com
SEQUENCE:0
CREATED:20200817T094721Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T111942Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Lunch break in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Workshop: SQL Masterclass - continued
DTSTART:20200919T083000Z
DTEND:20200919T093000Z
DTSTAMP:20260421T101827Z
UID:session/HB1jpDuuKYkyiCtthRnZDU@hasgeek.com
SEQUENCE:0
CREATED:20200817T094812Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T111945Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Workshop: SQL Masterclass - continued in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Short break
DTSTART:20200919T093000Z
DTEND:20200919T094500Z
DTSTAMP:20260421T101827Z
UID:session/TfdFipLkMNTzwVGhqWUxao@hasgeek.com
SEQUENCE:0
CREATED:20200817T094758Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T111947Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Short break in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
BEGIN:VEVENT
SUMMARY:Q&A\; conclusion
DTSTART:20200919T094500Z
DTEND:20200919T101500Z
DTSTAMP:20260421T101827Z
UID:session/9afELTWj8Sjzr67i6cVPRf@hasgeek.com
SEQUENCE:0
CREATED:20200817T100207Z
DESCRIPTION:\n
LAST-MODIFIED:20200817T111948Z
LOCATION:Online
ORGANIZER;CN=Rootconf:MAILTO:no-reply@hasgeek.com
BEGIN:VALARM
ACTION:display
DESCRIPTION:Q&A\; conclusion in 5 minutes
TRIGGER:-PT5M
END:VALARM
END:VEVENT
END:VCALENDAR