flow in



Databases form the backbone of all major applications today. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain. In this background the course examines data structures, file organizations, concepts and principles of DBMS’s, data analysis, database design, data modeling, database management, data & query optimization, and database implementation. More specifically, the course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. Further it introduces query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client / server architectures based and Web-based database applications is also introduced.


The experts that would acquaint you with the skills shall be:
Prof. Partha Pratim Das &Samiran Chattopadhyay| IIT KHARAGPUR

Prof. Partha Pratim Das received his BTech, MTech and PhD degrees in 1984, 1985 and 1988 respectively from IIT Kharagpur. He served as a faculty in Department of Computer Science and Engineering, IIT Kharagpur from 1988 to 1998. Dr. Das has taught several courses in Computer Science including Software Engineering, Object-Oriented Systems, Programming and Data Structure, Compiler Design, Design and Analysis of Algorithms, Information System Design, Database Management Systems, Computational Geometry, Principles of Programming Languages, Embedded Systems, and Image Processing
Samiran Chattopadhyay obtained his B Tech and M Tech degree in 1987 and 1989 respectively from IIT Kharagpur. He obtained his PhD degree from Jadavpur University in 1993. He served as a faculty in the Department of Computer Science and Engineering, Jadavpur University from 1989 to 1993. In 1993, he moved to industry and joined back the same department in Jadavpur University as an Associate Professor in 1997. Since 2001, he is a Professor of Information Technology in Jadavpur University.


Enrollment ends: 22 Aug 2022
Start Date: 22 Aug 2022
End Date: 14 Oct 2022
Exam Date:29 oct 2022
Duration: 8 weeks
Course category: Computer science and Engineering


Week 1
• Course Overview. Introduction to RDBMS
Week 2
• Structured Query Language (SQL)
Week 3
• Relational Algebra. Entity-Relationship Model
Week 4
• Relational Database Design
Week 5
• Application Development. Case Studies. Storage and File Structure
Week 6
• Indexing and Hashing. Query Processing
Week 7
• Query Optimization. Transactions (Serializability and Recoverability)
Week 8
• Concurrency Control. Recovery Systems. Course Summarization.


Internal Assessment:25% , best 6 assignment out of 8 assignments and written(offline) examination:75% out of 100 marks
Final score should be 40/100 { 10/25,30/75} to get eligible for certificate

SWAYAM Official Links ;

Official website – https://swayam.gov.in
From here you can visit the site and explore more courses according to your preferences.
There are many courses which will enhance your skills and gives you diploma in the courses you want to pursue in future.

By :- Saumya Yadav (kirori mal college, DU)

   Support Us   


There are thousands of news portal and blogger on the internet. In name of saving democracy, they get money from various sources even though they support particular ideology. We need your support to fight them. Suppport us by sharing our news portal with your friends.

Leave a Reply

Your email address will not be published. Required fields are marked *