“SQLite is a very lightweight database, with no installation required, zero configuration, and no server required. SQLite is widely used as a database of choice in mobile apps, camera, home electronic devices and other embedded systems.
This book is designed for beginners with little or no prior database experience.
Table Of Content
Here is what you will learn:
Chapter 1: Introduction
Chapter 2: Create Database
CREATE Database
CREATE Database in a Specific Location
Create database and populate it with tables from a file
Backup & Database
Drop Database
Chapter 3: Create, Alter, Drop Table
Create table
Drop table
Alter table
Add columns- Using ALTER TABLE Command
Insert value into a table
Chapter 4: Primary & Foreign Key
SQLite constraint
Primary Key
Not null constraint
DEFAULT Constraint
UNIQUE constraint
What is a SQLite Foreign KEY?
Chapter 5: Data Types
Storage Classes
Affinity Type
Examples of storing data types in SQLite
Chapter 6: Select, Where, Limit, Count, Group By, Union
Reading data with select
WHERE
Limiting and Ordering
Group BY
Query & Subquery
Set Operations -UNION,Intersect
Conditional results
Advanced queries
Chapter 7: Joins
Introduction to SQLite JOIN Clause
INNER JOIN
JOIN … USING
NATURAL JOIN
LEFT OUTER JOIN
CROSS JOIN
Chapter 8: INSERT, UPDATE, DELETE
INSERT
Update
Delete
Conflict clause
Chapter 9: Index, Trigger & View
View
Index
Trigger
Chapter 10: SQLite Functions
Finding the LENGTH of a string
UPPER Function and LOWER Function
TRIM Function
TYPEOF Function
SQLite LAST_INSERT_ROWID
SQLite library
User-defined functions
Details e-Book Learn SQLite in 24 Hours
🗸 Author(s): Alex Nordeen
🗸 Title: Learn SQLite in 24 Hours
🗸 Rating : from 5 stars ( reviews)
🗸 Format ebook: PDF, EPUB, Kindle, Audio, HTML and MOBI
🗸 Supported Devices: Android, iOS, MacOS, PC and Amazon Kindle
✓ Read as many eBooks you want!
✓ Secure Scanned. No Virus Detected
✓ Thousands of eBooks to choose from - Hottest new releases
✓ Click it and Read it! - no waiting to read eBooks, it's instant!
✓ Keep reading your favorite eBooks over and over!
✓ It works anywhere in the world!
✓ No late fees or fixed contracts - cancel anytime!
I couldn't stop raving about this book to my friends and family. It's a literary gem that deserves all the praise. I can't wait to dive into more works by this talented author.
The author's ability to evoke a wide range of emotions through their words is truly remarkable. I felt like I was on an emotional rollercoaster throughout the entire book.
This is a book I'll cherish and recommend to everyone. It touched my soul and made me reflect on life's profound mysteries.