Introduction to SQLite: Part-1 : Basics - Softcover

Das, Jeet

Softcover

ISBN 13: 9798538734788

Publisher: Independently published, 2021

Synopsis

SQLite is an embedded SQL database engine,The advantages of it -
(i) SQLite does not have a separate server process like most other SQL databases.
(ii) SQLite reads and writes directly to ordinary disk files.
(iii) Written in ANSI-C.
(iv) no setup or administration needed,means Zero-configuration
(v) A complete database is stored in a single cross-platform disk file.
(vi) Simple, easy to use API.
(vii) Comes with a standalone command-line interface (CLI).

Who uses SQLite?
It is used in everywhere,like Google,Dropbox,Mozilla,McAfee, Flame, Microsoft, Skype, Adobe,Airbus,Apple,PHP,Python etc.

===================
Contents :

Section-A : Introduction

[A-1] About SQLite
[A-2] Features
[A-3] Distinctive Features Of SQLite
(NB-which make SQLite different from many other SQL database engines)
[A-4] Tools

Section-B: Download & Installation

[B] Download & Installation

Section-C : Core Part

[C-1] Data Types :
-[C-1-1] Datatypes in SQLite
-[C-1-2] Storage Classes and Datatypes
-[C-1-3] Boolean Datatype
-[C-1-4] Data & Time Datatype

[C-2] Operators :
-[C-2-1] Arithmetic operators
-[C-2-2] Comparison operators
-[C-2-3] Logical operators
-[C-2-4] Bitwise operators

[C-3] Use of .help

[C-4] Constraints :
-[C-4-1] NOT NULL Constraint
-[C-4-1] DEFAULT Constraint
-[C-4-1] UNIQUE Constraint
-[C-4-1] PRIMARY Key : Create & Removing
-[C-4-1] CHECK Constraint

[C-5] Database Operations:
-[C-5-1] CREATE Database
-[C-5-2] ATTACH Database
-[C-5-3] DETACH Database

[C-6] SQL Commands :
-[C-6-1] DDL
-[C-6-2] DQL
-[C-6-3] DML
-[C-6-4] DCL
-[C-6-5] TCL

[C-7] Clauses :
-[C-7-1] WHERE
-[C-7-2] LIKE
-[C-7-3] GLOB
-[C-7-4] LIMIT
-[C-7-5] ORDER BY
-[C-7-6] GROUP BY
-[C-7-7] HAVING
-[C-7-8] UNIONS
-[C-7-9] INDEXED BY

[C-8] Other :
-[C-8-1] DISTINCT
-[C-8-2] EXPLAIN & EXPLAIN QUERY PLAN
-[C-8-3] AUTOINCREMENT
-[C-8-4] COUNT(), MAX(), MIN(), SUM(), AVG()

[C-9] Views :
-[C-9-1] Creating Views
-[C-9-2] Dropping Views

[C-10] subqueries

[C-11] Joins :
-[C-11-1] INNER JOIN
-[C-11-1] LEFT(OUTER) JOIN
-[C-11-2] RIGHT(OUTER) JOIN
-[C-11-3] FULL (OUTER) JOIN

Edition details

• Publisher: Independently published
• Publication date: 2021
• Language: English
• ISBN 13: 9798538734788
• Binding: Paperback
• Number of pages: 72