Oracle [ 302 ]
Objective :
1. The concepts related to database, database techniques, SQLs and database
operations are introduced in this subject.
2. This create strong foundation for application data design.
Sr.
No Chapter Details Hours
1 Introduction to oracle Architecture 2
2 Overview with tool of Oracle Sql *plus,
PL/SQL
3 Introduction to SQL
Data types,
DDL create ,alter,drop
DML insert, update, delete, select with all
clauses
Sub queries
DCL statements
10
4 Operators (arithmetic,comparision,logical)
Predicates such as in, between, like, any, all,
exists, null
5 Query Expression operators
Union
Intersect
Minus
6 SQL Functions
Date functions
Numeric functions
String functions
Conversion functions
Group functions
Nested functions
7 Joins
Self
Equi
Non equi
Outer
Cartesian product
8 Views and Synonyms 1
9 PL/SQL
Introduction to PL/SQL
Advantages of PL/SQL
PL/SQL Character Set
Data types
Character, Raw, rowid, boolean,
binary_integer, number,Variable, constant
10 PL/SQL blocks
Attribute - %type, %rowtype
operators function comparison, numeric,
character, date
control structure
sequential - goto
11 Cursor
Explicit & implicit Cursor
Cursor for loop
Parametric cursor
Declaring cursor variables
Constrained and unconstrained cursor
variables
Opening a cursor variable from a query
Closing cursor variables
Restrictions using cursor variables
12 Execption handling
concept of exception
pre defined exceptions
no_data_found,
cursor_allready_open,
dup_val_on_index, storage_error,
program_error,zero_divide,
invalid_cursor, login_denied,
invalid_number, too_many_rows,
dbms_output, user_defined
exceptions
13 Composite Datatypes
Record, Declaration, refer, record assignment,
Table declaration, table attributes (count, delete,
exists, first, last, next, prior)
14 Procedures and Functions
Definition, Implementation and Execution
15 Packages 2
16 Database Triggers
Types of Triggers
Enabling, disabling
Predicates- inserting, updating,
Deleting
Reference books:
1. Database Management Systems Bipin Desai
2. ORACLE 7 Ivan Byrass
3. Understanding Oracle Perry J. and Later J.
4. SQL, PL/SQL Programming Language Ivan Byrass
of oracle
Reference http://www.unipune.ernet.in/stud_info/Syllabi/Syllabus_2008.html
|
No responses found. Be the first to respond...
|