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 - Edition II
X-WR-CALNAME:SQL Masterclass - Edition II
REFRESH-INTERVAL;VALUE=DURATION:PT12H
SUMMARY:SQL Masterclass - Edition II
TIMEZONE-ID:Asia/Kolkata
X-PUBLISHED-TTL:PT12H
X-WR-TIMEZONE:Asia/Kolkata
BEGIN:VEVENT
SUMMARY:Introduction to the Workshop and Trainer
DTSTART:20201017T042500Z
DTEND:20201017T043000Z
DTSTAMP:20260422T040053Z
UID:session/Y15LrLxS9mT3XhiiFxcvze@hasgeek.com
SEQUENCE:0
CREATED:20200929T184636Z
DESCRIPTION:\n
LAST-MODIFIED:20200929T184636Z
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:20201017T043000Z
DTEND:20201017T053000Z
DTSTAMP:20260422T040053Z
UID:session/MAdyaxWJZzw7qK39myLP3M@hasgeek.com
SEQUENCE:2
CREATED:20200929T184835Z
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
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:20201017T053000Z
DTEND:20201017T054500Z
DTSTAMP:20260422T040053Z
UID:session/DAe2yi3SF43vu1K3wjdXkc@hasgeek.com
SEQUENCE:0
CREATED:20200929T184946Z
DESCRIPTION:\n
LAST-MODIFIED:20200929T184946Z
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:20201017T054500Z
DTEND:20201017T065000Z
DTSTAMP:20260422T040053Z
UID:session/BM4uTayXEu2UoGSwnjKJej@hasgeek.com
SEQUENCE:0
CREATED:20200929T185106Z
DESCRIPTION:\n
LAST-MODIFIED:20200929T185106Z
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:20201017T065000Z
DTEND:20201017T070000Z
DTSTAMP:20260422T040053Z
UID:session/VpupjnYgZAqLEhdUjW3aQP@hasgeek.com
SEQUENCE:0
CREATED:20200929T185150Z
DESCRIPTION:\n
LAST-MODIFIED:20200929T185150Z
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:20201017T070000Z
DTEND:20201017T074500Z
DTSTAMP:20260422T040053Z
UID:session/THsatuxrRBrFgJtGeX9GfW@hasgeek.com
SEQUENCE:0
CREATED:20200929T185225Z
DESCRIPTION:\n
LAST-MODIFIED:20200929T185225Z
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:20201017T074500Z
DTEND:20201017T083000Z
DTSTAMP:20260422T040053Z
UID:session/HNKnyJT1reah8zBtvPgeBj@hasgeek.com
SEQUENCE:0
CREATED:20200929T185435Z
DESCRIPTION:\n
LAST-MODIFIED:20200929T185435Z
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:20201017T083000Z
DTEND:20201017T093000Z
DTSTAMP:20260422T040053Z
UID:session/8WrYnRDuyuBUqFmvEjbYgm@hasgeek.com
SEQUENCE:0
CREATED:20200929T185257Z
DESCRIPTION:\n
LAST-MODIFIED:20200929T185257Z
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:20201017T093000Z
DTEND:20201017T094500Z
DTSTAMP:20260422T040053Z
UID:session/WbdtsFUHHr3ozsWtQbDHid@hasgeek.com
SEQUENCE:0
CREATED:20200929T185405Z
DESCRIPTION:\n
LAST-MODIFIED:20200929T185405Z
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:20201017T094500Z
DTEND:20201017T101500Z
DTSTAMP:20260422T040053Z
UID:session/8nDEfRiYrcBqAghD2FBaC1@hasgeek.com
SEQUENCE:0
CREATED:20200929T185331Z
DESCRIPTION:\n
LAST-MODIFIED:20200929T185331Z
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