ABOUT THE COURSE ;
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.
ADMINISTRATION OF THE COURSE ;
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.
IMPORTANT DATES ;
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
COURSE LAYOUT ;
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.
COURSE CERTIFICATE ;
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)
