| MUET / Departments / Computer Systems & Software Engineering / Course of CS / DBMS |  |
DATABASE MANAGEMENT SYSTEMS Theory (100) Practical (50) INTRODUCTION TO MANAGING DATA Characteristics of DBMS, Concept of RDMS & its characteristics, Codd’s Law for RDBMS, Introduction to ORACLE Tools STRUCTURED QUERY LANGUAGE (SQL) Interacting SQL*Plus, Data Manipulation in DBMS, the ORACLE Data types, Two Dimension Matrix creation, Insertion of Data into tables MANAGING TABLES Select Statement and its supporting Clauses and with its various applications, Insertion of Data into Tables, Updating the Contents of Tables, Deletion Operations MODIFYING THE STRUCTURE OF TABLE Adding & Modifying new and existing columns, Restrictions on the Alter tables, Removing tables, Deleting & Dropping tables DATA CONSTRAINTS Column & Table level constraints, Primary & Foreign Key concepts, Application of other Data constraints ORACLE FUNCTIONS Character Function, Numeric Functions, Date Functions, Single row Function, and Group functions. JOINING Introduction to Joining, Equi-Join, Non-Equi join, self-joining, vertical joining (union, intersect and minus Clause) INDICATES, VIEWS AND SEQUENCES Creating & mapping indexes, Application of views, creating & managing views & sequences. GRANTING PERMISSIONS Permission on the objects, Granting permissions, Object privileges, Revoking permissions PL/SQL Introduction to PL/SQL, PL/SQL execution environment, Block structure, ORACLE transaction ERROR HANDLING IN PL/SQL Introduction, Declaring Exceptions, Implicit & Explicit Exceptions, Predetermined internal PL/SQL exceptions CURSORS Introduction to Cursors, Explicit cursor, implicit cursor, creating & Managing Explicit / Implicit Cursors, Attributes Explicit & Implicit cursor Attributes cursor for loops STORED PROCEDURES Introduction, Internal structures, Deleting procedures, Advantages of procedures, Deleting stored procedures STORED FUNCTIONS Introduction, Internal structures, Deleting functions, Advantages of Functions, Deleting stored functions REFERENCE BOOKS [1] Ivan Bayross, “Commercial Application Development using ORACLE DEVELOPER 2000”, BPB Publications [2] Daniel J. Cronin, “Mastering ORACLE Featuring Oracle’s SQL standards”, 1st Edition 1990, Call No. 001.6424(CRO) [3] David Kruglinski, “Database Management Systems”, 1998, Call No. 001.624.KRU [4] David Pepin, “ORACLE Programmers Guide, 1998, Call No. 001.624 (PEP) [5] W.H. Inmon, “ORACLE, Building High Performance Online Systems”, 1991, Call No. 001.624 INM [6] James T. Perry/Joseph G. Laute, “Understanding ORACLE”, 1991, Call No. 001.624 PER
|
