Fundamental Concepts
- Introduction to Databases.
- Database System Architecture.
- Data Abstraction.
- Data Models.
- Entity-Relationship (ER) Model
- Relational Model
- Relational Model & Keys
Core SQL Commands
- Data Definition Language (DDL).
- Data Manipulation Language (DML).
- Data Control Language (DCL).
- Transaction Control Language (TCL).
- Advanced SQL.
- Functions , Joins.
Database Design and Theory
- Normalization.
- Functional Dependencies.
- Anomalies.
- Normal Forms.
- Higher Normal Forms.
- Decomposition.
- Denormalization.
- Dimensional Modeling.
- Star Schema and Snowflake Schema.
Internal Mechanics and Optimization
- Relational DBMS.
- NoSQL Databases.
- Document.
- Collections.
- NoSQL Queries.
- GUI.
- Command Line.