Rate this book
What to read after Learn SQLite in 24 Hours?
Hello there! I go by the name Robo Ratel, your very own AI librarian, and I'm excited to assist you in discovering your next fantastic read after "Learn SQLite in 24 Hours" by Alex Nordeen! 😉 Simply click on the button below, and witness what I have discovered for you.
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.
Here is what you will learn:
Table Of Content
Chapter 1: Introduction
Chapter 2: Create Database
1. CREATE Database
2. CREATE Database in a Specific Location
3. Create database and populate it with tables from a file
4. Backup & Database
5. Drop Database
Chapter 3: Create, Alter, Drop Table
1. Create table
2. Drop table
3. Alter table
4. Add columns- Using ALTER TABLE Command
5. Insert value into a table
Chapter 4: Primary & Foreign Key
1. SQLite constraint
2. Primary Key
3. Not null constraint
4. DEFAULT Constraint
5. UNIQUE constraint
6. What is a SQLite Foreign KEY?
Chapter 5: Data Types
1. Storage Classes
2. Affinity Type
3. Examples of storing data types in SQLite
Chapter 6: Select, Where, Limit, Count, Group By, Union
1. Reading data with select
2. WHERE
3. Limiting and Ordering
4. Group BY
5. Query & Subquery
6. Set Operations -UNION,Intersect
7. Conditional results
8. Advanced queries
Chapter 7: Joins
1. Introduction to SQLite JOIN Clause
2. INNER JOIN
3. JOIN … USING
4. NATURAL JOIN
5. LEFT OUTER JOIN
6. CROSS JOIN
Chapter 8: INSERT, UPDATE, DELETE
1. INSERT
2. Update
3. Delete
4. Conflict clause
Chapter 9: Index, Trigger & View
1. View
2. Index
3. Trigger
Chapter 10: SQLite Functions
1. Finding the LENGTH of a string
2. UPPER Function and LOWER Function
3. TRIM Function
4. TYPEOF Function
5. SQLite LAST_INSERT_ROWID
6. SQLite library
7. User-defined functions
Are you curious to discover the likelihood of your enjoyment of "Learn SQLite in 24 Hours" by Alex Nordeen? Allow me to assist you! However, to better understand your reading preferences, it would greatly help if you could rate at least two books.