Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Whether you're a complete beginner, someone who just finished our SQL Basics in MS SQL Server course, or an SQL Server enthusiast who's simply eager to hone their skills, there's always room for improvement. This practice set will test your basic SQL knowledge and will show you where you need to improve. Remember that mastering SQL is a hands-on experience - learning the concepts is one thing, but writing good queries requires practice.

The scope of this practice set includes:

  • simple SELECT queries;
  • aggregate functions (COUNT(), SUM(), AVG());
  • grouping and ordering results;
  • JOINs (querying from multiple tables, self joins, LEFT JOIN, RIGHT JOIN, and non-equi JOINs);
  • subqueries (simple subqueries, subqueries with multiple results, correlated subqueries, and subqueries in the FROM and SELECT clauses).

The last two parts of the course comprise a special challenge that combines all of the above material for a comprehensive review.

What's in it fo Me?

  • 88 interactive exercises. Learn at your own pace, from any location and at any time. Work through hands-on exercises to help you retain what you have learned so far.
  • Lifetime access to the course. When you purchase the online course, you'll get instant personal access to all of its content forever.
  • Online certificate. After you successfully finish all of the exercises in the online course, you'll receive a downloadable PDF certificate to showcase your accomplishment.
  • 30-day money-back guarantee. If you're not satisfied with the quality of the online course, you can get a refund within 30 days of your purchase.
  • Exercise hints. You can take advantage of ready-made hints for every exercise, or ask questions and share insights with other members of our 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 Do You Need To Take This Course?

Just a web browser and an Internet connection

Who Should Take This Course?

  • Analysts who use relational databases
  • People preparing for a job interview that requires knowledge of MS SQL Server
  • Students taking courses in relational databases
  • Beginning programmers interested in SQL or SQL Server in particular
  • Anyone who finished the SQL Basics in MS SQL Server course or has equivalent knowledge
  • Anyone who wants to practice writing SQL queries in MS SQL Server
    Start this course

    Table of contents

    Progress: 0% completed 0 of 88 exercises done

    1. Warm up: Selecting from one table

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

    More details Less
    Start now

    0% completed 0 of 9 exercises done

    2. Aggregation and grouping

    Test your knowledge of GROUP BY and ORDER BY clauses.

    More details Less
    Start now

    0% completed 0 of 11 exercises done

    3. JOINs

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

    More details Less
    Start now

    0% completed 0 of 32 exercises done

    4. Subqueries

    Verify your knowledge of subqueries. Practice simple and correlated subqueries.

    More details Less
    Start now

    0% completed 0 of 15 exercises done

    5. SQL Challenge

    Practice your SQL skills. Write SQL queries which combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries.

    More details Less
    Start now

    0% completed 0 of 21 exercises done

    Reviews

    Average rating

    5/5100.0 (1)

    Details

    5 Stars 100%
    4 Stars 0%
    3 Stars 0%
    2 Stars 0%
    1 Stars 0%
      Load more reviews

      Comments

      0