SQL Practice Tests, Flashcards & More | Varsity Tutors

Skip to main content

Sign in Create a free account

Master SQL

75

TOPICS

12

SECTIONS

SKILL MASTERY

Just getting started

READY

Find your starting point

Build confidence one skill at a time. Pick a topic that sparks your curiosity.

Ways to study

75 skills · 617 questions

All Skills

All

75 core skills 100% total weight

01

Aggregates with WHERE

02

Basic Aggregate Functions

03

Computing Derived Aggregates

04

COUNT(*) vs. COUNT(column)

05

Avoiding Non-Aggregated Columns

06

07

08

HAVING for Group Filtering

09

10

11

Table Constraints

12

DELETE with WHERE

13

14

15

UPDATE with WHERE

16

Integer Division in Metrics

17

Join Duplication Issues

18

LEFT JOIN Filtering Pitfall

19

Three-Valued Logic & NULL

20

Checking NULL Rates

21

Identifying Duplicates

22

Reconciling Aggregates

23

Validating Row Counts

24

CASE WHEN for Categories

25

COALESCE & IFNULL

26

Creating Flags & Buckets

27

Date Range Filtering

28

Date/Timestamp Parsing

29

String Functions

30

Many-to-Many Modeling

31

32

Primary & Foreign Keys

33

Avoiding Join Mistakes

34

35

36

Multi-Key Joins

37

RIGHT JOIN & FULL OUTER JOIN

38

39

Multi-Table Joins

40

41

EXPLAIN/QUERY PLAN

42

43

Indexes for Performance

44

45

IN, BETWEEN & LIKE

46

IS NULL / IS NOT NULL

47

48

WHERE Filtering

49

50

Multi-Column Ordering

51

52

Cohort & Segmentation Queries

53

Communicating Query Assumptions

54

Defining & Implementing Metrics

55

Parameterized Reporting Queries

56

Identifying Keys

57

NULL & Missingness

58

Set-Based Thinking

59

Table Relationships

60

Tables, Rows & Schemas

61

SQL Dialect Differences

62

SQL Logical Order

63

64

Common Table Expressions (CTEs)

65

66

67

Correlated Subqueries

68

69

Scalar Subqueries

70

Subqueries in WHERE

71

72

Ranking Functions

73

Running Totals & Moving Averages

74

Window Functions & GROUP BY

75

Windowed Aggregates