About Learn SQLite - SQLite Tutorial
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.