Learn SQLite in 24 Hours

Learn SQLite in 24 Hours

by Alex Nordeen
Publication Date: 23/11/2020

Share This eBook:

  $17.05

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:


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

ISBN:
1230004365143
1230004365143
Category:
Database programming
Publication Date:
23-11-2020
Language:
English
Publisher:
Guru99

This item is delivered digitally

Reviews

Be the first to review Learn SQLite in 24 Hours.