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
On this page of the site you can watch the video online SQL CRUD with SQLite with a duration of hours minute second in good quality, which was uploaded by the user Foo Barstein 05 October 2021, share the link with friends and acquaintances, this video has already been watched 549 times on youtube and it was liked by 6 viewers. Enjoy your viewing!
