This repository provides a practical and beginner-friendly guide to working with SQL databases, focusing on relational database concepts and hands-on implementation using MySQL.
- The difference between relational and non-relational databases
- Core SQL concepts: tables, columns, records
- How to use DDL (Data Definition Language) and DML (Data Manipulation Language)
- Understanding and modeling relationships: one-to-one, one-to-many, and many-to-many
| Topic | Description |
|---|---|
| Introduction | Overview of databases and SQL fundamentals |
| MySQL Setup | Installing and configuring MySQL |
| Database Management | Creating, displaying, and deleting databases |
| Table Management | Creating, modifying, and deleting tables |
| Record Management | Inserting, updating, deleting, and querying data |
| Views | Creating and managing virtual tables |
| Procedures | Writing and executing stored procedures |
| Indexes | Improving query performance using indexes |
| Relationships | Modeling 1:1, 1:M, and M:M relationships |
Caution
This repository is a work in progress and is not the final content as some parts have not been reviewed yet.