SQLite Tutorial

SQLite is a lightweight, serverless and self-contained SQL database engine used to store, manage and retrieve data efficiently. It requires no separate server installation and stores the entire database in a single file.

• Serverless and zero-configuration database system.
• Stores the complete database in a single file.
• Supports SQL for data management and querying.
• Lightweight, portable and easy to use.
• Widely used in mobile, desktop and embedded applications.

Basic

Learn the fundamental concepts of SQLite, including installation, data types and the basic statements and syntax required to work with SQLite databases.

• Introduction
• Installation
• Data Types
• Statements & Syntax

Querying Data

Learn how to retrieve, filter, sort and organize data from SQLite tables using commonly used query statements and clauses.

• SELECT
• WHERE Clause
• ORDER BY
• GROUP BY
• GLOB 

Constraints

Constraints are used to restrict the type of data that can be inserted into a table, helping maintain data integrity and relationships.

• PRIMARY KEY
• FOREIGN KEY
• UNIQUE
• NOT NULL
• CHECK
• AUTOINCREMENT

Table Operations

Table Operations cover the fundamental commands used to create tables and manage the data stored within them

• CREATE
• INSERT
• SELECT
• UPDATE
• AlTER
• DELETE

Operators

Learn how SQLite operators are used to filter data, test conditions, compare values and search for matching records within database tables.

• LIKE
• IN
• BETWEEN
• EXISTS
• UNION ALL
• EXCEPT
• INTERSECT

Functions

Functions include Aggregate Functions, String Functions, Date and Time Functions and Numeric Functions for data processing and analysis.

• COUNT
• SUM
• AVG
• MIN
• MAX
• String Functions
• Date and Time
• Numeric Functions

JOIN & Views

Learn how joins combine related data from multiple tables and how views provide a virtual table for simplifying complex queries.

• JOIN
• Full Outer Join
• Explicit & Implicit Join
• Create View
• Drop View

Indexes

Understand how SQLite indexes optimize database performance and make data access more efficient.

• Introduction
• Expression-Based Index

Utilities & Database Management

Learn how to inspect database structures, transfer data using import/export utilities, create database backups and maintain optimal SQLite performance

• Describe Table
• Dump
• Import CSV
• Export CSV
• VACUUM

Miscellaneous Topics

Learn about advanced SQLite features used for automation, transaction management, database maintenance and efficient text searching

• Triggers
• Transactions
• Vaccum 
• Support Stored Procedure
• FTS (Full-Text Search)

SQLite Interfaces

SQLite Interfaces include Python, Flutter and C/C++ for connecting applications with SQLite databases across different platforms and development environments.

• Python
• Flutter
• C/C++

Python SQLite

Learn how Python and SQLite work together to store, retrieve, update and manage data in applications.

• Connection to Database
• Datatypes
• Cursor Object
• CRUD Operation
• Working with Tables

Interview Questions

Interview Questions include frequently asked SQLite interview questions for exam and job interview preparation

• SQLite Interview Questions

Related Articles

• SQL Tutorial
• Python SQLite Tutorial