SQLite Tutorial

SQLite Tutorial

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

This tutorial will give you quick start with SQLite and make you comfortable with SQLite programming.


This reference has been prepared for the beginners to help them understand the basic to advanced concepts related to SQLite Database Engine.


Before you start doing practice with various types of examples given in this reference, I'm making an assumption that you are already aware about what is database, especially RDBMS and what is a computer programming language.

Compile/Execute SQLite Programs

If you are willing to compile and execute SQL programs with SQLite DBMS but you do not have a setup for the same, then do not worry. The compileonline.com is available on a high end dedciated server giving you real programming experience with a comfort of single click execution. Yes! it is absolutely free and its online.

1 - SQLite Functions Reference

At Tutorials Point you will find references on all important built-in SQLite functions.

SQLite Useful Functions

2 - SQLite Useful Resources

A collection of SQLite Database Sites and Books is given at this page.

SQLite Useful Resources

3 - SQLite Tutorial in PDF

Download a quick SQLite tutorial in PDF format.

SQLite Tutorial in PDF