X
Home > Courses >

Database Management System

By Prof. Mohammad Ubaidullah Bokhari   |   Aligarh Muslim University
Learners enrolled: 11066   |  Exam registration: 1283
ABOUT THE COURSE: A Data Management System (DMS) is a software solution designed to efficiently organize, store, and manage data within an organization. It ensures data accuracy, security, and accessibility, facilitating streamlined retrieval and analysis. With features like data integration, quality management, and backup procedures. The main objective is to provide students a thorough grasp of database administration, including its applications, theories, and practices, with an emphasis on Oracle technology. The goal of this course is to provide participants with a thorough understanding of Oracle Database, SQL, and its advanced capabilities, enabling them to build, implement, and optimize database systems. The project is requesting permission and funding in order to build and provide this powerful training tool that will greatly improve participants' database management system abilities and competency..

Intended audience: Primary audiences include UG and PG students of different streams including B.Sc. / BCA, M.Sc./MCA, B.Tech and M.Tech and also who are aspiring database administrators, software developers, and IT professionals seeking to deepen their expertise in database management.

Pre-requisites: Basic concept knowledge of computer science. The Student of computer science background may take the opportunity to join the course

Industry support: TCS, Wipro, Accenture, HCL, Opera Solution, HexaVeiw, ZMQ, TechMatrix, Technosoft etc

Summary
Course Status : Ongoing
Course Type : Core
Language for course content : English
Duration : 12 weeks
Category :
  • Computer Science and Engineering
Credit Points : 4
Level : Undergraduate/Postgraduate
Start Date : 22 Jul 2024
End Date : 11 Oct 2024
Enrollment Ends : 05 Aug 2024
Exam Registration Ends : 16 Aug 2024
Exam Date : 25 Oct 2024 IST
ALERT ON EXAM DATE :

Exam date is subject to change.

Note: This exam date is subject to change based on seat availability. You can check final exam date on your hall ticket.

Page Visits



Course layout

Week 1: 
  1. Introduction to DBMS. 
  2. Fundamental concepts of Database Management Systems (DBMS)
  3. Database Users, Characteristics of the Database. 
  4. Database Systems Concepts & Architecture.
  5. Data Models, Schemas & Instances.
Week 2: 
  1. Database schemas, Sub-schemas, Data Dictionaries. 
  2. DBMS Architecture & Data Independence.
  3. Data modelling using the Entity-Relationship model, UML. 
  4. Enhanced Entity Relationship, Object Modelling. 
  5. Relational Model, Languages & Systems.
Week 3: 
  1. Introduction of Database Architecture. 
  2. Relational Model Concepts, Relational Model Constraints, integrity constraints.
  3. Introduction of Relational Algebra. 
  4. Relational domain & tuple calculus table spaces, datafiles, Function Dependencies
  5. Normalization for Relational Databases, Functional Dependencies, Multivalued & join dependencies. 
Week 4: 
  1. Normal forms based on primary keys (INF, 2NF, 3NF & BCNF).
  2. Loss less join & Dependency preserving decomposition.
  3. Introduction of SQL Fundamentals 
  4. Relational Database language (DDL, DML, Views, Embedded SQL). 
  5. Data Definition in SQL, View & Queries in SQL.
Week 5: 
  1. Specifying Constraints & Indexes in SQL, Cursor, Triggers, procedure and function in database.
  2. Relational Database Management Systems ,Introduction to Conventional Data Model & Systems. 
  3. Network Data Model & IDMS Systems, Hierarchical Data Model & IMS System
  4. Object Relational Databases: Overview of Object Database Concepts.
  5. Object Database Extensions to SQL. 
Week 6: 
  1. Introduction to Data Security and Integrity : Understanding the critical importance of data security. 
  2. Authorization :Introduction to database security issues
  3. Discretionary Access control based on granting & revoking privileges.
  4. Introduction of Mandatory Access control.
  5. Role-based Access Control for multilevel security this segment concentrates on Oracle's robust security features. 
Week 7: 
  1. Implementation of access controls, encryption, and auditing to safeguard sensitive information.
  2. Ensuring the integrity and confidentiality of the database.
  3. Introduction to Oracle 
  4. Stored procedures, triggers, indexing, and optimization techniques
  5. Introduction of Oracle Database Administration. 
Week 8: 
  1. Installation, configuration, backup and recovery, and routine maintenance tasks.
  2. Introduction of Performance Tuning and Optimization
  3. Techniques for tuning and optimizing Oracle databases.
  4. Data Types, Constraints, and Queries 
  5. Exploring data types in Oracle 
Week 9: 
  1. Working with subqueries and correlated subqueries 
  2. Utilizing set operators: UNION,INTERSECT,MINUS 
  3. Aggregating and analyzing data using functions :AVG,SUM, COUNT, etc.
  4. Understanding database security measures
  5. Managing users and roles in Oracle
Week 10: 
  1. Implementing privileges and access control
  2. Introduction to indexes and their importance
  3. Creating and managing indexes in Oracle 
  4. Utilizing views for data abstraction
  5. Understanding transaction management and ACID properties
Week 11: 
  1. Solve challenges commonly encountered in the field of database management.
  2. Writing more advanced SQL queries using JOINs and GROUP BY Identify and address performance bottlenecks, ensuring optimal responsiveness and efficiency in database operations.
  3. Understanding constraints :NOTNULL,UNIQUE, PRIMARY KEY, FOREIGN KEY  
  4. Introduction of Real-world Applications and Case Studies.
Week 12:
  1. Mini realtime cum hands-on training on different databases including MySql, Sql, Oracle. 

Books and references

1. Date, C.J., "An Introduction to Database Systems", Narosa Publishing House, New Delhi.
2. Elmsari and Navathe, "Fundamentals of Database Systems", 7th Edition, Pearson.
3. Desai, B., "An Introduction to Database Concepts", Galgotia Publications, New Delhi.

Instructor bio

Prof. Mohammad Ubaidullah Bokhari

Aligarh Muslim University
Prof. Mohammad Ubaidullah Bokhari is currently working as a Professor in the Department of Computer Science, AMU, Aligarh. He is a distinguished figure in the realm of Computer Science and holds the esteemed title of being the first individual to complete a Ph.D. in the Department of Computer Science at AMU, Aligarh, in 2006 followed by his D.Sc degree from Crown International University. With an insatiable thirst for knowledge and a commitment to academic excellence, Prof. Bokhari has traversed the globe, visiting countries such as Australia, France, Canada, South Africa, and more for research endeavors. A beacon of knowledge in academia, adding to this illustrious journey, Prof. Mohammad Ubaidullah Bokhari has also held the esteemed position of Associate Professor and Director of Studies at the Australian Institute of Engineering and Technology, Victoria, Melbourne (Australia), further enriching his global academic experience. With over thirty-three years of teaching experience, Prof. Bokhari has mentored a multitude of postgraduate students, guiding them through projects and dissertations. Moreover, under his expert guidance, more than 200 undergraduate projects have flourished. Prof. Bokhari specializes in the field of Software Reliability, having completed his Ph.D. thesis work at Macquarie University, Sydney (Australia), in collaboration with Qualcomm Incorporated, Sydney NSW, Australia. He earned his Master's degree in Computer Science from Aligarh Muslim University and pursued a Master’s Program in Operations Research from the same institution. Throughout his academic journey, Prof. Bokhari has been the recipient of numerous scholarships, including the prestigious Australian Postgraduate Award (Industry) Scheme Scholarship in 2004, in addition to UGC Scholarship, CWS Scholarship, and Bihar Government Merit Scholarship, marking his unwavering dedication to scholarly pursuits. Prof. Bokhari's contributions extend beyond academia, as he has authored several books covering diverse areas of computer science, ranging from "Cyber Security" to "Business Data Processing," cementing his legacy as a prolific scholar and educator and more than 170 paper publications.

Course certificate

The course is free to enroll and learn from. But if you want a certificate, you have to register and write the proctored exam conducted by us in person at any of the designated exam centres.
The exam is optional for a fee of Rs 1000/- (Rupees one thousand only).
Date and Time of Exams: 25 October 2024 Morning session 9am to 12 noon; Afternoon Session 2pm to 5pm.
Registration url: Announcements will be made when the registration form is open for registrations.
The online registration form has to be filled and the certification exam fee needs to be paid. More details will be made available when the exam registration form is published. If there are any changes, it will be mentioned then.
Please check the form for more details on the cities where the exams will be held, the conditions you agree to when you fill the form etc.

CRITERIA TO GET A CERTIFICATE

Average assignment score = 25% of average of best 8 assignments out of the total 12 assignments given in the course.
Exam score = 75% of the proctored certification exam score out of 100

Final score = Average assignment score + Exam score

YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100.

Certificate will have your name, photograph and the score in the final exam with the breakup.It will have the logos of AMU and INI.

Only the e-certificate will be made available. Hard copies will not be dispatched.

Once again, thanks for your interest in our online courses and certification. Happy learning.

-INI Team


MHRD logo Swayam logo

DOWNLOAD APP

Goto google play store

FOLLOW US