Data Base Management System

Start Date
05/02/2018

End Date
30/03/2018

No. of
Enrollments
2729 students

No course
syllabus uploaded

Created by

Partha Pratim Das
Indian Institute of Technology - Kaharagpur
4.6
out of 5
Based on 5 ratings
5 star 3
4 star 2
3 star 0
2 star 0
1 star 0
Course Language
English
Course Type
Scheduled
Video transcripts
English
Course Category
Engineering
Learning Path
Undergraduate
Course Length
20 Hours
Weekly time commitments
20 Hours
Course Completion
Yes, after passing all tests.
Exam Date
To be announced
Credits
0

44

Tutorials

0

Test

0

Assignment

0

Article

0

Weekly Reading list

Overview

For certification please click here

 

Last date for enrollment: February 5, 2018

 

ABOUT THE COURSE 

Databases form the backbone of all major applications today – tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. 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. While DBMS’s differ in details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course would examine 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. It would also introduce 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 will also be introduced.


INTENDED AUDIENCE:

  • Students from all disciplines can enroll for this course.

PRE-REQUISTES:

  • Knowledge of Programming
  • Data Structure and Algorithms

CORE/ELECTIVE: Core / Elective Course. DBMS is core in some curriculum and elective for the rest

UG/PG : UG / PG. This is a first level course. It can be taken at PG level if not covered at UG level.

INDUSTRY SUPPORT : 
DBMS is so fundamental that all companies dealing with systems as well as application development (including web, IoT, embedded systems) have a need for the same. These include – 

  • Microsoft
  • Samsung
  • Xerox
  • Yahoo
  • Google
  • IBM
  • TCS
  • Infosys
  • Amazon
  • Flipkart, etc. 

To access the content, please enroll in the course.

Faculty

Partha Pratim Das


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. In 1998, he joined Alumnus Software Ltd as a Business Development Manager. From 2001 to 2011, he worked for Interra Systems, Inc. as a Senior Director and headed its Kolkata Center. In 2011, he joined back to Department of Computer Science and Engineering, IIT Kharagpur as Professor. Dr. Das has also served as a Visiting Professor with Institute of Radio Physics and Electronics, Calcutta University from 2003 to 2013.

Dr. Das is currently the Head of Rajendra Mishra School of Engineering Entrepreneurship, the Professor-inCharge of the upcoming Research Park of IIT Kharagpur at Rajarhat, Kolkata, and the Joint Principal Investigator of National Digital Library of India project of MHRD.

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. Jointly with 2 others, he has also offered a course on Introduction to Design of Algorithms under the T10KT program of NME-ICT, MHRD (https://www.facebook.com/t10kt.algorithms/) to nearly 7000 teachers. Further, Dr. Das has been offering Programming in C++ and Object-Oriented Analysis and Design in NPTEL-NOC. Both courses are regularly attended by thousands of students.

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.


REFERENCES:


1. Text Books / Basic Material
      – Database System Concepts by Abraham Silberschatz, Henry F.
         Korth, and S. Sudarshan, 6th Edition, McGraw-Hill Education, 2010.
      – Presentations used in the Course 

2. Reference (Advanced) Material
    This is a first level course. So the textbook would be the primary resource also for the advanced chapters. In addition, some references will
    be specified for every topic during the course.


CERTIFICATION EXAM: 
  • The exam is optional for a fee. · 
  • Date and Time of Exams: April 28 (Saturday) and April 29 (Sunday) : 
    Morning session 9am to 12noon. 
    Afternoon session: 2pm to 5pm.
     
  • Exam for this course will be available in one session on both 28 and 29 April. The exact session it will be available in (FN/AN) - we shall inform by first week of January 2018. · 
  • 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. 

CERTIFICATE:
  • Final score will be calculated as : 25% assignment score + 75% final exam score  
  • 25% assignment score is calculated as 25% of average of 08 weeks course: Best 6 out of 8 assignments  
  • E-Certificate will be given to those who register and write the exam and score greater than or equal to 40% final score. Certificate will have your name, photograph and the score in the final exam with the breakup. It will have the logos of NPTEL and IIT Kharagpur. It will be e-verifiable at nptel.ac.in/noc.

FAQs

No FAQ has been added to this course yet.

Download App

Download SWAYAM applications from popular app stores