SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach

Worked with SQL years ago, but have gotten beyond rusty. Looking at possible job interview that requires some SQL, using this book along with the fifth edition of Sam's Teach Yourself SQL in 10 Minutes to refresh my memories.Both books would also be good for beginners. I pretty much taught myself SQL using the printed 2nd Edition of Teach Yourself SQL in 10 minutes and the internet. I bought the kindle versions of both books because its much easier to study and solve practice problems when you can have the book up on one screen and the interface to a RDBMS to work the problems on another.

Kudos to Ms. Vasilik for developing a valuable product. My SQL querying skill prior to purchasing this book was, at best, intermediate. I also was not familiar with some newer SQL Server functions (e.g. CTE, Windows functions), having not used the SQL language for several years. As a result, I was forced to perform a bit of on-line research to solve the problems. That was OK; Google is your friend. To benefit from this book, effort is definitely required. It is not a SQL manual that one occasionally references for syntax or examples. Rather, it is the closest substitute for taking a SQL querying class. I learned quite a bit. Repetition is the key. One can know SQL syntax, but still not know how to methodically approach and resolve a problem. I felt this book enhanced my skill in answering various types of real world data questions by forcing me to think rather than feeding me the solutions. I recommend this book to anyone who is willing to expend effort toward enhancing their SQL querying aptitude. It is a valuable tool and I thank Ms. Vasilik for publishing it.

This book is pretty good. I like the fact that it doesn't have a bunch of words to go through and it makes you look outside the book for resources. I've learned some new stuff already, especially about the set up of SSME. The book doesn't teach it, but because I had to go outside the book I found something about SSME I didn't know. I like the book so well, I ordered a Kindle version for my new Fire HD 8.

This book was easy to follow. It started at the absolute lowest level of difficulty and worked up to a more advanced level in an appropriate amount of time. I only wish there was a follow-up book with more problems so I could practice some of the more difficult questions regarding CTEs and CASE statements.

This is a very nice book, and the included resource database along with an excellent setup video, is an extra nice touch. My current job includes hiring candidates to work in various reporting roles and SQL is a key piece of the skill set we require. If you can work through the examples in this book and truly understand them (the explanations for the solutions are nicely done) you would a very good foundation to have a positive interview as well as to be productive very quickly in an entry level reporting role. If you find yourself needing to expand your skill set into SQL, a good basic SQL book like Louis Sapia's "Introduction to SQL Using Microsoft SQL Server" book along with these Practice Problems would bring you up to speed quickly. Very Nicely Done Sylvia!

If you would like to improve your SQL queries take the time to work through these 50 plus problems. Try hard to not look at the solutions, instead try to solve problems yourself. Do a little online searching to help you as you go. When you are happy with your solution or frustrated check your solution against the answers at the back of the book. If you have beginner to intermediate SQL skills, it is well worth the effort and time. I used this book to refresh my skills after years away from working with SQL.

Took me a week to get though the book, about 2 hours a night. I have used SQL professionally for 5 years, about 30% of my time the first 2 years, and 5% of my time in the last 3 years.When I was stumped the problems would have a hint, and generally would require me to then do some study online and return the problem.I gained knowledge on Group Bys with having, CTES, Many Functions I wish I had known about.It has been a good refresher and a good guide to keep me learning. A Very practical way to improve your SQL skills.Ill likely attempt to do the same problems in 3 months and see how many I can solve without hints or a reference manual.

I bought as used but seems to me it is brand new, so the shape met the expectations. Content of the book almost completely met. I wish there were a bit explanations on some of the questions but I am almost half way and it id going great. Very good examples.