๐ Lecture 1: Introduction to SQL and Relational Databases
๐ฏ Learning Outcomes
By the end of this lecture, you will be able to:
- Explain what SQL is and what it stands for.
- Define data, database, relational database, and RDBMS.
- Identify the five basic SQL commands.
๐ง Key Concepts
๐น What is SQL?
- SQL (Structured Query Language) is a language used to communicate with relational databases.
- Pronounced as โsequelโ.
- Used to query (retrieve), insert, update, and delete data.
๐น What is Data?
- Data = collection of facts โ words, numbers, or even images.
- Considered one of the most valuable assets for any organization.
- Example: A bank stores customer data like name, address, account number, etc.
- Data must be stored securely and accessed efficiently.
๐น What is a Database?
- A database is a repository (storage) of data.