SQL Tutorial
The language of databases used for database manipulation and analysis
List of Lessons to Learn SQL
This is a list of SQL lessons where you can start learning immediately without environment setup.
Study
SQL I
Estimated 2h
0%
SQL a database language used for data management and analysis. You will learn the basics of using SQL in this lesson.
What You Can Learn in This Lesson
-
1. Getting Data
-
What Is a Database?
-
What Is a Query?
-
Selecting Multiple Columns
-
-
2. Getting Specific Rows
-
WHERE
-
WHERE (2)
-
Comparison Operators
-
LIKE
-
LIKE (2)
-
NOT
-
IS NULL・IS NOT NULL
-
AND・OR
-
-
3. Processing the Results
-
ORDER BY
-
LIMIT
-
-
4. Final Project
-
Applying What You've Learned
-
Study
SQL II
Estimated 1h
0%
In this lesson, we'll learn how to use the aggregate function and grouping. We’ll use these SQL techniques to analyze Ken the Ninja’s spending habits!
What You Can Learn in This Lesson
-
1. Process Search Results
-
DISTINCT
-
Arithmetic Operators
-
-
2. Using Aggregate Functions
-
SUM
-
AVG
-
COUNT
-
MAX・MIN
-
-
3. Grouping Data
-
GROUP BY
-
GROUP BY with Multiple Columns
-
GROUP BY (WHERE)
-
HAVING
-
-
4. Final Project
-
Applying What You've Learned
-
Study
SQL III
Estimated 2h
0%
You will learn to get data from multiple tables in this lesson. Strengthen your SQL skills by mastering subqueries and JOIN!
What You Can Learn in This Lesson
-
1. Using Subqueries
-
The players Table
-
Subqueries
-
AS
-
-
2. Multiple Tables
-
The countries Table
-
Combining Tables
-
JOIN
-
JOIN (2)
-
The teams Table
-
LEFT JOIN
-
Combining Three Tables
-
-
3. Final Challenges
-
Applying Your Skills
-
Dojo
SQL I
Estimated 2h
0%
Use the skills you learned in the first 3 SQL Study lessons to take on these practical challenges. As you progress, the challenges will become gradually more difficult. Take your t...
What You Can Learn in This Lesson
-
1. Analyzing a Fashion Site Database
-
Analysis with SQL
-
Users
-
Product Analysis
-
Products Analysis (2)
-
Product Analysis (3)
-
Sales History
-
Sales and Profits
-
Daily Analysis
-
Complex User Data
-
Complex Product Data Analysis
-
Study
SQL IV
Estimated 1h
0%
In this lesson, you will learn how to add, update, and delete data!
What You Can Learn in This Lesson
-
1. Adding, Updating, and Deleting Data
-
INSERT
-
UPDATE
-
DELETE
-
-
2. Solidifying Your Skills
-
Practicing What You've Learned
-
After Finishing SQL Lessons
Set up your SQL environment and apply what you've learned in the real world.
Articles Related to SQL
Read articles to learn tips and knowledge about SQL.
Courses Related to SQL
Expand what you can do by learning related courses.
Start the lesson from the initial state.
Warning: your code will be deleted.
Review the lesson without
resetting your code.