Creating SQL Queries Using SQLite Made Easy

Overview
If you have been looking for a book that has a lot of easy to understand step-by-step instructions and screen shots that show you how to create queries using SQLite, 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. This book is for the beginner. To help you become familiar with the options and features, this book contains over 390 illustrations that provide a visual tour of the results of the queries that you create. There are also over 305 ready to use queries in the examples and exercises.

This book will show you how to use some of the most used features of SQLite, by completing the tasks in each exercise. Topics are explained as you go along. You will cover enough of SQLite to know whether or not it will handle a large percent of your needs, without investing weeks of your time, trying to learn about a larger number of features and options. This book will get you up and running quickly, by teaching a little more than the basics, so that you can use SQLite effectively.

Table Of Contents

Chapter 1 - Getting Started With SQLite
Chapter 2 - Using SQLite Studio
Chapter 3 - Creating Single Table Queries
Chapter 4 - Filter Data
Chapter 5 - Creating Advanced Single Table Queries
Chapter 6 - Creating Queries That Use Multiple Tables
Chapter 7 - Using Outer Joins To Link Tables
Chapter 8 - Formatting Text And Numeric Data
Chapter 9 - Formatting And Using Date Fields
Chapter 10 - Using Aggregate Functions And Creating Summary Queries
Chapter 11 - Creating Subqueries
Chapter 12 - Creating And Using Views

SQLite Home Page | Errata |