Semester | Course Title | Topics Covered |
---|---|---|
Semester 1 | Introduction to Database Systems | Database Concepts, Data Models, Introduction to SQL |
Semester 2 | Relational Database Management Systems (RDBMS) | Normalization, SQL Advanced, PL/SQL Basics |
Semester 3 | Database Design and Implementation | ER Modeling, Advanced SQL, Database Design |
Semester 4 | Data Warehousing and Data Mining | Data Warehousing Concepts, Introduction to Data Mining, OLAP |
Semester 5 | NoSQL Databases | Introduction to NoSQL, MongoDB, Cassandra |
Semester 6 | Database Administration and Security | Database Security, Backup and Recovery, Performance Tuning |
Important Topics in BCA Database Management |
---|
Introduction to Database Systems |
Database Design and ER Models |
SQL and PL/SQL Basics |
Normalization and Database Schemas |
Transaction Management and Concurrency Control |
Indexing and Hashing |
Distributed Databases |
NoSQL Databases and Big Data |
Data Warehousing and Data Mining |
Database Security and Authorization |