Course Code: CS246
Course Name: Database Management Systems Laboratory
Prerequisites: CS203, CS204
Syllabus: Using a relational DBMS: Writing SQL queries, accessing a DBMS from an external application. Implementing of parts of DBMS such as various file organizations, indexing methods (Tree/ Hash/ Bitmap), external sorting algorithms, concurrency control schemes, and crash recovery schemes. Non-relational DBMS; performance comparison of a non-relational DBMS with a relational DBMS for an application.
References: 1. H. Garcia-Molina, J. Ullman, J. Widom, Database System Implementation, 2nd Edition, Pearson, 2002.
2. J. Groff and P. Weinberg, SQL Complete Reference, McGraw Hill, 3rd Edition, 2017.
3. P. Sadalage and M. Fowler, NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison Wesley, 2012.