Introduction to SQLite3

SQLite3 is used in the Rails project to create the application's database. Its code is public domain, and is available for use privately and commercially. Our courses don't cover a lot of what you can do with SQLite, but there are a lot of great resources that go over the queries and reports you can create.

In general, the principles of database software are very similar between tools (MSQL vs SQLite vs Oracle Database etc.), and the commands needed to interact with a database will be similar across each one. This means that while there aren't many SQLite3-specific tutorials out there, there are other resources you can use.

If you are looking for a program that will let you visually navigate through a database (kind of like how you would do in your computer's file system), I highly recommend Navicat. There are free and paid versions, and you can navigate through your database manually, or use SQL syntax to get the records you need.

Essential SQL - Kris Wenzel

This is a thorough tutorial on the database operations you can do on SQLite3, that assumes you do not have any background knowledge.

 Essential SQL

Learn SQL the Hard Way - Zed A. Shaw

Part of a great series on how to learn programming without a programming background. The tutorial is still in Alpha, and is only about half finished (15 lessons available out of ~30). Highly recommended, very honest about software limitations and the importance of various attributes.

Learn SQL the Hard Way

Official SQLite3 Documentation -

Thorough, but not very user-friendly.

Official SQLite3 Documentation

Basic MySQL Commands - The West Chester University Computer Science Department

Looks complicated, but this is a great reference guide to all MYSQL commands. Some of the more advanced ones may not work in SQLite3, but the vast majority will work fine.

Basic MySQL Commands

Exploits of a Mom - Randall Munroe, XKCD

A little database humor before you go :)

SQLite Comic Strip

Powered by Zendesk