Hurry!
🙌 Get a free 1-year Subscription
Purchase your second Modal course and we'll set you up with a free 1-year subscription. Learn More.
Register Now!

Data Analysis with SQL

Develop an understanding of relational databases and how to communicate with them using SQL to perform data analysis. Modal  - A better way to learn technical skills.
When
December 9, 2024 - February 2, 2025
Registration closes on November 27, 2024
Course Tuition
$1,950
Want to take more than one course? Send an email to support@modal.com to buy our 1-year subscription for $3,900.
No Up-front Payment
Modal now offers a deferred direct bill payment option for Booz Allen employees.
‍Learn more
Who Is This For?

Employees with little or no SQL experience that are interested in learning the fundamentals of using SQL to interact with relational databases.

Any prerequisites?
  • Basic computer skills (Internet navigation, managing files, troubleshooting).
  • Familiarity with how data is stored in programs like Microsoft Excel.
  • Can dedicate 4-6 hours of study per week and are motivated to learn!
What will I be able to do after this Course?
  • Use basic SQL syntax to interact with data stored in a database.
  • Combine data from multiple tables for analysis.
  • Clean and re-structure messy data for analysis.
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 Schedule

    Live Sessions every
    Sprint 1: Introduction to SQL
    - Learn database fundamentals and use SQL operations and functions to interact with data.
    - Project: Help an airline increase ticket sales by using SQL to analyze data and make a recommendation on how to run a marketing promotion.
    Sprint 2: Querying Multiple Tables
    - Use JOINs to combine data from multiple tables for analysis.
    - Project: Choose the optimal flight routes and services to offer during a fixed promotional period by joining tables, aggregating the data, and performing analysis.
    Sprint 3: Cleaning Your Data
    - Use SQL to clean and re-structure messy data for analysis.
    - Project: Transform a dirty dataset and analyze the results to help an airline choose whether to expand operations.
    Sprint 4: Capstone Project
    Put your SQL skills to the test by helping the airline choose which routes and services to offer at launch. Using your querying and analytical skills, you’ll make your case and provide evidence to support your recommendation.

    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 deferred direct bill payment option for Booz Allen employees.

    The deferred 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. See the full FlexEd Program Policy & FAQs.
    Learn more about FlexEd
    Coming Soon!
    ‍
    Check back in a few weeks or reach out to support@modal.io if you have questions.
    Need help? Contact us
    Apply for FlexEd
    FlexEd Application
    Learn more about FlexEd on Degreed or review the
    FlexEd Program Policy & FAQs

    ‍