DBMS course
Specially design for BCA/BBA/B.Tech/ BSc. computer (Any Undergraduates)
Duration: 6 months
Mode of learning: Both Online and Offline
Contact for course fee and other details
Flexible payment available: One time | EMi monthly basis
Embedded Files
Syllabus to be covered
Syllabus to be covered
1. Introduction to DBMS
1. Introduction to DBMS
Overview and Importance of Databases
File System vs. DBMS
Characteristics and Applications of DBMS
Database Users and Roles
DBMS Architecture:
1-Tier, 2-Tier, 3-Tier Architecture
Data Abstraction and Data Independence
2. Database Models
2. Database Models
Introduction to Data Models
Hierarchical Model
Network Model
Relational Model (Focus)
Object-Oriented Model
Entity-Relationship (ER) Model:
Entities, Attributes, Relationships
ER Diagrams and Notations
Extended ER Features (Generalization, Specialization)
3. Relational Database Concepts
3. Relational Database Concepts
Relational Model Concepts:
Tables, Tuples, Attributes, and Keys
Primary Key, Foreign Key, Candidate Key, and Super Key
Relational Algebra:
Selection, Projection, Union, Intersection, Difference, Join, and Division
Relational Calculus:
Tuple Relational Calculus
Domain Relational Calculus
4. Structured Query Language (SQL)
4. Structured Query Language (SQL)
Introduction to SQL
DDL (Data Definition Language): CREATE, ALTER, DROP
DML (Data Manipulation Language): INSERT, UPDATE, DELETE, SELECT
DCL (Data Control Language): GRANT, REVOKE
TCL (Transaction Control Language): COMMIT, ROLLBACK, SAVEPOINT
Advanced SQL:
Subqueries, Joins (Inner, Outer, Cross), Grouping
Aggregate Functions (SUM, AVG, COUNT)
Views, Indexes, and Sequences
5. Database Design
5. Database Design
Normalization:
Functional Dependencies
1NF, 2NF, 3NF, BCNF
Multivalued Dependencies and 4NF, 5NF
Decomposition and Dependency Preservation
Schema Design and ER-to-Relational Mapping
6. Transactions and Concurrency Control
6. Transactions and Concurrency Control
Transactions and ACID Properties
States of a Transaction
Concurrency Issues: Lost Updates, Dirty Reads, etc.
Concurrency Control Mechanisms:
Lock-Based Protocols
Time Stamp-Based Protocols
Deadlock Handling
7. Storage and Indexing
7. Storage and Indexing
Storage Architecture:
Primary, Secondary, and Tertiary Storage
Buffer Management
Indexing and Hashing:
Single-level and Multi-level Indexing
Clustered vs. Non-clustered Indexing
Hash-based Indexing and Tree-based Indexing (B-trees, B+ trees)
8. Query Processing and Optimization
8. Query Processing and Optimization
Steps in Query Processing
Query Parsing and Execution Plans
Cost-based Query Optimization
Heuristics in Query Optimization
9. NoSQL Databases (Introduction)
9. NoSQL Databases (Introduction)
Overview of NoSQL Databases
Differences Between SQL and NoSQL
Types of NoSQL Databases: Key-Value, Document, Columnar, and Graph Databases
Examples: MongoDB, Cassandra, Redis
10. Distributed Databases
10. Distributed Databases
Introduction to Distributed Database Systems
Data Fragmentation, Replication, and Allocation
Distributed Query Processing
Distributed Transactions and Concurrency Control
11. Database Security
11. Database Security
Database Security Issues
Access Control and Authorization
Encryption Techniques
SQL Injection Attacks and Prevention
12. Advanced Topics (Optional)
12. Advanced Topics (Optional)
Data Warehousing and OLAP:
Concepts of Data Warehousing
OLAP Operations (Roll-up, Drill-down, Slice, Dice, Pivot)
Big Data and Hadoop Ecosystem
Introduction to Cloud Databases (Amazon RDS, Google Cloud SQL)
Temporal and Spatial Databases
13. Practical and Project Work
13. Practical and Project Work
Hands-on with SQL on Relational Databases (MySQL, PostgreSQL, Oracle, etc.)
Building an ER Diagram and Translating to Schema
Mini-projects:
Library Management System
Inventory System
Online Booking or E-commerce Application
Page updated
Google Sites
Report abuse