SQLite Training Course

SQLite Training Course

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.

What we will learn ?

Installation, Commands, Syntax, Data Type, CREATE Database, ATTACH Database, DETACH Database, CREATE Table, DROP Table, INSERT Query, SELECT Query, Operators, Expressions, WHERE Clause, AND & OR Clauses, UPDATE Query, DELETE Query, LIKE Clause, GLOB Clause, LIMIT Clause, ORDER By Clause, GROUP By Clause, HAVING Clause, DISTINCT Keyword