Semester | Course Code | Course Title |
---|---|---|
Semester 1 | BCA101 | Introduction to Database Systems |
Semester 2 | BCA201 | Database Design and SQL |
Semester 3 | BCA301 | Advanced SQL |
Semester 4 | BCA401 | Database Administration |
Semester 5 | BCA501 | NoSQL Databases |
Semester 6 | BCA601 | Database Security and Optimization |
Semester | Important Topics |
---|---|
Semester 1 | Introduction to Databases, Database Design, and Data Models |
Semester 2 | SQL Basics, Data Manipulation Language (DML), and Data Definition Language (DDL) |
Semester 3 | Normalization, ER Diagrams, and Advanced SQL |
Semester 4 | Transaction Management, Concurrency Control, and Database Recovery Techniques |
Semester 5 | NoSQL Databases, Big Data Technologies, and Data Warehousing |
Semester 6 | Database Security, Distributed Databases, and Database Administration |