The Big Book Of SQL Queries: 250+ SQL Practice Queries (SQL Series) - Softcover

Murphy, Indera E.

Softcover

ISBN 10: 1935208497 ISBN 13: 9781935208495

Publisher: Tolana Publishing, 2020

Synopsis

This book will let your test your SQL query skills. There are over 250 questions in this book that you can use to test your query design skills, in any of the following SQL databases: SQL Server (T-SQL), MySQL, SQLite, PostgreSQL or Oracle SQL.

Yes, you can search online to get some examples that may point you in the right direction to solve the query that you need to create, but how long will it take to find exactly what you are looking for? You may even find a video or two, that may help. How many minutes are these videos? And how much of the video do you have to watch, until it gets to the part that you need?

One of the best ways to learn many things in life, is to do it yourself, even if it takes a little longer. Creating queries is no different. Once you spend time learning something, it is much harder to forget what you learned. That is how this book works. You learn by creating the queries all by yourself. There is no time limit. You can take as long as you need.

The scenarios presented in this book, will give you practice in creating queries that solve real world business related questions.

In today's work environment, being able to create queries that can be used to analyze the data, will give you an edge over other people. SQL isn't just for the IT department anymore. After completing the practice queries in this book, you will be able to create queries that answer questions like the ones listed below.

• What are the yearly sales by region?


• What are the top 10 selling products, based on the quantity sold?


• How many customers in California placed orders in 2018?






Like all of the books that I have written, my SQL series of books are based on the Windows version of the software.





This is not a beginners book. Topics like functions and syntax are not covered. If you have not created queries before and want to learn how to create queries, any of the following books will get you started. Select the book based on the database that you will use.









• Creating SQL Queries Using SQL Server (T-SQL), see ISBN 978-1-935208-44-0


• Creating SQL Queries Using MySQL, see ISBN 978-1-935208-45-7


• Creating SQL Queries Using an SQLite database, see ISBN 978-1-935208-46-4


• Creating SQL Queries Using PostgreSQL, see ISBN 978-1-935208-47-1


• Creating SQL Queries Using Oracle SQL, see ISBN 978-1-935208-48-8

Edition details

• Publisher: Tolana Publishing
• Publication date: 2020
• ISBN 10: 1935208497
• ISBN 13: 9781935208495
• Binding: Paperback
• Language: English
• Number of pages: 254