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 SQLite source code is not subject to copyright restrictions.

This tutorial will show you how to program with SQLite and get you up and running quickly.

Who is suitable for reading this tutorial?

This tutorial helps beginners understand the basics and advanced concepts associated with the SQLite database engine.

What you need to know before reading this tutorial:

Before you start practicing with the various examples provided in this tutorial, you need to understand what a database is, especially the RDBMS, and what is a computer programming language.

Compile/Execute SQLite Programs

If you want to compile/execute SQL programs through SQLite DBMS, but you don't have the relevant settings, you can visit compileonline.com. Experience real-world programming experience on high-end servers with a simple click. This is a completely free online tool.

SQLite Function Reference Manual

This tutorial provides a reference manual for all the important built-in SQLite functions.