COURSE SUMMARY
Course Title: 
Functional Programming Lab
Course Code: 
18CA487
Year Taught: 
2018
Degree: 
Postgraduate (PG)
School: 
School of Engineering
Campus: 
Amritapuri

'Functional Programming Lab' is a course offered in M. C. A. (Master of Computer Applications) program at School of Engineering, Amrita Vishwa Vidyapeetham, Amritapuri.

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