Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Online Course

Database Management System

Indian Institute of Technology, Kharagpur and NPTEL via Swayam

110
Found in Databases

Taken this course? Share your experience with other students. Write review

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.

INTENDED AUDIENCE :Students from all disciplines can enroll for this course.
PRE-REQUISTES :
1. Procedural and / or Object-Oriented Programming (C / C++ / Java / Python)
2. Data Structures
3. Algorithms

INDUSTRY SUPPORT : DBMS is so fundamental that all companies dealing with systems as well as application development (including web, IoT, embedded systems, data mining, machine learning) have a need for the same. These include – Microsoft, Samsung, Xerox, Yahoo, Google, IBM, TCS, Infosys, Amazon, Flipkart, etc.

Syllabus

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.

Taught by

Partha Pratim Das

Reviews for Swayam's Database Management System Based on 0 reviews

  • 5 star 0%
  • 4 star 0%
  • 3 star 0%
  • 2 star 0%
  • 1 star 0%

Did you take this course? Share your experience with other students.

Write a review

Class Central

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free