Bring your SQL skills to the next level with real-world practice problems

It's easy to find information on SQL online. A simple search will overwhelm you with an avalanche of information.

Here’s what’s much harder to find. Challenging, well-designed problems. Problems that will take you, one small step at a time, from beginner level, basic SQL all the way to advanced SQL.

SQL Practice Problems walks you through challenging, unique, and fun problems.

With problems like these, you can actually enjoy learning SQL! It has the real-life practice problems you need, clearly presented, easily paced, with hints if you want them.

How can you get a job involving data if you don’t have experience working with data?



When I worked at Expedia, I regularly interviewed people for jobs as database developers and data engineers. And I ran into an interesting situation. Applicants were asked to rank themselves on their SQL knowledge, on a scale of 1-10, with 10 being the highest (SQL expert).

Most applicants rated themselves at 9 or 10. In other words, they were experts. However, when I asked them to solve data problems by writing SQL, they couldn’t do it! And these weren’t hard problems—they were just a step above beginner level.

Why couldn’t they solve problems? ​

The applicants were intelligent people, who had studied hard and had “book knowledge” on databases and SQL.

But when they were presented with a real-world problem, they had a very hard time. They just didn’t have the experience they needed to figure out how to handle a data problem.

It’s a “which came first: the chicken or the egg?” issue. In other words, it’s hard to get a data related job unless you have experience with SQL and other data tools. And it’s hard to get that experience unless you have the job.

Why SQL?

The world of computer technology changes very quickly, and databases are no exception. The latest data-related buzzwords are data lakes, data science, the Internet of Things (IOT), data wrangling, machine learning, etc. Buzzwords that have been around a little longer are big data, cloud data, ETL, data analytics, dashboards, business intelligence, etc.

But...what basic, fundamental skill do you need, in order to work with any of these new database technologies?

SQL! SQL is necessary for almost everything data related. Database systems have been around since the 1970’s and are used extensively at all companies and organizations. And to work with these databases at anything other than a very basic level, you need to understand and write SQL.

And unlike some other technologies and programming languages (which change very frequently), SQL is much more stable. Once you learn it, it’s a skill you can use for a lifetime.

Who should buy SQL Practice Problems? check Data analysts who need to come up to speed on SQL

check Software developers who need to learn how to write efficient, accurate SQL

check People interviewing for jobs where they will be asked to write Select queries

check Data scientists and data engineers who don’t yet have years of experience with SQL

check Anyone who wants to upgrade their SQL knowledge

check Anyone who needs to make sense of massive amounts of data, search for patterns and solve problems Get SQL Practice Problems now!

How important is real-life, hands-on problem solving?​

You can watch videos online that will walk you through various aspects of databases, and SQL. And you can read up on SQL syntax and keywords, and review sample code.

But... ​

You can do all of that, without absorbing much at all. Without absorbing the knowledge that will allow you to solve new problems on the job.

To really absorb and be able to apply your learning, you need to do real-world problems. Being presented with a SQL problem, and working through that problem (with hints, if necessary) will help you understand and remember concepts and principles like nothing else.

This is where

SQL Practice Problems

will help you!

Learning basic SQL—that’s easy. You can find

that level of training for free.

However, learning how to think through a data problem, break it down to the fundamentals, and craft an elegant, readable solution in SQL—that’s much harder to teach, and to learn.

It requires practice and experience. And most of the time, that level of practice and experience only comes from years of real world work with large datasets.

But by working though the carefully crafted problem sets in SQL Practice Problems, you can develop skills equivalent to those years of experience. And these skills will help you get the job you want.

This is one of the top few computer books that I have ever read (and I've read hundreds)! It has been a pleasure to work through. The problems are carefully thought out, and clearly expressed. I couldn't be more pleased with this book! Jaz C.

I started a SQL study course with Coursera, however found it very confusing and not that similar to what I might see in the real world. I found your book way more challenging for me and liked the real life exercises. Really liked the book! Tinti

30 Days Money Back Guarantee This book comes with a 100% guarantee. SQL Practice Problems is packed with valuable and challenging problems that will develop your skills with data and SQL. However, if you decide it's not for you, just let me know. I'll refund your payment within 30 days of purchase.

Getting the right type of SQL practice

It would have been easy to create a set of practice problems that just illustrate the main keywords in SQL.

Easy, but not useful.

Much more difficult to create, and much more valuable, are practice problems that cover the most common issues that you’ll encounter in your work with data. You can be sure that if a problem shows up in SQL Practice Problems, it’s one that will come up repeatedly in day-to-day work with data. Working through the problems will give you a very solid grounding in SQL.

SQL Practice Problems will teach you how to "think" in SQL, how to analyze data problems, figure out the fundamentals, and work towards a solution that you can be proud of. It contains challenging problems, that hone your ability to write high quality SQL code.

I am starting from scratch, all self-taught so far in SQL, and was picking up the syntax and wording, but I could not find anything to give me real world application and scenarios. This book changed that! Great book, great problems, really makes you think, and still offers guidance! Molly G.

Great book for any level! Straight to the point with excellent explanation. Questions start you off at beginner level and get more challenging towards the end. I was hoping for more after I reached the end. Her approach gets you started without any nonsense. I highly recommend this book and it should be on every data analyst's shelf (beginner to advanced levels). Arnold

No monthly subscriptions—just a one-time payment

For most SQL training websites, the only payment option is a monthly subscription. And the only way to access the material is by logging in to their website.

This works well for them. By not directly providing the learning material to you, they avoid the risk of copy/paste piracy. And many people forget to cancel the monthly subscription, even after they've stopped using it.

This is not what I do with SQL Practice Problems. You pay a one-time fee, and get lifetime updates. You get the full problem set, along with the complete instructions (with a video walk-through) for setting up the sample database. You work with the exact same tools that you would use in a work environment.

What kind of problems are there in SQL Practice Problems?

With SQL Practice Problems, you’ll get experience solving some of the most common challenges you'll run into with data, and the best, most useful techniques to solve them.

It has data analysis and reporting oriented challenges that are designed to step you through introductory, intermediate and advanced SQL Select statements, with a “learn-by-doing” technique. The problems are business oriented, and use an order database. Working through the problems and absorbing the techniques presented—this is what will give you the skill and experience you need to solve real-life data problems.

What types of problems do other SQL courses

and training materials have?

Most SQL tutorials, textbooks, and courses have some practice problems. But they’re bloated. For the sake of completeness, most SQL keywords and syntax are included, even the useless ones. Studying these materials can be a massive waste of time.

SQL Practice Problems is different. Based on my years of experience working with data, I present those data problems that come up all the time. As the difficulty of the practice problems increases gradually, you’re continually challenged. The problems are unique and even fun—you can actually enjoy learning SQL!

I took a SQL course online but it was very generic, and there were no challenging problems to solve. This is exactly what I needed to get some more practice with SQL. I skipped the introductory problems. I went right into the intermediate problems. Tried not to use the hints, but ended up using them a few times. The answers and explanations are concise, and get right to the point. Very practical. I have a lot more confidence writing SQL at work now A. C.

I have numerous books on SQL, and have taken courses from people with lots of experience with data and SQL. Alas, knowing the material is not the same as being able to present it clearly and in digestible bites. Obviously, you have that knack. I have learned things from your book that nobody ever showed me before. I sincerely hope that you will write more books. H. V

Start Learning Now: Choose The Package

That's Right For You Below Basic Buy - $24 Professional Buy - $49 SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach Step-by-step video to walk you through practice database setup “No Hints” version of problems Email support for any issues More SQL Practice Problems: an additional 40 intermediate and advanced challenges for you to solve using a “learn-by-doing” approach Both Microsoft SQL Server and MySQL version of SQL Practice Problems and More SQL Practice Problems (basic version contains Microsoft SQL Server version only) Free updates for as long as the product exists

Why did I create this course?

Hi, my name is Sylvia Moestl Vasilik. I've been a senior data engineer, architect and database programmer for more than 15 years, working at top organizations like Expedia, Microsoft, T-Mobile, and the Gates Foundation. I write on database topics on my DatabasesAreFun blog .

A while back, I was teaching a SQL Server Certificate course with the University of Washington Professional Education program. It was a 10 week course, and my students paid more than $1000 for it. They learned the basics of SQL, most of the keywords, and worked through practice problems every week.

What was missing?

But I wasn’t really happy with what they were learning. Because of the emphasis on getting a overview of all features of SQL, we didn't spend enough time on the SQL that’s used 95% of the time—intermediate and advanced Select statements.

Yes, the students learned a lot about SQL. However, they spent a tremendous amount of money, and many hours every week, working through a dry manual, instead of solving real world data problems.

My inspiration to create SQL Practice Problems

After the course was over, one of my students emailed me. He wrote:

“My problem is that I work with SQL on such limited terms that I rarely have to solve interesting problems. I'd like to work on more complex data problems. Where can I find them?”

Then 2 days later, a parent at my son's school asked me the same question. She said: "I've taken a course, and know the basics. But where can I find more advanced data problems, that teach me real-world SQL?"

That's when I realized that there’s a desperate need for a set of practical, real-world SQL practice problems. Problems that will help people get the experience they need, for the jobs they want, packaged in an easy-to-follow, "learn-by-doing" format.

“An investment in knowledge always pays the best dividends.” - Benjamin Franklin -

You can’t learn by watching videos

​Learning sticks with you when you’re actually solving real problems, using the same tools you would use in a work environment.

Watching other people explain concepts on videos is fine for a shallow, introductory understanding. But you won't be able to solve problems.

Videos will not give you the hands-on experience that you need. For that, you need well-designed practice problems that teach data-oriented thinking through actual doing. Working through well-designed problems is the gold standard for learning.

This volume does exactly what it describes--provide practical and challenging problems to solve in SQL Server. No fanfare, no extra words, just straightforward questions/problems that need answers. It’s refreshing to see someone write a volume such as this, that has a really practical side—real-life problems for real-life solutions. John. T.

Great book. Love the practice problems as I learn better by doing vs. reading. Denise C.

Other SQL learning materials

Maybe you’ve tried and failed to get a better understanding of SQL, after multiple online courses and books. Many readers have emailed me, and said that they paid hundreds and even thousands of dollars for other educational materials that promised to teach SQL, that were—and this is a direct quote—"useless".

These materials were frequently just a reformatted version of the online documentation. Or they were extremely wordy, forcing them go through pages and pages of text to find anything useful.

They finally succeeded in learning SQL by working through these practice problems, step-by-step. This is what really helped them learn, and retain that learning.

...and yet More SQL Practice Problems My original book had 57 beginning, intermediate, and advanced challenges. Then I started getting requests from readers over the past year for more problems! So, I decided to write another book, with a whole new set of problems for customers—More SQL Practice Problems!

I skipped the introductory section, and jumped straight to intermediate/advanced problems. The book uses an entirely different practice database, and a completely new set of 40 problems. It also assumes that you've completed the original SQL Practice Problems recently, so the concepts are fresh in your memory.

More SQL Practice Problems will introduce more advanced topics and techniques, and give you the practice you need to consolidate your understanding of SQL.

This is THE book to turn to if you want to improve your SQL skills. I've been using SQL for 15 years and still found this book to be of great help. I was interviewing for a new position recently and had trouble answering some complicated questions on the spot. Every type of question asked at my interview was in this book. Now I practice the Intermediate and Advanced problems once a week and am able to solve these within seconds. S. Anderson

Probably the most useful technical book I've used! Challenging problems with appropriate hints - use as needed. She should be writing other books. A. J.

The No-Hint version

In the standard version of both SQL Practice Problems and More SQL Practice Problems, most questions have numerous hints that you can use to move forward in solving the practice problem. They’re very useful if you’re completely stuck on a problem.

However, based on numerous requests from readers, I’ve created a special ‘no-hints’ version of the book. But wait—not using the hints sound like more work! Why did my readers want this, and why do I now strongly recommend using this version?

Why did I create the No-Hint version?

The latest research on brain function and learning teaches us that the more effort you need to put into solving a problem, the more deeply it sinks in. And the more easily you’re be able to solve new problems.

In real life, when you’re trying to solve data problems, you won’t have handy, step-by-step hints that lead you to the answer. You’ll be able to search online for help—I always recommend this—but you won’t have hints like these.

Learning at a deeper level...

So, to help you to learn at a deeper level—which involves a little more struggle—I also provide the ‘No-Hint’ version.

I recommend printing out the No-Hint version, and working from that. Use the full version if you’re stuck. Or, you can do what some of my readers have done—use the full (hints included) version the first time around, and then go through the questions a second time, without hints, to test their learning.

A fantastic book for those who want to get real hands-on experience with SQL. As the book suggests, you can only learn so much by viewing tutorials - actually grasping the concepts can only be done by doing problems. I wish there were more books like this! Sylvia, please make others like this! Agosh

Got this book for more practical examples to apply SQL in the real world, and this book is amazing! It guides you through very easy examples and gradually challenges you to solve more challenging problems. I will highly recommend this book to people that are starting in SQL or looking to apply SQL in more realistic, day-to-day business problems. P.N.

What do I need in order to use SQL Practice Problems?

If you're buying the Basic package, you'll need a computer running Windows.

If you'd like to use SQL Practice Problems on a Mac, you'll need to purchase the Professional package, which includes the MySQL edition (as well as other features, including an additional problem set). MySQL can easily be installed on a Mac.

Does SQL Practice Problems include SQL programming?

No. These practice problems involve only Select statements, used for data analysis, reporting, and business intelligence. It does not include modifying data (insert, delete, or update statements), or any kind of SQL programming, including stored procedures and functions.

Why did I do this? Because Select statements are by far the most commonly used SQL. They're the most complex. And most importantly, they're the most difficult to get practice and experience in.

I thought about writing another book about SQL programming and modifying data, but I got only one or two customer requests for that.

Almost all my requests were for more practice problems, and more advanced practice problems, on Select statements. So that’s what I worked on, and put into the Professional package.

30 Days Money Back Guarantee SQL Practice Problems comes with a 100% guarantee. It is packed with valuable and challenging problems that will develop your skills with data and SQL. However, if you decide it's not for you, just let me know. I'll refund your payment within 30 days of purchase.

Practice makes perfect

Cognitive research proves what we already know—that reading alone doesn’t get you much, either in terms of understanding and remembering, or being able to apply your knowledge.

But reading less, and doing more—being presented with a problem, and then asked to solve it – this changes things. You stay awake, and learning becomes more interesting. Maybe even fun!

Don’t fool yourself—you need to do the problems

Let’s be honest—when you’re just reading text or watching videos, it’s easy to fool yourself into believing that you’re learning a lot more than you really are.

But when you’re continually being challenged to solve problems, it keeps things real. You know for sure—either you can solve the problem, or you can’t. If you can’t solve the problem, you go back, maybe look at the hints, or look for help online. Then you try again. And once you’ve solved a practice problem in this book, you know you can solve it again, in real life.

Frequently Asked Questions (FAQ)