Home > Databases and data storages > SQL
Module: Databases and data storages
Topic: SQL
- Lesson: Introduction to SQL , Uses of tables , CRUD operations
- Assessment: Assessment 1
Lesson 1
Introduction to SQL , Uses of tables , CRUD operations
- Self Learning Duration
- 240 mins
- Lecture Duration
- 240 mins
- Lab Tutorial Duration
- 180 mins
Self learning content
https://www.youtube.com/watch?v=7S_tz1z_5bA
Lecture content
- Based on the ER diagram, create the table structure.
- Introduction to SQL and SQL syntaxes
- Insert, delete, read and update data using SQL queries
Lab and tutorials
- Create a shopping cart database system using MySQL, MariaDB or PostgreSQL
- Create a simple program that connects to a database and tryout CURD operations
Assessment 1
Create a Database for shopping cart system using SQL statements.