Learn SQLite - SQLite Tutorial

了解SQLite的簡單易學下線。

What is SQLite?

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.

SQLite Tutorial provides basic and advanced concepts of SQLite. Our SQLite Tutorial is designed for beginners and professionals both.

Prerequisite

Before learning SQLite, you must have the basic knowledge of Basic Database like SQL, MySQL etc.

The content of this SQLite tutorial are followings:

-- SQLite Introduction

-- Installation

-- Commands, Syntax

-- DataTypes, CreateDB

-- Detach Table, Create Table

-- Drop Table, Insert Query

-- Select Query, Operators

-- Expression, Where Clause

-- And OR Clause

-- Update, Delete Query

-- Like , Globe Clause

-- Limit Clause, OrderBy

Advanced Level Concepts:

-- SQLite PRAGMA, Constraints

-- Join, Union Clause

-- NULL Values, Alias Syntax

-- Triggers, Indexes

-- IndexedBy, Alter Command

-- Truncate Table, Views

-- Transactions, Sub Quries

-- Auto Increment

-- Injection

Most Important SQLite Interfaces:

-- SQLite C/C++

-- SQLite Java

-- SQLite PHP

-- SQLite Perl

-- SQLite Python

So download this app immediately and learn SQLite tutorial offline anywhere, anytime.