Hurry!
Start Enrollment
A Modal advisor will help select your course!
🎉

Thanks!

A Modal Advisor will be in touch shortly to finalize your course enrollment!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Need help? Contact us
Register Now!

Advanced SQL for Data Analysis

Take your SQL data analysis skills to the next level: subqueries, CTEs, window functions, and more. Modal courses - a better way to learn technical skills.
NEXT COURSE STARTS
December 9, 2024 - January 19, 2025
Enrollment closes on November 27, 2024
Upcoming start dates
January 21, 2025 - March 2, 2025
Cooming Soon! We're planning next year's course schedule.
January 21, 2025 - March 2, 2025
Enrollment starts on November 28, 2024
February 18, 2025 - March 30, 2025
Enrollment starts on January 10, 2025
March 17, 2025 - April 27, 2025
Enrollment starts February 7, 2025
Who Is This For?

Data Professionals interested in creating streamlined, reusable queries for complex analysis.

Any prerequisites?

SQL

  • Familiarity with basic SQL syntax for querying relational databases.
  • Knowledge of aggregate functions, joining multiple tables, and basic data cleaning functions (TRIM, CAST, etc.).
What will I be able to do after this Course?
  • Write queries that use window functions to answer more complex data questions.
  • Write queries that use subqueries and CTEs to answer more complex data questions while improving query readability.
  • Analyze and optimize query efficiency.
NEED HELP DECIDING?
Book time with a learning expert.

A Typical Week

Monday
Self Study
Kick-off new topic with self-study & online learning
  • Coaches support learners hitting roadblocks
  • Manager check-in to bring learning into company context
Tuesday
Wednesday
Labs
Learning material leads into practice environment & labs
  • Coaches support learners hitting roadblocks
  • Pair programming to bring learning into company context
  • Community allows students to help each other
Thursday
Live Event
Interactive live session hosted by Coaches
  • Community allows students to help each other
  • Community Groups host expert AMAs & guided community discussions
Friday
Projects
Work on a weekly project
  • Community allows students to help each other
  • Group projects
  • Coaches support learners hitting roadblocks
Saturday
sunday
Work at your own pace
Expert coaching and actionable feedback from Coaches
    Modal clover loop

    Course Overview

    Live Sessions every
    Sprint 1: Window Functions
    Solve complex data questions using value, ranking, and aggregate functions within window frames.
    Sprint 2: Subqueries and Common Table Expressions
    Answer complex data questions using subqueries and then organize and structure those subqueries using Common Table Expressions.
    Sprint 3: Query Efficiency
    Learn the purpose of SQL indexes and inspect how indexes are used to optimize queries.

    Why Modal?

    Projects & Practice
    Real world exercises contextualize learning in real-world context.
    On-Demand Coach Support
    You are never alone. Coaches are always present and can help you!
    Live Sessions
    Hear from guest speakers and expert instructors through engaging lectures.
    Technical Labs
    Technical Labs
    Hands-on labs allow you to play with new tools and concepts to build real skills.
    Modal Community
    Community of Peers
    You will be part of a learning community were support is abundant.
    Asynchronous Learning
    Asynchronous Learning
    Self-paced learning is scheduled for each learner, with a dashboard to help you keep on track.

    Other Courses

    Python for Data Science
    Applying Statistical Thinking
    Data Analysis With SQL

    “I love the quantity & quality of learning materials, the interactivity, the live sessions, the coaches, are invaluable. I can really feel the difference in the level of engagement that Modal has to every participant compared to an ordinary course."

    Modal clover colored
    - Veselina Stoyanova - Reporting Analyst, EMAG

    Learn more about FlexEd

    We are excited that Modal now offers a direct bill payment option for Booz Allen employees. The direct bill payment option enables employees to enroll in learning opportunities with no upfront costs.

    This payment option will require the employee to sign a Family Educational Rights and Privacy Act (FERPA) agreement with Modal to release grades/completion to Booz Allen to satisfy the FlexEd Program completion requirement. Note, Modal may also be used for the FlexEd Program reimbursement payment option.
    Start Enrollment
    A Modal advisor will help select your course!
    🎉

    Thanks!

    A Modal Advisor will be in touch shortly to finalize your course enrollment!
    Thank you! Your submission has been received!
    Oops! Something went wrong while submitting the form.
    Need help? Contact us