Advanced DBMS Laboratory

Credit: 2

 

Objective:

  • To explore the features of a Database Management Systems

  • To interface a database with front end tools

  • To understand the internals of a database system

 

Experiments

  • Basic SQL

  • Intermediate SQL

  • Advanced SQL

  • ER Modeling

  • Database Design and Normalization

  • Accessing Databases from Programs using JDBC

  • Building Web Applications using PHP & MySQL

  • Indexing and Query Processing

  • Query Evaluation Plans

  • Concurrency and Transactions

  • Big Data Analytics using Hadoop

 

Outcome:

  • Ability to use databases for building web applications.

  • Gaining knowledge about the internals of a database system.

 

References

  1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, 6th edition, Tata McGraw Hill, 2011

  2. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, 4th Edition, Pearson/Addision wesley, 2007