Basic Course

Basic SQL Practice: A Store

Do you want to practice SQL? Are you looking for problems to help you practice what you've learned? You've come to the right place! Here are 169 interactive online exercises that will take your skills to the next level.

4.61 ★★★★★ ★★★★★ (500 ratings)

3,951 learners enrolled

Lifetime access

limited to this course only

$39

Want a better deal?

Get unlimited lifetime access to all 71 present and future courses

Save $450

Unlimited lifetime access

to all 71 present and future courses

$149 $599

75% OFF

Free trial Yes

Certificate of completion Yes

Time to complete 12 h

Coding challenges 169

Skills you will gain

  • Write simple SELECT queries to get data from a single table
  • Filter data with WHERE by using different number comparison operators, text patterns, and Boolean conditions, while combining these with AND, OR, and NOT
  • Sort query results with ORDER BY, using ASCending and DESCending order
  • Combine data from multiple tables using JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
  • Write challenging queries with JOIN, such as multiple JOIN, self-joins, and non-equi JOIN
  • Group data with GROUP BY, and computing statistics using aggregate functions COUNT(), AVG(), SUM(), MIN(), and MAX()
  • Use mathematical functions to perform simple calculations in SQL
  • Work with NULL in SQL queries using IS NULL and IS NOT NULL operators
  • Write subqueries, including correlated subqueries
  • Merge query results using set operations UNION, INTERSECT, and EXCEPT
  • Combine all basic SQL features in a challenging advanced queries section

Last reviews

Table of contents

Course progress 0%

Exercises completed 0/169

  1. Selecting from one table

    0/34

    Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data.

  2. JOIN

    0/30

    Practice using JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and non-equi JOIN. Check your skills of working with multiple tables.

  3. ORDER BY

    0/23

    Practice sorting the rows by single and multiple columns.

  4. GROUP BY

    0/36

    Test your knowledge of GROUP BY and HAVING clauses.

  5. Other SQL Features

    0/29

    Practice making calculations and dealing with NULLs and set operators. Verify your knowledge of subqueries. Practice simple and correlated subqueries.

  6. Advanced queries

    0/17

    Write some more advanced queries which combine SELECT, WHERE, different kinds of JOINs, GROUP BY, HAVING, ORDER BY, set operators, and subqueries.

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Description

The best way to learn SQL is through practice. After all, writing SQL is a practical skill. However, it's difficult to find good SQL practice problems for beginners. That's why we created this course.

Have you just started learning SQL? Or, maybe you already know the basics and are now looking for new challenges. If so, this course is for you. It will allow you to practice writing basic SQL queries.

Try to solve 169 interactive exercises grouped into different SQL topics: selecting from one table, JOINs, ORDER BY, GROUP BY, subqueries, and set operations. Each section of the course starts with a brief review of the SQL syntax needed to solve the exercises. This is followed by hands-on, real-world tasks specially designed to strengthen your SQL skills.

You can choose only the topics that are difficult for you. Or, you can complete all of them to make sure you have mastered the basics of SQL. We selected topics that are challenging for beginners and often appear in exams or during job interviews to give you the most comprehensive SQL practice possible.

The exercises in this online SQL problem set are based on a database for a simple store. You'll work with tables that contain customer, product, purchase, and employee data. And you'll practice writing queries such as how to list top-selling products, how to identify the best employees, and how to identify which customers have spent the most in the store.

Our Basic SQL Practice course gives you the opportunity to practice frequently used queries on a simple database. You will be able to immediately apply some of them in your projects, while others can be easily adapted.

Do you run a shop or online store? Learn how to master the data you collect. This will help you gain even greater profits. Knowing how to use SQL simply pays off.

To take full advantage of this course, you should know how to write simple SELECT queries, how to use the WHERE clause, what an SQL JOIN is, and how GROUP BY and HAVING work. You can learn this all in our SQL Basics course. After you finish it, come back here to practice what you learned.

This course is interactive. You'll practice writing actual SQL queries to solve exercises in your web browser. Our web-based platform will run your command and verify your solution. You don't need to install anything on your computer, so you can start practicing right away.

What's in It for Me?

  • 169 interactive exercises to practice writing SQL queries: practice at your own pace, from anywhere and at any time, interacting with hands-on exercises for improved retention
  • Lifetime access to the course: when you purchase the course, you'll get instant personal access to all of its content
  • Certificate of completion: you'll get a downloadable PDF certificate to showcase your accomplishment
  • 30-day, money-back guarantee: if you're not satisfied with the quality of the course, you can get a refund within 30 days of your purchase
  • Hints and support: you can ask questions and share insights with other members of the community through the Discuss tab (you can also drop us a line at contact@learnsql.com, and we'll be more than happy to answer!)

What Are the Requirements?

  • Knowledge of basic SQL (for example, take this after completing our SQL Basics course)
  • Web browser

What Will I Practice in This Course?

  • Writing simple SELECT queries to get data from a single table
  • Filtering data with WHERE by using different number comparison operators, text patterns, and Boolean conditions, while combining these with AND, OR, and NOT
  • Sorting query results with ORDER BY, using ASCending and DESCending order
  • Combining data from multiple tables using JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
  • Writing challenging queries with JOIN, such as multiple JOIN, self-joins, and non-equi JOIN
  • Grouping data with GROUP BY, and computing statistics using aggregate functions COUNT(), AVG(), SUM(), MIN(), and MAX()
  • Using mathematical functions to perform simple calculations in SQL
  • Working with NULL in SQL queries using IS NULL and IS NOT NULL operators
  • Writing subqueries, including correlated subqueries
  • Merging query results using set operations UNION, INTERSECT, and EXCEPT
  • Combining all basic SQL features in a challenging advanced queries section

Who Should Take This Course?

  • SQL beginners who want to practice their SQL skills
  • People preparing for job interviews requiring SQL
  • Students taking SQL and database exams
  • Store owners and managers who want to start using the power of databases
  • Anyone who is looking for SQL practice problems

Reviews (1)

Average rating

4.61/5

★★★★★ ★★★★★ (500 ratings)

5 stars

74%

4 stars

13%

3 stars

13%

2 stars

0%

1 stars

0%