Syllabus  |   Lectures  |   Downloads  |   FAQ  |   Ask a question  |  
Course Co-ordinated by IIT Kharagpur
Coordinators
 
Prof. Partha Pratim Das
IIT Kharagpur

 

Download Syllabus in PDF format



Untitled Document
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.

Week

Topics

1.

Course Overview. Introduction to RDBMS

2.


Structured Query Language (SQL)

3.


Relational Algebra. Entity-Relationship Model

4.


Relational Database Design

5.


Application Development. Case Studies. Storage and File Structure

6.


Indexing and Hashing. Query Processing

7.


Query Optimization. Transactions (Serializability and Recoverability)

8.


Concurrency Control. Recovery Systems. Course Summarization.

  • Knowledge of Programming
  • Data Structure and Algorithms

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.


nil


nil



Important: Please enable javascript in your browser and download Adobe Flash player to view this site
Site Maintained by Web Studio, IIT Madras. Contact Webmaster: nptel@iitm.ac.in