Learn SQLite For Absolute Beginners - Crash Course

Create a permanent SQLite database in a chosen folder, define a stores table with store_id, item_id, and item_name, and use dot tables to verify and list the table.

Discover the five major SQLite data types—null, integer, real, text, and blob—and how each stores undefined values, numbers, text, and images.

Create a table and insert records using sqlite's insert into table name values syntax, optionally specifying fields, and understand success or error messages for each insertion.

Learn to use select star from stores to view all fields, confirm two records, and identify the default delimiter.

Save tables and databases with dot save, view them in SQL, quit with dot quit, and customize terminal colors and font.

Open a sqlite3 session, use dot open to load your db file, and prefix with sqlite3 to enter; then force exit with control C when the database is locked.

Filter records in SQLite by using select star from store where store id = 1, dot header on, and combine conditions with and or, noting semicolon rules.

Learn how and or operators function in practice by inserting and selecting records in a store table, with examples like book and notebook.

Master grouping in SQL by using the group by clause to count records per invoice id, with practical examples on creating an invoice table and aggregating results.

Sort records using the order by clause to arrange results by invoice amount in ascending or descending order.

Explore how to use between and in operators in SQLite to filter invoice amount between 1700 and 6500, selecting specific fields like invoice ID and handling syntax with parentheses.

learn how to update records in SQLite by using the update command, set clause, and optional where clause to target specific rows like invoice id 10 and amount 100.

Learn to view database structure in SQLite using the .schema command to inspect the full schema or the schema of a single table like invoice.

Examine date functions in SQLite, using select date to display GMT, select time, and select date time to combine date and time, plus Julian Day formats.

Learn how primary key constraints enforce unique, non-null values in a table by creating a student table with id as the primary key and observing duplicate id errors.

Show how the not null constraint prevents null values in a column, using a student table with a not null name; distinguish between no value and null.

Learn how the unique constraint enforces unique values in a table and differs from the primary key, which may be a single column or a group, possibly with not null.

Learn how default constraints assign automatic values in SQLite by creating tables with default values and inserting rows without explicit values, such as default 'unknown'.

Learn how to create a table with an amount field and enforce a check constraint that the amount must be greater than 900, then insert records and observe constraint enforcement.

Explore SQLite alter table structure to add fields, rename columns and tables, and insert and query data to observe schema and record changes.

Learn how to drop a table permanently with drop table, delete specific records with delete from, and distinguish drop from delete to prevent data loss.

Learn to back up a specific SQLite database with the dot backup command, name the backup, and restore it later with dot restore, then verify tables after restoration.

Explore different output modes in the SQLite command-line interface, including csv, tab, column, and insert, and see how the default list mode formats query results.

Explicitly save your sqlite database with dot save, naming the database to confirm the save. Explore beaver.io, sqlite browser, or editor options like Visual Studio Code for working with sqlite.