Sold out, but you can still join the waitlist!
Course logo

Advanced SQL

This course will take learners from just being comfortable with SQL to being 100% confident in their knowledge and ability to apply it effectively in the real-world. This journey includes having full confidence in query accuracy, maintainability/understandability, and efficiency. The course will focus on bringing all of these topics together to leave learners confident they can assess, improve, and maintain complex SQL code on realistic data.

Instructor profile photo
Meredith Alder
Data Advocate at Hightouch
Real-world projects that teach you industry skills.
Learn alongside a small group of your professional peers
Part-time program with 2 live events per week:
Next Cohort
January 30, 2023
Duration
4 weeks
Price
US$ 400
or included with membership

Course taught by expert instructors

Instructor Photo
Affiliation logo

Meredith Alder

Data Advocate at Hightouch

Meredith is an experienced developer and engineer with a diverse data management and architecture background. She is currently an Engineer/Advocate at Hightouch, the Data Activation company, where she spends her time engaging with the data community to share knowledge and move the industry forward. She is passionate about helping data teams build scalable, high-quality solutions and has served in roles at Brooklyn Data Company, Hudl, and as an independent consultant.

The course

Learn and apply skills with real-world projects.

Who is it 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.

Not ready?

Try these prep courses first

Learn
  • Data types in SQL
  • Data cleaning
  • Pivoting & unpivoting
  • Nested and semi-structured data
  • Flattening & unflattening data
  • Nested object queries
Project
Use SQL to answer questions within a complex dataset.
    Learn
    • The SQL style guide
    • Complex joins
    • Subqueries & CTEs
    • Aliases
    • Window functions
    • UDFs
    Project
    Rework a query to improve its readability.
      Learn
      • SQL performance fundamentals
      • SQL in Snowflake
      • Query plans
      • Tuning queries & joins
      • Fanout
      Project
      Write an event-based query that will scale with business growth.
        Learn
        • SQL tech exercises for candidates
        • Key business terms & metrics
        • Data discovery
        • Documentation
        • Evaluating a sample tech exercise
        Project
        Evaluate a candidate's SQL tech exercise.

          Real-world projects

          Work on projects that bring your learning to life.
          Made to be directly applicable in your work.

          Live access to experts

          Sessions and Q&As with our expert instructors, along with real-world projects.

          Network & community

          Core reviews a study groups. Share experiences and learn alongside a global network of professionals.

          Support & accountability

          We have a system in place to make sure you complete the course, and to help nudge you along the way.

          Frequently Asked Questions

          Still not sure?

          Get in touch and we'll help you decide.

          Keep in touch for updates, discounts, and new courses.

          Questions? Ask us anything at hello@corise.com

          © 2021-2022 CoRise Education