SQLite - Tutorial

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, transactional SQL database engine. SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. These features make SQLite a popular choice as an Application File Format.

About Tutorial

This tutorial provides basic and advanced concepts of SQLite. It is designed for beginners and professionals as well. Every topic is explained with examples which make you learn SQLite in a very easy way. In this tutorial, you will learn how to create new database, perform various operations on database like insert new records, update records, delete records and view records etc.

We believe in learning by examples therefore each and every topic is explained with lots of examples that makes you learn SQLite in a very easy way. Along with this, almost all examples can be executed online which provides better understanding of the language and helps you to learn the language faster. The classical "SELECT * statement" example is mentioned below for the illustration purpose:

Consider a database table called Employee with the following records:

To fetch all fields of the Employee table, the query will be:

SELECT * FROM Employee;

This result of the following code will be:

Prerequisite

There is no prerequisite for this tutorial however a basic understanding of database would be an added advantage.