Course Duration | Fees | Mode of Study | Course Level | Institute Type |
---|---|---|---|---|
3 Years | Varies | Full-time | Undergraduate | College |
Semester/Year | Course Code | Course Title | Credits | Topics Covered |
---|---|---|---|---|
1st Semester | DB101 | Introduction to Database Systems | 4 | Database Fundamentals, ER Models, SQL Basics |
2nd Semester | DB102 | Advanced SQL | 4 | Complex Queries, Stored Procedures, Triggers |
Module | Topics |
---|---|
Introduction to Database Systems | Database System Concepts, Database System Architectures, Data Models |
Relational Model | Relational Database Design, Entity-Relationship Model, Normalization |
SQL and Data Manipulation | SQL Basics, Advanced SQL, Stored Procedures, Triggers |
Data Storage and Indexing | Storage Strategies, Indexing Techniques, Hashing |
Transaction Management | ACID Properties, Concurrency Control, Recovery Techniques |
Database Security | Security and Authorization, Data Privacy, SQL Injection |
Emerging Trends | NoSQL Databases, Big Data Technologies, Data Warehousing and Data Mining |