Day 1: Fundamentals & Table Operations
- 1:Introduction
- 2:Database: create, alter, drop
- 3:Table: Create, Insert, Select, Update, Delete, Drop
- 3:Key Constraints: Primary, Foreign, Unique, Default, Check, Cascading refrential Integrity
Read Day 1 Content
Day 1: Practice
- Task 1: Create DB
Library_record, toggle Single/Multi-user mode.
- Task 2: Create
Student_record & Book_record tables with PK, FK, Unique, Check, and Default constraints.
- Task 3: Alter tables (add/drop columns) and test cascading referential integrity.
View Full Exercise