Database Management System - Lab - Syllabus

MC9218 DBMS LAB
L T P C
0 0 3 2
1. Creation of base tables and views.
2. Data Manipulation
INSERT, DELETE and UPDATE in tables
SELECT, Sub Queries and JOIN
3. Data Control Commands
4. High level language extensions – PL/SQL. Or Transact SQL
5. Use of Cursors, Procedures and Functions
6. Embedded SQL or Database Connectivity.
7. Oracle or SQL Server Triggers.
8. Working with Forms, Menus and Reports.
9. Front-end tools – Visual Basic/Developer 2000