Items related to Creating SQL Queries Using SQLite Made Easy (SQL Series)

Creating SQL Queries Using SQLite Made Easy (SQL Series) - Softcover

 
9781935208464: Creating SQL Queries Using SQLite Made Easy (SQL Series)

Synopsis

This book covers learning how to create SQL queries using an SQLite database.

If you have been looking for a book that has easy to understand step-by-step instructions and screen shots that show you how to create queries from data stored in a Windows SQLite database, this is the book for you. This book has been designed to have you creating queries quickly, by teaching you the basics and more. It is written from the perspective that you have not created queries using SQLite.



Most companies would find it helpful if they had employees, that could create queries to answer business needs. In my 25+ years of experience, I have noticed that few, if any people outside of the IT department have SQL skills. If that sounds like you, this book will teach you how to create SQL queries. This book is not just for people already in IT. While this book is designed for SQL beginners, it is also helpful for Data Analysts, Engineers and Scientists.



To help you become familiar with the syntax and features of SQL, this book contains over 390 illustrations that provide a visual tour of the results of the queries that you create. There are over 305 ready to use queries in the examples and exercises in this book, that you can use to create queries on your own.



This book will show you how to use some of the most used SQL keywords, operators and functions, by completing the hands on exercises. This book will get you up and running quickly, by teaching the basics of creating queries and a little more, so that you can use SQLite to create the queries that you need.



You will learn how to:





  • Create queries that use several operators and functions

  • Filter data, to retrieve just the data that you need

  • Sort and group data

  • Join tables so that data from more than one table can be retrieved at the same time

  • Create subqueries and more




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 exercises 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?





  • If you need to learn how to create SQL queries using T-SQL/SQL Server, see ISBN 978-1-935208-44-0.

    If you need to learn how to create SQL queries using MySQL, see ISBN 978-1-935208-45-7.

    If you need to learn how to create SQL queries using PostgreSQL, see ISBN 978-1-935208-47-1.

    If you need to learn how to create SQL queries using Oracle SQL, see ISBN 978-1-935208-48-8.




    If you already know some SQL, but want to get more practice, my Big Book Of SQL Queries (ISBN 978-1-935208-49-5), has over 250 practice queries that you can use to create queries in any of the following versions of SQL: T-SQL/SQL Server, MySQL, SQLite, PostgreSQL or Oracle.

"synopsis" may belong to another edition of this title.

  • PublisherTolana Publishing
  • Publication date2019
  • ISBN 10 1935208462
  • ISBN 13 9781935208464
  • BindingPaperback
  • LanguageEnglish
  • Number of pages254

Buy Used

Condition: Very Good
Gut/Very good: Buch bzw. Schutzumschlag...
View this item

US$ 10.26 shipping from Germany to U.S.A.

Destination, rates & speeds

Search results for Creating SQL Queries Using SQLite Made Easy (SQL Series)

Stock Image

Murphy, Indera E
Published by Tolana Publishing, 2019
ISBN 10: 1935208462 ISBN 13: 9781935208464
Used Softcover

Seller: medimops, Berlin, Germany

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: very good. Gut/Very good: Buch bzw. Schutzumschlag mit wenigen Gebrauchsspuren an Einband, Schutzumschlag oder Seiten. / Describes a book or dust jacket that does show some signs of wear on either the binding, dust jacket or pages. Seller Inventory # M01935208462-V

Contact seller

Buy Used

US$ 5.88
Convert currency
Shipping: US$ 10.26
From Germany to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Murphy, Indera E
Published by Tolana Publishing, 2019
ISBN 10: 1935208462 ISBN 13: 9781935208464
New Paperback

Seller: Toscana Books, AUSTIN, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: new. Excellent Condition.Excels in customer satisfaction, prompt replies, and quality checks. Seller Inventory # Scanned1935208462

Contact seller

Buy New

US$ 30.38
Convert currency
Shipping: US$ 4.30
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Murphy, Indera E
Published by Tolana Publishing, 2019
ISBN 10: 1935208462 ISBN 13: 9781935208464
New Paperback

Seller: Revaluation Books, Exeter, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Brand New. 254 pages. 11.00x8.50x0.58 inches. In Stock. Seller Inventory # zk1935208462

Contact seller

Buy New

US$ 62.35
Convert currency
Shipping: US$ 13.53
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket