In this session, trainees will be introduced to the core concepts of databases, including why we use them, how data is modeled, and how to interact with a relational database using SQL.
1.
Introduction to databases
Preparation
Assignment
Session Plan
Explain what a database is and why we use them
Understand basic relational data terminology: table, row, column, primary key, foreign key
Perform basic SQL operations: SELECT, INSERT, UPDATE, DELETE
Use simple filtering and sorting techniques
Understand simple database design & schemas
Last updated 4 months ago