Week 12: MySQL & SQL
MySQL | CRUD, JOINs, GROUP BY, Database Design
Al-Aqsa University
MySQL & SQL
Relational databases, tables, CRUD operations, JOINs, aggregates, and indexes
Week 12
Databases
MySQL
Data Types
CREATE TABLE
Constraints
ALTER TABLE
INSERT
SELECT
WHERE
UPDATE
DELETE
ORDER BY
LIMIT
Aggregates
GROUP BY
Foreign Keys
JOINs
Subqueries
Indexes
1. What is a Relational Database? Tables, Rows, Columns
Relational Database Concepts
A relational database stores data in structured tables (also called relations). Think of it like a spreadsheet:
- Table: A collection of related data (like a spreadsheet sheet)
- Row (Record): A single entry in the table (like a spreadsheet row)
- Column (Field): A specific attribute of the data (like a spreadsheet column)
- Primary Key: A unique identifier for each row (usually an auto-incrementing ID)
- Foreign Key: A column that references a primary key in another table (creates relationships)
students TABLE
+----+----------+-----+------------------+------+
| id | name | age | email | gpa |
+----+----------+-----+------------------+------+
| 1 | Ahmad | 21 | ahmad@mail.com | 3.85 |