Data Base Management Systems offered by Online Cell- Centre for Distance Education
- Public/Government Institute
Data Base Management Systems at Online Cell- Centre for Distance Education Overview
Duration | 12 weeks |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Data Base Management Systems at Online Cell- Centre for Distance Education Highlights
- Earn a certification from Anna University
- Learn from expert faculty
Data Base Management Systems at Online Cell- Centre for Distance Education Course details
- Professionals are responsible for managing, maintaining, and securing the database systems
- Define key database concepts, including data models, schemas, and normalization
- Explain the importance of data integrity, consistency, and security in database management
- Design relational database schemas using entity-relationship modeling techniques
- Implement and manage tables, views, indexes, and constraints in RDBMS platforms
- This course aims at providing basic understanding of data, data bases, its storage using database structures, its accessing methods, transaction management and recovery procedures
- The objective of this course is to systematically teach the learner , Introduction to database, its architecture, procedural language formats and usage, relational data model in detail, query structures, query writing, usage of DML, DDL, TCS queries, query formatting, data base structure creation using normalization, query processing concurrent transaction processing, deadlock handling , storage structures using RAID, data security , distributed databases and recovery methods
Data Base Management Systems at Online Cell- Centre for Distance Education Curriculum
Week 1
Introduction to DBMS
Filed based systems and its issues
Three level architecture
DML and DDLQuery processing and transaction management
Week 2
Relational data model, database design, Relational integrity, constraints. Referential integrity, Relational algebra , Operations in relational algebra
Week 3
Tuple and Domain Relational calculus
ER modelling
Constraints and cardinality relationships
Extended ER model
Specialization and Generalization
ER and EER model of relational mappings
Week 4
Group by queries
Nested queries JoinViews
Integrity and Constraints
Assertion
Triggers
Week 5
Database designs
Anomalies
Functional Dependency
Normalization
Closure of FD
Armstrong algorithms
Week 6
1NF, 2 NF, 3 NF, BCNF and Decomposition
Week 7
Transactions and Recovery
ACID properties
Roll back and Commit
Concurrency execution
Serialisation
Week 8
Precedence graphs
Recoverable Schedule
Concurrency control
Lock and Lock based protocol
Deadlock detection
Time stamping
Failures and Recovery
Distributed Recovery
Two Phase Commit
Week 9
Storage structure
File Organisation
Recovery and atomicity
Performance measures of discs
Database management
RAID levels
Week 10
Indices
B+ Tree
Hashing
Bitmap indices
Data Base Management Systems at Online Cell- Centre for Distance Education Faculty details
Data Base Management Systems at Online Cell- Centre for Distance Education Entry Requirements
- Education: High school diploma or equivalent
- Not mentioned
Other courses offered by Online Cell- Centre for Distance Education
Student Forum
Anything you would want to ask experts?