IGCSE Computer Science 2023-25 - Topic 9 DATABASES - Part 1

Опубликовано: 10 Ноябрь 2022
на канале: Steam Labs

995

Subscribe to Steam Labs |
Facebook |

In this video, you are going to learn how to set up an SQL database on Kali Linux as part of the IGCSE Computer Science syllabus for Topic 9 databases. You will learn how to use sql databases using terminal then create databases, tables, set field validation rules then add data into your table + learn how to update records and remove records.

Timecodes

00:00 ▶️ How to set up SQL database using Kali Linux
03:23 ▶️ Login to SQL database and create new database
06:54 ▶️ Create new table in SQL database and set up validation rules for fields
10:44 ▶️ How to check what validation rules have been set in SQL table
12:19 ▶️ How to install and use flameshot to evidence learning
13:57 ▶️ How to insert data into an SQL table
18:47 ▶️ How to update an existing table and add a new field
20:31 ▶️ How NOT to update an existing record in an SQL table
18:47 ▶️ How to update an record + delete a record from an SQL table