Introduction to SQL and SQLite3 -- SQL Scripts, Database Backups, and Grouping/Ordering Data (Vid 3)
Автор: Studious Tok
Загружено: 2025-07-06
Просмотров: 13
In video 3 for our introduction to the SQL language and using SQLite3 we will start to really get at what makes SQL so useful and powerful, including making much longer and more specific queries.
We will discuss the items below in this video:
Creating backups via sql files, deleting databases/tables, restoring databases/tables
Attaching/detaching databases for copying/pasting
Aliases
Deleting columns
GROUP BY
ORDER BY
LIMIT
HAVING
In the previous videos we covered:
Installation and database creation
SQL data types (INTEGER, REAL, TEXT, NULL, BLOB)
Creating tables
Adding rows/data
Viewing columns from a table
Adding additional columns
Editing data within existing rows
Conditional specification
Importing or appending external csv data to a table
Deleting rows
In later videos we will cover:
Detecting and Dealing with NULL data
Constraints
Relating tables and rows together
JOIN and ON
PRIMARY KEY and FOREIGN KEY
REFERENCES
User Accounts
Cryptography
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
