Course Title: 
Data Structures and DBMS Lab
Course Code: 
Year Taught: 
Postgraduate (PG)
School of Arts and Sciences
School of Engineering

'Data Structures and DBMS Lab' is a course offered in M. C. A. (Master of Computer Applications) program at Amrita Vishwa Vidyapeetham.

Linear data structure implementation: Singly Linked list,Doubly linked list, Stack, Queue, and applications. Non linear data structure implementation: Binary search tree, AVL tree, Adjacency matrix and adjacency list representations, skip list, dictionary, suffix tree. Table Design- Data Definition Language (DDL) commands - Table creation and alter(include integrity constraints such as primary key, referential integrity constraints, check, unique and null constraints both column and table level, Drop - Other database objects such as view, index, cluster, sequence, synonym etc. - Practice SQL Data Manipulation Language (DML) commands - Row insertion, deletion and updating - Retrieval of data - Simple select query - Select with where options (include all relational and logical operators) - Functions: Numeric, Data, Character, Conversion and Group functions with having clause. - Set operators - Sorting data - Sub query (returning single row, multiple rows, more than one column, correlated sub query) - Joining tables( single join, self-join, outer join) - Data manipulations using date functions - User defined functions in a query- Transaction Control Language (TCL) commands ( Grant, revoke, commit and save point options) - Usage of triggers, functions and procedures using PL/SQL constructs