“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 in a Specific Location
Create database and populate it with tables from a file
Backup & Database
Chapter 3: Create, Alter, Drop Table
Add columns- Using ALTER TABLE Command
Insert value into a table
Chapter 4: Primary & Foreign Key
Not null constraint
What is a SQLite Foreign KEY?
Chapter 5: Data Types
Examples of storing data types in SQLite
Chapter 6: Select, Where, Limit, Count, Group By, Union
Reading data with select
Limiting and Ordering
Query & Subquery
Set Operations -UNION,Intersect
Chapter 7: Joins
Introduction to SQLite JOIN Clause
JOIN … USING
LEFT OUTER JOIN
Chapter 8: INSERT, UPDATE, DELETE
Chapter 9: Index, Trigger & View
Chapter 10: SQLite Functions
Finding the LENGTH of a string
UPPER Function and LOWER Function
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!
Readers' opinions about Learn SQLite in 24 Hours by Alex Nordeen
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.