technifyed
Weekly list
Opportunities
Learn
ProjectsPrepareAI toolsGet the weekly list

Popular: InternshipsScholarshipsFree coursesInterview prep

IIT Kharagpur via NPTEL

Data Base Management System

Compare with others

Overview

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 the details, they share a common set of models, design paradigms and a Structured Query Language (SQL). 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.

Syllabus 8

  1. Week 1
    • Lecture 1 : Course Overview
    • Lecture 2 : Introduction to DBMS/1
    • Lecture 3 : Introduction to DBMS/2
    • Lecture 4 : Introduction to Relational Model/1
    • Lecture 5 : Introduction to Relational Model/2
  2. Week 2
    • Lecture 6 : Introduction to SQL/1
    • Lecture 7 : Introduction to SQL/2
    • Lecture 8 : Introduction to SQL/3
    • Lecture 9 : Intermediate SQL/1
    • Lecture 10 : Intermediate SQL/2
  3. Week 3
    • Lecture 11 : Advanced SQL
    • Lecture 12 : Formal Relational Query Languages
    • Lecture 13 : Entity-Relationship Model/1
    • Lecture 14 : Entity-Relationship Model/2
    • Lecture 15 : Entity-Relationship Model/3
  4. Week 4
    • Lecture 16 : Relational Database Design
    • Lecture 17 : Relational Database Design (Contd.)
    • Lecture 18 : Relational Database Design (Contd.)
    • Lecture 19 : Relational Database Design (Contd.)
    • Lecture 20 : Relational Database Design (Contd.)
  5. Week 5
    • Lecture 21 : Application Design and Development
    • Lecture 22 : Application Design and Development (contd.)
    • Lecture 23 : Application Design and Development (contd.)
    • Lecture 24 : Storage and File Structure : Storage
    • Lecture 25 : Storage and File Structure : File Structure
  6. Week 6
    • Lecture 26: Indexing and Hashing/1 : Indexing/1
    • Lecture 27: Indexing and Hashing/2 : Indexing/2
    • Lecture 28: Indexing and Hashing/3 : Indexing/3
    • Lecture 29: Indexing and Hashing/4 : Hashing
    • Lecture 30: Indexing and Hashing/5 : Index Design
  7. Week 7
    • Lecture 31: Transactions/1 : Serializability
    • Lecture 32: Transactions/2 : Serializability
    • Lecture 33: Transactions/3 : Recoverability
    • Lecture 34: Concurrency Control/1
    • Lecture 35: Concurrency Control/2
  8. Week 8
    • Lecture 36 : Recovery/1
    • Lecture 37 : Recovery/2
    • Lecture 38 : Query Processing and Optimization/1 : Processing
    • Lecture 39 : Query Processing and Optimization/2 : Optimization
    • Lecture 40 : Course Summarization

Advantages and disadvantages

Advantages

  • Taught by IIT and IISc professors, and it follows the Indian university syllabus closely.
  • All videos and assignments are free on NPTEL and SWAYAM.
  • The certificate is recognised by many Indian universities for credit transfer and by GATE aspirants.
  • Great for GATE and semester exam preparation.
  • Taught by Indian Institute of Technology Kharagpur, one of the strongest names in its field.
  • Completely free.
  • Self-paced: start any time.
  • A clear syllabus (8 parts) you can see before you start.

Disadvantages

  • The certificate needs a proctored exam at a centre, which has a fee.
  • Recorded classroom lectures: thorough, but slower than made-for-online courses.
  • New runs start on fixed dates (January and July).
  • Learning is free, but the certificate costs money.

Some points apply to every course of this kind; see how we rank.

Free to learn

  • Free: Every video and assignment is free on NPTEL and SWAYAM. Enrol when the next run opens.
  • Certificate: Optional. It needs a proctored exam at a centre, which has a fee.

Taught by

  • Prof. Partha Pratim Das Prof. Samiran ChattopadhyayIIT Kharagpur

Indian Institute of Technology Kharagpur is in Tier 1: world-leading universities and India's top institutes of our institution ranking (95/100).

Similar courses

Compare these

Massachusetts Institute of Technology · YouTube

MIT 6.01SC Introduction to EECS I

Instructor: Dennis Freeman, Kendra Pugh This course provides an integrated introduction to electrical engineering and computer science, including modern software engineering, linear systems analysis, electronic circuits, and decision-making. The lecture videos provide an overview of each topic, whi…

Free video27 videos, 17 hours

Harvard University · edX

Exercising Leadership: Foundational Principles

4.71,590 ratings

Mobilize people to tackle tough problems and build the capacity to thrive through the dangers of change

Free to audit4 weeks, 2 - 3 hours per week

Harvard University · edX

Fundamentals of TinyML

4.567 ratings

Focusing on the basics of machine learning and embedded systems, such as smartphones, this course will introduce you to the “language” of TinyML.

Free to audit5 weeks, 2 - 4 hours per week

Harvard University · edX

Introduction to Data Science with Python

4.3174 ratings

Learn the concepts and techniques that make up the foundation of data science and machine learning.

Free to audit8 weeks, 3 - 5 hours per week

Harvard University · edX

CS50's Introduction to Computer Science

An introduction to the intellectual enterprises of computer science and the art of programming.

Free to audit12 weeks, 5 - 14 hours per week

Massachusetts Institute of Technology · YouTube

MIT MAS.S62 Cryptocurrency Engineering and Design, Spring 2018

Instructor: Neha Narula, Tadge Dryja View the complete course: https://ocw.mit.edu/MAS-S62S18 YouTube Playlist: https://www.youtube.com/playlist?list... This course looks at the design of Bitcoin and other cryptocurrencies and how they function in practice, focusing on cryptography, game theory, an…

Free video20 videos, 25 hours

Enter your email and the official page opens. Phone is optional.

We email you a code to confirm the address. We save your email, and your phone number if you add it, to send you this link and, if you tick the box, the weekly list. Under 18? Ask a parent or guardian first. How your details are used.

Open official page