Page no:54
IT22L-DBMS Lab
Objective : Through this lab work will enhance database handling, data manipulation and data processing skills through SQL & PL/SQL, which will help them in developing data centric computer applications. Sr. No. 1 2 Chapter Details Overview of RDBMS, Oracle introduction Introduction of SQL DDL, DML, DTL Basic Data Types Char, varchar/varchar2, long, number, Fixed & floating point Date, CLOB, BLOB Table Constraint definition Commands to create table Commands for table handling Alter table, Drop table, Insert records Commands for record handling Update, Delete Select with operators like arithmetic, comparison, logical Query Expression operators Ordering the records with orderby Grouping the records SQL functions Date, Numeric, Character, conversion Group functions avg, max, min, sum, count Set operations Union, Union all, intersect, minus Join concept Simple, equi, non equi, self, outer join Query & sub queries Synonym introduction, object type Create, synonym as alias for table & view, drop Sequence Introduction, alter sequence, drop View Intro, create, update, drop Index Introduction, create Primary introduction to DBA User create, granting privileges (Grant, Revoke, Commit, Rollback, Savepoint)
3
4 5
6
7 8 9 10 11 12 13 14