Database Management System Lab

Database Management System Lab    

To Study and Implement Data Definition Language Commands, Data Manipulation Commands & SQL Commands

To study and implement SQL data retrieval using SELECT, FROM and WHERE clause.

To study and implement different SQL single row and multiple row functions.

To study and implement aggregating Data using Group By Clause, HAVING clause and sort data using Order By clause

To Study and Implement different types of Set Operation in SQL.

To Study and Implement different types of Joins in SQL

To study and implement Sub queries/Nested queries, Correlated nested queries in SQL

To Study and Implement Views in SQL

To study and implement Functions and Procedures

To study and implement SQL Triggers