Basic Course
SQL Practice Set in MS SQL Server
Refine your SQL Server skills with 88 interactive exercises, ranging from simple tasks with SELECT and FROM statements to more advanced problems involving multiple subqueries.
4.83
33,834 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 10 h
Coding challenges 88
Skills you will gain
- Practice basic SQL statements such as SELECT and the WHERE clause.
- Combine multiple datasets effectively using JOIN operations (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, multiple JOIN, self-JOIN, non-equi JOIN).
- Aggregate data with GROUP BY and HAVING.
- Use SQL subqueries, including correlated subqueries.
Last reviews
Description
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
Table of contents
Course progress 0%
Exercises completed 0/88
-
Warm up: Selecting from one table
0/9Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data.
-
Aggregation and grouping
0/11Test your knowledge of GROUP BY and ORDER BY clauses.
-
JOINs
0/32Practice using JOIN, LEFT JOIN, and non-equi JOIN. Check your skills of working with multiple tables.
-
Subqueries
0/15Verify your knowledge of subqueries. Practice simple and correlated subqueries.
-
SQL Challenge
0/21Practice your SQL skills. Write SQL queries which combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries.
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills
