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
Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, 6th edition, Tata McGraw Hill, 2011
Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, 4th Edition, Pearson/Addision wesley, 2007