SQLite tutorial

last modified July 6, 2020

This is SQLite tutorial. It covers the SQLite database engine, sqlite3 command line tool, and the SQL language covered by the database engine.

Table of Contents

• Introduction

• The sqlite3 command line tool

• Creating, altering, and dropping tables

• SQLite expressions

• Inserting, updating and deleting data

• The SELECT statement

• Constraints

• Joining tables

• SQLite functions

• Views, triggers, transactions

SQLite

SQLite is an embedded relational database engine. Its developers call it a self-contained, serverless, zero-configuration and transactional SQL database engine.

Related tutorials and e-books

SQLite Python ebook is an in-depth material on SQLite programming using Python language. MySQL tutorial covers the MySQL database system. SQLAlchemy tutorial covers SQLAlchemy SQL Toolkit and Object Relational Mapper. The following tutorials show how to connect to SQLite from various programming languages: SQLite C tutorial, SQLite Python tutorial, PHP SQLite3 tutorial, SQLite Ruby tutorial, SQLite C# tutorial and SQLite Visual Basic tutorial.