Log inSign up
Course

SQL

Get personalized support from expert tutors and AI-powered study tools.

Personalized practice Exam · Set a test date 12 units · 75 topics
Generate study planExplore skills
Your study plan
Free with a Varsity Tutors account
Free
Turn this SQL outline into a plan
A week-by-week plan
Paced to your test date and rebuilt whenever your SQL scores move.
A score projection
See where you stand today and what each study block is worth.
Progress that sticks
Lessons, flashcards, and quizzes tracked in one place, on every device.
Create your free plan
Takes a minute · No credit card required
Your next tutoring session · SQL prep Ready when you are
No upcoming SQL tutoring session scheduled
Book a tutoring session when you are ready to work with an expert.
Book a tutor

Ways to study

Subject resources
Long-form
Long-form Lessons
Open lessons
617 questions
Quizzes
Take a quiz

SQL

Practice 75 skills across this outline.

Recommended next
Normalization
Database Design
Long-form lesson
Weighting distribution
20 categories
Database Design
8%
SQL for Analytics and Reporting
8%
Performance and Optimization
8%
Window Functions
8%
SQL Foundations · Relational Data Concepts
6%
Subqueries and CTEs · Common Table Expressions (CTEs)
6%

Skills

The comprehensive taxonomy of sql — drill into a card to work its skills.

Database Design

3 core skills8% total weight
0/3 completed
3 skills to mastery
1
NormalizationRecommended
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
Primary & Foreign KeysAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
Many-to-Many ModelingAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

SQL for Analytics and Reporting

4 core skills8% total weight
0/4 completed
4 skills to mastery
1
Communicating Query AssumptionsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
Defining & Implementing MetricsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
Parameterized Reporting QueriesAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
4
Cohort & Segmentation QueriesAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet

Data Definition and Manipulation · DDL Basics

3 core skills4% total weight
0/3 completed
3 skills to mastery
1
CREATE TABLEAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
ALTER TABLEAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
Table ConstraintsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Data Definition and Manipulation · DML Basics

4 core skills4% total weight
0/4 completed
4 skills to mastery
1
DELETE with WHEREAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
INSERTAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
3
TransactionsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
4
UPDATE with WHEREAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Aggregation and Grouping · Aggregate Functions

4 core skills5% total weight
0/4 completed
4 skills to mastery
1
Basic Aggregate FunctionsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
COUNT(*) vs. COUNT(column)Available
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
3
Computing Derived AggregatesAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
4
Aggregates with WHEREAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Aggregation and Grouping · GROUP BY and HAVING

4 core skills3% total weight
0/4 completed
4 skills to mastery
1
Grouping SetsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
GROUP BYAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
3
HAVING for Group FilteringAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
4
Avoiding Non-Aggregated ColumnsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Data Transformation · Case Expressions and Conditional Logic

3 core skills4% total weight
0/3 completed
3 skills to mastery
1
COALESCE & IFNULLAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
CASE WHEN for CategoriesAvailable
9 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
Creating Flags & BucketsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Data Transformation · String and Date Functions

3 core skills4% total weight
0/3 completed
3 skills to mastery
1
String FunctionsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
Date Range FilteringAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
Date/Timestamp ParsingAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Data Quality and Debugging · Common SQL Pitfalls

4 core skills4% total weight
0/4 completed
4 skills to mastery
1
Integer Division in MetricsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
LEFT JOIN Filtering PitfallAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
3
Join Duplication IssuesAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
4
Three-Valued Logic & NULLAvailable
15 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Data Quality and Debugging · Validation and Sanity Checks

4 core skills4% total weight
0/4 completed
4 skills to mastery
1
Identifying DuplicatesAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
Reconciling AggregatesAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
Checking NULL RatesAvailable
9 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
4
Validating Row CountsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Joins and Relationships · Join Types and Keys

5 core skills5% total weight
0/5 completed
5 skills to mastery
1
Multi-Key JoinsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
Avoiding Join MistakesAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
RIGHT JOIN & FULL OUTER JOINAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
4
INNER JOINAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
5
LEFT JOINAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Joins and Relationships · Multi-Table Joins and Self-Joins

3 core skills4% total weight
0/3 completed
3 skills to mastery
1
Bridge TablesAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
Self-JoinsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
Multi-Table JoinsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Performance and Optimization

3 core skills8% total weight
0/3 completed
3 skills to mastery
1
Indexes for PerformanceAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
Index BasicsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
EXPLAIN/QUERY PLANAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Querying Data · SELECT and Filtering

5 core skills5% total weight
0/5 completed
5 skills to mastery
1
IS NULL / IS NOT NULLAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
SELECT QueriesAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
WHERE FilteringAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
4
DISTINCTAvailable
15 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
5
IN, BETWEEN & LIKEAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Querying Data · Sorting and Limiting

3 core skills3% total weight
0/3 completed
3 skills to mastery
1
Multi-Column OrderingAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
LIMIT/TOPAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
ORDER BYAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

SQL Foundations · Relational Data Concepts

5 core skills6% total weight
0/5 completed
5 skills to mastery
1
Identifying KeysAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
Tables, Rows & SchemasAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
3
NULL & MissingnessAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
4
Set-Based ThinkingAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
5
Table RelationshipsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

SQL Foundations · SQL Query Structure

3 core skills2% total weight
0/3 completed
3 skills to mastery
1
Table AliasesAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
SQL Logical OrderAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
3
SQL Dialect DifferencesAvailable
9 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Window Functions

5 core skills8% total weight
0/5 completed
5 skills to mastery
1
Window Functions & GROUP BYAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
2
LAG/LEADAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
3
Running Totals & Moving AveragesAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
4
Ranking FunctionsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
5
Windowed AggregatesAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

Subqueries and CTEs · Subqueries

4 core skills3% total weight
0/4 completed
4 skills to mastery
1
EXISTS vs. INAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
Correlated SubqueriesAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
3
Subqueries in WHEREAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
4
Scalar SubqueriesAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet

Subqueries and CTEs · Common Table Expressions (CTEs)

3 core skills6% total weight
0/3 completed
3 skills to mastery
1
Common Table Expressions (CTEs)Available
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems
2
Multiple CTEsAvailable
0 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems — not available yet
3
Recursive CTEsAvailable
10 questions 0 flashcards Lesson available
Long-form lessonSlide-style lessonFlashcards — not available yetPractice problems

No SQL classes or courses found here yet

Open the full catalogs to browse everything currently available.

Related SQL tutors

Browse tutors who can help with this subject.
View all tutors
Expert tutoring

No related SQL tutors found

Browse the full gallery to find a vetted expert who can help with SQL.