SQL CRUD with SQLite
A quite deep introduction to SQL CRUD operations, including how to import data, create tables, insert records, update records, delete records, as well as grouping and performing simple statistical and conceptual analyses of the data.
-- Contents --
00:00 - Overview
03:42 - Setup
07:02 - CRUD
08:32 - CRUD: Create a Table
14:29 - CRUD: Create Rows Manually
17:54 - CRUD: Create Rows By Importing a File
30:34 - Filtering Rows With The Where Clause
33:10 - Returning Specific Fields/Columns
34:11 - Wildcards
35:52 - Ordering Results With Order By
39:53 - UNIX Timestamps
40:53 - CRUD: Update Records
44:09 - CRUD: Update a Table
44:26 - CRUD: Delete Records
45:39 - CRUD: Delete a Table
46:05 - Example Data Set: US School Districts
52:11 - Statistical Functions
54:17 - Grouping Records Together
59:52 - Combination Queries
