Learn SQLite Archives

Listed here is my series to learn SQLite. These lessons are perfectly suited for anyone that desires to learn how to query a database.

We start with the basics, using SQLite, and focus on the command that are used retrieve the data. Once you learn the commands, you can practically use any web or GUI tool to create complex queries.

You’ll never feel limited by what you can do, nor frustrated that you’re restricted to a few canned report to rely upon.

You don’t have to be a computer wiz to follow along. I try to use plain English to explain the concepts.  You’ll learn SQLite by doing!

Though the courses can help the tech minded, such as developers, I really wrote them for the average computer user.

It is my hope all you HR, Business Analysts, Engineers, and Accountants will find my site, learn SQL, and make your jobs and lives easier.


SQL Join – Introduction to SQL Join Syntax and Concepts

SQL Joins are important to master. As you progress from a beginner to advance beginner, you’ll soon need to combine data from more than one table. To do this, you’ll use database joins.  In this series of articles I’ll show you how to write a query that combines, or joins, data from more than one […]

Continue reading

How to Group and Summarize your Results (simple explanation)

Group and Summarize Data

In today’s lesson you’re going to learn about grouping results returned from your queries using the GROUP BY clause. The objectives of today’s lesson are to: Learn to how to group results using GROUP BY Use aggregate functions to perform calculations Understand how to filter groups using the HAVING clause GROUP BY Clause The SQL […]

Continue reading

Query Results Using Boolean Logic

Old Fashioned Computer

In today’s lesson you’re going to learn how to query results using the WHERE clause. The objectives of today’s lesson are to: Learn to use more than one compare condition at a time using Boolean logic Comprehensive example with Select, Where, and Order By Using Multiple Conditions to Query Results In previous lesson’s we learned how the […]

Continue reading