SQLite Tutorial

Learn SQLite

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 source code for SQLite is in the public domain. This tutorial will give you a quick start with SQLite and make you comfortable with SQLite programming.

Audience

This tutorial has been prepared for beginners to help them understand the basic-to-advanced concepts related to SQLite Database Engine.

Prerequisites

Before you start practicing various types of examples given in this reference, we assume that you are already aware about what is a database, especially RDBMS and what is a computer programming language.

SQLite Tutorial

SQLite - Home

SQLite - Overview

SQLite - Installation

SQLite - Commands

SQLite - Syntax

SQLite - Data Type

SQLite - CREATE Database

SQLite - ATTACH Database

SQLite - DETACH Database

SQLite - CREATE Table

SQLite - DROP Table

SQLite - INSERT Query

SQLite - SELECT Query

SQLite - Operators

SQLite - Expressions

SQLite - WHERE Clause

SQLite - AND & OR Clauses

SQLite - UPDATE Query

SQLite - DELETE Query

SQLite - LIKE Clause

SQLite - GLOB Clause

SQLite - LIMIT Clause

SQLite - ORDER By Clause

SQLite - GROUP By Clause

SQLite - HAVING Clause

SQLite - DISTINCT Keyword

Advanced SQLite

SQLite - PRAGMA

SQLite - Constraints

SQLite - JOINS

SQLite - UNIONS Clause

SQLite - NULL Values

SQLite - ALIAS Syntax

SQLite - Triggers

SQLite - Indexes

SQLite - INDEXED By Clause

SQLite - ALTER Command

SQLite - TRUNCATE Command

SQLite - Views

SQLite - Transactions

SQLite - Subqueries

SQLite - AUTOINCREMENT

SQLite - Injection

SQLite - EXPLAIN

SQLite - VACUUM

SQLite - Date & Time

SQLite - Useful Functions

SQLite Interfaces

SQLite - C/C++

SQLite - Java

SQLite - PHP

SQLite - Perl

SQLite - Python

SQLite Useful Resources

SQLite - Quick Guide

SQLite - Useful Resources

SQLite - Discussion