Can I Learn SQL in a Week? A 7-Day SQL Plan
By Owen Middleton · Updated November 2026 · We ran the examples on PostgreSQL 17
Yes, you can learn the basics of SQL in a week, at about 1.5 hours a day. By the end, you can get the rows and columns that you want from one table, filter them and sort them. You also make a start on GROUP BY and joins. To write those on your own, plan on about 30 more hours after the week. The basics are a good start, but not enough for a SQL job interview. See how long to learn SQL.
Our advice: do the week, then keep a short session every day.
What you can learn in your first week of SQL
At the end of the week, you can:
- choose the columns and the rows that you want from one table
- filter on two conditions, or on a list, a range or a text pattern
- sort the result, keep the top rows, and remove repeated rows
- find rows where a value is NULL
- add a column that you calculate, and give it a name
You cannot do these yet:
- GROUP BY and joins that you can write with no help (the next goal)
- joins of three or more tables, and subqueries
- CASE WHEN, dates and text functions
- CTEs and window functions
Do not judge the week by how much SQL you have seen. Ask yourself two questions at the end. Can you write a query on one table from a blank editor? Can you explain GROUP BY and a join in your own words?
A 7-day SQL plan for the basics
Plan on about 1.5 hours a day, 10 hours in all. Every lesson below is a free lesson of SQLMaxx Learn, our own SQL course, with a SQL editor on the page. You get no grade on the lesson page, so to check your answer, run the worked solution under the problem and compare its rows with yours.
-
Day 1
Choose the columns and rows that you want from one table.
Start with SELECT and Column Expressions, then: FROM and Table References · WHERE Clause and Comparison Operators
For each lesson, read the lecture, then do the first two easy problems. (6 problems: 6 easy)
-
Day 2
Filter on two conditions, find NULL values, and sort the result.
Start with NULL Semantics and IS NULL, then: Boolean Logic in WHERE (AND, OR, NOT) · ORDER BY and Result Sorting
For each lesson, read the lecture, then do the first two easy problems. (6 problems: 6 easy)
-
Day 3
Keep the top rows, calculate a column, and filter on a list or a pattern.
Start with LIMIT and OFFSET, then: Literal Values, Data Types, and Type Casting · Arithmetic and Comparison Expressions · BETWEEN, IN, and LIKE
Four short lessons. For each lesson, read the lecture, then do the first easy problem. (4 problems: 4 easy)
-
Day 4
Count and total the rows for each group, with the lesson open beside you.
Start with Aggregate Functions (COUNT, SUM, AVG, MIN, MAX), then: GROUP BY
For each lesson, read the lecture, then do the first two easy problems and the first medium problem. (6 problems: 4 easy, 2 medium)
-
Day 5
Keep only the groups that you want, and join two tables on a shared column.
Start with HAVING, then: INNER JOIN
For each lesson, read the lecture, then do the first two easy problems and the first medium problem. (6 problems: 4 easy, 2 medium)
-
Day 6
Find the rows with no match, name your columns, and remove repeated rows.
Start with LEFT JOIN and RIGHT JOIN, then: Column Aliases and Expression Naming · DISTINCT
LEFT JOIN: do the first two easy problems and the first medium problem. Aliases and DISTINCT: do the first easy problem of each. Then do the first easy problem of each Day 4 lesson again, from memory. (7 problems: 6 easy, 1 medium)
-
Day 7
See which queries of the week you can write with no help, and for which you still need the lesson.
No new lesson. Go back to: WHERE Clause and Comparison Operators · GROUP BY · INNER JOIN · LEFT JOIN and RIGHT JOIN
Do the first hard problem of each of these four lessons, with no lesson open. Look at the worked solution only after you run your query. You will probably not solve all four. That is expected. Next week, practice the problems that you cannot solve. (4 problems: 4 hard)
Day 4 is the most important day of the plan. Give it your full time, and read GROUP BY explained with care.
The plan has no day on INSERT, UPDATE or DELETE. If your job is to read data, you need joins more than you need to change data.
What to skip in the SQL plan if you fall behind
Drop only what you do not need later in the week, in this order:
- Day 3. You do not need it for the rest of the week. But you need data types and casting for most lessons after the week, so do Day 3 first next week, before any new lesson.
- HAVING (Day 5). You need it for no later lesson, but it is on our list of SQL topics for data analysts, so do it next week.
- The two repeat problems on Day 6. Keep LEFT JOIN.
Keep GROUP BY and the joins: they are the start of your next goal. Keep Days 1 and 2 too: you need NULL in most lessons after the week.
How to keep the SQL plan on track
The hours that you really have. If you have less time each day, keep the order and stretch the plan (see the first question below). Do not cut GROUP BY or the joins to save time.
Excel or code. If you make pivot tables in Excel, you already know the idea of GROUP BY. If you write code, Days 1 to 3 will be short. Use the time that you save on Days 4 to 6.
Check every answer. You can run a query with no error and still get the wrong rows. Count a problem as done only when your rows are the same as the rows of the worked solution.
A missed session. If you miss a session, do it the next evening and move the rest of the plan back. Do not do two sessions in one evening.
Day 1 of the SQL plan: your first query
Brightlane is our practice online store. Each row of its order_items table is one product in one order.
Schema · ecommerce1 table? = nullable
SELECT order_id, product_id, quantity FROM order_items WHERE quantity >= 2;
| order_id | product_id | quantity |
|---|---|---|
| 1 | 32 | 2 |
| 1 | 22 | 2 |
| 2 | 49 | 2 |
| 8 | 49 | 3 |
Change 2 to 3 and run it again.
In this query, you use all three lessons of Day 1. To learn WHERE, start with its lecture.
What to do after your first week of SQL
Keep the habit before you add topics. Do a short session every day, also on the evenings with no new lesson.
Next week, go on with the next lessons of the course, from CASE WHEN Expressions. Each day, also do one GROUP BY or join problem again, until you can write them with no help. On the way, make sure that you do Joining Multiple Tables, Scalar Subqueries and Subqueries in WHERE (IN, EXISTS, ANY, ALL). They are on our list of what SQL data analysts need.
If you want a grade on every answer, use SQLMaxx Learn: our interactive SQL lessons. There, you start at lesson 1. There is no live teacher to answer your questions.
Common questions about a first week of SQL
Can I learn SQL in 2 weeks?
Yes, and the plan is calmer. At 5 hours a week, the basics take 2 weeks. Do each day of the plan over two evenings. On Days 1 to 3, also do the first medium problem of each lesson.
Can I learn SQL in 7 days with no coding experience?
Yes, for the basics: you need no other programming language first. But if SQL is your first language, we would do the plan over 2 weeks, as in the first question.
Is one week of SQL enough for a job or an interview?
No. For the SQL of an analyst job, plan on about 120 hours from zero. In the week, you do not learn subqueries, CTEs or window functions.
Do I need to install a database to learn SQL in a week?
No. You run every query of this plan in your browser, on the lesson pages and in SQLMaxx Learn.
How we know the hours in this SQL plan
The daily hours are our plan, not a measured time. We took the top of the published range for the basics and divided it by the 7 days of the plan, rounded to the half hour. In the same hours, we add a first look at 5 lessons of joins and GROUP BY. To use those with no help is the next goal, and we print its own time.
Coderhouse, a company that sells live online courses, draws the same line as this plan: basic single-table queries in a week, and joins and aggregations later.
For "most lessons after the week" and "no later lesson", we count every later lesson in the course that you can start only after this lesson, directly or through another lesson. "Most" is more than half of the lessons after the week.
Our pace of 5 hours a week is the pace of the Dataquest path that its guide calls SQL Fundamentals. Today, the path page has the title Learn SQL Skills for Data Analysis.
We do not have measured learning times of our own.
Noble Desktop: SQL learning times
Noble Desktop sells an 18-hour SQL Bootcamp, shown on the same page. Checked November 10, 2026 (source)
- In its table "Time to Proficiency", Noble Desktop gives "5–10 hrs" and "1–2 weeks part-time" to "Write basic SELECT + WHERE queries". Checked November 10, 2026 (source)
- In the same table, Noble Desktop gives "20–40 hrs" and "1–2 months part-time" to be "Comfortable with JOINs + GROUP BY". Checked November 10, 2026 (source)
- In the same table, Noble Desktop gives "60–120 hrs" and "3–6 months part-time" for "Job-ready data analyst SQL". Checked November 10, 2026 (source)
Dataquest: SQL learning times
Dataquest sells online data courses. In this guide, Dataquest points to its own SQL Fundamentals path. Checked November 10, 2026 (source)
Coderhouse: SQL learning times
Coderhouse sells live online courses. On the same page, Coderhouse offers a Data Analytics course with "two weeks dedicated to SQL foundations and SQL for real analysis". Checked November 10, 2026 (source)
- Coderhouse says: "You can learn to read and write basic single-table queries in a week. Joins, aggregations, and analyst-level SQL take longer to become reliable." Checked November 10, 2026 (source)