MC7111 DBMS LABORATORY Syllabus
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 – Packages
5. Use of Cursors, Procedures and Functions
6. Embedded SQL or Database Connectivity.
7. Oracle or SQL Server Triggers – Block Level – Form Level Triggers
8. Working with Forms, Menus and Report Writers for a application project in any domain
9. Front-end tools – Visual Basic/Developer 2000.
ADS HERE !!!