JomaClass presents:

SQL for Data Analysis

SQL for Data Analysis is a beginners' course that will teach you everything you need to know to start using SQL to query data. I'm going to teach it in the way that I learned it through working at big tech companies. I'll be using tools that are very similar to what you'll use at a company like Facebook. My assignments try to mimic what you'll encounter when you work at a company with lots of user data.
Get Access

Included in this class:

  • 21 high quality on-demand videos
  • 5 Assignments
  • 1 Final Project: Create a report on a fictional tech company
  • Access to your instructor to answer all your questions about the course content

Course Content

  • Setup with Mode (6:20)
  • What is SQL? (12:58)
  • SELECT and FROM (9:50)
  • WHERE and LIMIT (9:14)
  • Comparison Operators (9:16)
  • AND, OR, NOT (11:04)
  • LIKE and ILIKE (6:43)
  • IN (8:03)
  • IS NULL (5:10)
  • ORDER BY (10:45)
  • Aggregation functions: COUNT, MIN, MAX, SUM, AVG (10:09)
  • GROUP BY (16:30)
  • HAVING (8:20)
  • DISTINCT (12:57)
  • CASE WHEN ... END (8:03)
  • UNION (6:59)
  • JOIN (18:07)
  • Join Practice (30:39)
  • WINDOW functions (27:37)
  • Conclusion and Everything Else (11:10)

For more sample videos on SQL for Data Analysis or other updates related to JomaClass. Subscribe here.

Lists: What are they?

Class Sample
Course Content:
  • What is programming?
  • Variables
  • Data Types and Operators
  • Functions
  • Control Flow
  • Lists
  • Loops
  • Matrices
  • Recursion
  • Backtracking


This class is currently at full capacity. We are required to restrict the class so that we can focus on each student.

If you wish to join the class you will have to get on the waitlist. It is first come first serve.

For people who are

Data Scientists

Data Science is a combination of computer science and statistics. The most common way you'll work with data is to query them out of a database. Hence you'll need SQL for that.

Software Engineers

Even as a software engineer, at big tech companies, you'll have to monitor your features you've built and perform analysis on them. There's no escaping SQL, it's one of the easiest way to query data. You'll be looking at your logs often which is stored in a database.

Data Analysts + Business Intelligence

This is especially important for Product Analysts or roles that are similar. You will act as the person who most understands your product through data. You need to be able to questions like "what's our user retention like", "where does the user traffic come from", etc.

Get Your All-Access Pass

Every subscription will get access to:

  • New videos every week!
  • 20+ on-demand videos
  • 15+ quizzes and assignments
  • Access to your Instructor Joma within every class to answer your questions
  • All existing and future classes on Data Science and Computer Science

Pay Yearly Save 60%


Most Popular

Get Started

Pay Monthly


Get Started

What you'll learn

Querying a database using different variations of SQL

How to answer product or data questions using SQL editors like Mode

Create visualizations using tools (like Mode analytics) that are similar to the ones you'll use in big tech companies. 

Learn how to think like an analyst to find and present insights from digging into a company's data

Apply what you've learned with Assignments

The assignments will allow you to apply what you've learned throughout the course. They are problems meant to challenge you, allowing you to learn useful tools when working as an analyst.

Note: The assignment requires you to access our internal database for the students. Also, this assignment references older assignments.

Look at a sample, download here.

What’s in every
JomaClass subscription?

  • Access to Joma for mentorship through private forum
  • All 80+ high quality videos from other classes
  • New videos added every week

Watch videos from other classes

Code Foundations | Data Science | Computer Science

See All Videos

Frequently asked questions

Get Access to All Videos and Courses

For any questions, email [email protected]

Get Access