A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.A DBMS makes it possible for end users to create, read, update and delete data in a database. The DBMS essentially serves as an interface between the database and end users or application programs, ensuring that data is consistently organized and remains easily accessible.
| No | Topic | Link |
|---|---|---|
| 1 | Intro to Database Management System | Intro to DBMS |
| 2 | Relational and Relational Algebra | Relations and Relational Algebra |
| 3 | ERD (Entity Relationship Diagram) | ER Modelling |
| 4 | Normalization to 3NF | Normalisation to 3NF |
| 5 | BCNF Normalization to 5NF | Normalisation to BCNF Contoh Normalisasi Lengkap |
| 6 | SQL Definition | SQL Data Definition |
| 7 | More SQL Definition | More SQL Data Definition |
| 8 | SQL Select | SQL Select |
| 9 | More SQL Select | More SQL Select |
| 10 | Yet More SQL Select | Yet More SQL Select |
| 11 | Missing Information | Missing Information |
| 12 | SQL View | SQL View |
| 13 | Trigger + Store Procedure | Store Procedure |
| 14 | Review and Case Studies | |
| 15 | Assignment | |
| 17 | Latihan MySQL | Latihan Praktikum SBD MySQL |