SQL for Data Analysis
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
- 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)
- INNER, LEFT, RIGHT, OUTER JOIN (10:51)
- 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.
For people who are
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.
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
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.