Advanced SQL
US$ 400
Not ready? for new sessions.
Course logo

Advanced SQL

Real world data is messy, confusing, and big. But most SQL courses teach with data that is artificially clean, simple, and small. This is not one of those courses. Over these four weeks, you’ll learn the advanced SQL skills necessary to dive into real datasets with confidence. We’ll clean up messy and nested data, learn about EAV schemas and pivots, and dive deep into advanced window functions. We’ll also cover performance, advanced joins, and other complex SQL patterns to optimize queries. You will walk away ready to be unleashed on any dataset, from your company’s production DB (a read replica, of course) to a public database of trees in your neighborhood.

Instructor profile photo
Izzy Miller
Advocate at Hex, former Google and Looker
Price
US$ 400
Start Date
Coming soon
Registration By
Learn alongside a small group of your professional peers
Connect with experts through live sessions and office hours
Real-world projects that teach you industry skills.
Created and taught by
Instructor Photo
Link to an instructor's LinkedIn profile
Link to an instructor's Twitter profile

Izzy Miller

Advocate at Hex, former Google and Looker

Izzy is a developer advocate and data nerd. He currently leads community at Hex, a collaborative data workspace. He previously built both the community and DevRel teams at Looker, where his guilty pleasure was not using Looker and writing SQL by hand. Before that, he studied Botany, Biology, and Environmental Studies, and outside of work still spends most of his time thinking about things that grow, crawl, and slither around.

Affiliation logo
The course
1
Week 1
Cleaning messy data
Learn
  • String and date functions for data cleaning
  • Data types in SQL
  • How to work with EAV schemas
  • Pivoting & unpivoting
  • Deduplicating & removing bad data
Project
Coming soon
    2
    Week 2
    Querying key metrics
    Learn
    • Window functions explained
    • Running totals, subtotals, rolling averages & ranks
    • Cohort analysis
    • Daily active / monthly active users
    • Date spines & fanouts
    Project
    A dashboard displaying key metrics about a made-up product: Daily active users, cohort analysis of churn, recent top-level metrics, etc.
      3
      Week 3
      Writing efficient queries
      Learn
      • CTEs and subqueries
      • SQL performance explained
      • Tuning queries & joins
      • Fanout
      • Some complex special patterns: Outer join on false, summarizing data with defined start/end times, etc.
      Project
      Recommendations for a social media management firm on when to post on reddit, using a very large reddit dataset
        4
        Week 4
        Working with nested & semistructured data
        Learn
        • Complex joins
        • Unnesting and flattening
        • Nested object querying
        • Performance recap
        • UDFs
        Project
        An urban planning report using some delightfully nested data from OpenStreetMap.
          This course is for...

          Junior Analytics Engineer. Some experience with SQL, and want to get more comfortable

          Data Scientist / SWE who wants to get more comfortable with SQL

          Prerequisites

          Basic SQL proficiency; You are comfortable writing simple SQL queries but are not as comfortable with complicated joins, window functions, etc.

          Course experience

          Live Sessions with Experts

          Top industry leaders teach you everything you need in only 4 weeks

          Interactive Learning

          Real-world projects put your learning into immediate action

          Professional Communities

          Grow your network by learning with an intimate cohort of peers from top companies
          ?
          Frequently Asked Questions
          Stay in the loop
          Keep in touch for updates, discounts, and new course sessions.
          Backed by top VCs, including
          VCs
          Teach
          Share your unique expertise with the world.
          Enterprise
          Receive best-in-class skills training for your teams and organization.
          Careers
          Join us as we change the future of online education.
          © 2021 - 2022 Corise Education. Terms of Service. Privacy Policy.
          Questions? Email us at hello@corise.com