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.