JomaClass Presents

SQL for Data Analytics

Get Access
 
Browse Lessons
1. Setup with Mode
6:20

Throughout this course, you will be using Mode Analytics and their SQL editor. We will help you set this up and connect to our database with test data.


2. What is SQL?
12:58

You will learn what SQL actually is and why we use it. We also learn about relational databases and why they are useful.


3. SELECT and FROM
9:50

You will write your first SQL query using the SELECT and FROM keyword. You'll learn to get data out of a table in a database.


4. WHERE and LIMIT
9:14

WHERE and LIMIT are two simple filters that you will learn. Very simple statements but very powerful.


5. Comparison Operators
9:16

There are different ways of filtering, but in the end, it's all about giving conditions that can be either true or false. These are called booleans and with booleans, there are comparison operators.


6. AND, OR, NOT
11:04

More tools to allow you to specify filtering statements. You can be more specific with your constraints with AND OR NOT.


7. LIKE and ILIKE
6:43

Text and strings are common data types stored in tables. Learn how to filter for them with LIKE and ILIKE and learn the difference between them.


8. IN Operator
8:03

You can also have arrays in tables, learn how to check if an element is in a list of elements.


9. IS NULL
5:10

Data is often not very clean. There are many instances where some rows do not have all entries in every column. You will see a lot of NULL values and you'll have to learn to filter them.


10. ORDER BY
10:45

It's very often that you'll need to order your data. For example, if you want to know what your company spends most on? Which client contributes most to our revenue? All these questions you need ordering.


11. COUNT, MIN, MAX, SUM, AVG
10:09

Now that you know how to query data, how do you make sense of it? Most of the time, we want to aggregate it to get insight. How much revenue did we make in total? You'll have to sum all the rows in your data.


12. GROUP BY
16:30

Aggregations are even more useful if you're able to group by certain characteristics. For example, what is the total revenue generated by each age group? Or by each country?


13. HAVING
8:20

Just like WHERE, you can filter your aggregated results by using the statement HAVING.


14. DISTINCT
12:57

Data isn't always clean. Sometimes there are duplicate rows or two rows with the same user id. If you want to count unique users, you'll want to use distinct.


15. CASE WHEN ... END
8:03

If Else statements are useful in programming. In SQL, the equivalent is CASE WHEN statements so you can write custom logic flows.


16. UNION
6:59

Stitching data from one query to another is useful when you have to query different data sources. With UNION you can do that.


17. JOIN
18:07

The most important feature of SQL is the JOIN which is the basis of what relational database means. Data from different tables have relationships with each other. With JOIN, you can unify them.


18. INNER, LEFT, RIGHT, OUTER JOIN
10:51

Learn the different kinds of joins that you might want to use. Knowing the difference is vital whenever debugging your queries.


19. Join Practice
30:39

Let's do a few examples that are very similar to what you'll do in a big tech company. I go trhough common joins you'll need to perform.


20. WINDOW functions
27:37

What if you want to get data that's somehow relates to other rows previously? Most of the time, we can't, but with WINDOW functions, you might be able to get things like Rolling Sum.


21. Conclusion and Everything Else
11:10

You can now write 99% of the queries. The last 1%, there are tons of little tricks, but it's different for every company. You'll learn the keywords to search for when you need to get something done.


SQL for Data Analytics 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.

Recorded
21 lessons
Run time
4h 10m
Difficulty
Beginner

Prerequisites:

  • Own a computer with a web browser
  • Know basic arithmetics

Enroll Today

JomaClass is $8/month (billed annually)

Get Access

Get free JomaClass videos

Enter your email and we’ll send you SQL for Data Analytics videos and some samples of our favorite courses.

Recommended for:

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.


What you'll learn in this class:

  • Query a database using different variations of SQL
  • How to answer product or data questions using SQL editors like Mode Analytics
  • 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

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

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.


Use real-world tools that tech company uses.

 

We will be using Mode Analytics, which many companies like Twitch, Shopify, and Reddit use. Big tech companies use in-house tools that they built themselves, and they're very similar to Mode.

Unlock all courses by joining JomaClass

Watch videos from other classes


What's in every JomaClass subscription?

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

Frequently Asked Questions

Think of it like a Patreon subscription where you get access to all my educational videos on programming, computer science, and data science. I make sure to teach the right things in the right order since a lot of students tend to give up or they don't build the right foundations.

I post multiple videos weekly and I'm constantly working on a new course. In addition, you have full access to a private group where you can interact with me and other students in the community.

A typical course will have around 20 video lessons.

Close

50% Complete

Unlock All Videos and Courses

Create your account to get started.