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, specially 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.
2 - SQLite Useful Resources
A collection of SQLite Database Sites and Books is given at this page.
3 - SQLite Tutorial in PDF
Download a quick SQLite tutorial in PDF format.