– What is a Database?
– Types of Databases: Relational vs Non-Relational
– DBMS vs RDBMS
– Overview of Popular RDBMS: Oracle, SQL Server, MySQL, PostgreSQL

– Entities, Attributes, and Relationships
– ER Diagrams
– Normalization and Denormalization
– Primary, Foreign Keys, Constraints
– Schema vs Instance

– Basic SQL: SELECT, INSERT, UPDATE, DELETE
– JOINs, Subqueries, Views
– Indexes and Performance Considerations
– Stored Procedures and Functions
– Transactions and Concurrency Control

– Design a relational database schema for a library.
– Create tables for Books, Members, Staff, Issued Books, Fines, etc.
– Write SQL queries for issuing a book, returning a book, checking overdue fines, searching books by author/title.
– Implement constraints, primary & foreign keys.
– Use Views, Joins, and Transactions.
– Goal: Apply database design + SQL essentials in a small real-life project.

– Installation of MySQL / PostgreSQL / SQL Server / Oracle (pick one or more)
– Configuring Database Services
– Creating and Managing Databases and Tablespaces
– Understanding Configuration Files

– Creating Users and Roles
– Managing Privileges and Permissions
– Role-Based Access Control (RBAC)
– Database Auditing and Logging
– Encryption (at-rest and in-transit)

– Backup Types: Full, Incremental, Differential
– Recovery Models (Simple, Full, Bulk-Logged)
– Automated Backup Scripts
– Restore and Point-in-Time Recovery
– Disaster Recovery Strategies

– Monitoring Tools and Logs
– Query Optimization Techniques
– Index Tuning and Execution Plans
– Locking and Deadlocks
– Resource Management (CPU, RAM, Disk I/O)

– Database Clustering Concepts
– Failover and Load Balancing
– Replication Types: Master-Slave, Multi-Master
– AlwaysOn Availability Groups (SQL Server)
– Oracle Data Guard / MySQL Replication

– Automating Tasks with Bash / PowerShell
– SQL Scripts for Maintenance Jobs
– Cron Jobs / Task Scheduler
– Monitoring Alerts and Notifications

– Introduction to Cloud Platforms: AWS, Azure, GCP
– RDS (Amazon), Cloud SQL (Google), Azure SQL
– Backups and Snapshots in Cloud
– Security and IAM in Cloud
– Cost Management and Scaling

– Design & implement a full-fledged e-commerce database (Users, Products, Orders, Payments, Inventory, Shipping).
– Configure and install on MySQL/PostgreSQL/SQL Server.
– Implement user roles & permissions (admin, seller, customer).
– Set up backup & recovery scripts with automated scheduling.
– Apply query optimization and create indexes for performance.
– Enable replication or clustering for high availability.
– Deploy database to Cloud (AWS RDS / Azure SQL / GCP Cloud SQL).
– Implement monitoring dashboards & alerts.
– Goal: Simulate the real-world responsibilities of a DBA (design, performance tuning, security, backup, cloud deployment).