Back close

Course Detail

Course Name Data Structures and DBMS Lab
Course Code 18CA381
Program M. C. A., M. C. A. ( Offered at Mysuru Campus )
Credits One
Year Taught 2018
Degree Postgraduate (PG)
School School of Arts and Sciences, School of Engineering
Campus Kochi, Mysuru, Amritapuri

Syllabus

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

DISCLAIMER: The appearance of external links on this web site does not constitute endorsement by the School of Biotechnology/Amrita Vishwa Vidyapeetham or the information, products or services contained therein. For other than authorized activities, the Amrita Vishwa Vidyapeetham does not exercise any editorial control over the information you may find at these locations. These links are provided consistent with the stated purpose of this web site.

Admissions Apply Now