Course Detail

Course Description

Oracle Course Syllabus
Day Chapter Topic Hours
1 DBMS Concepts Introduction to DBMS
Advantages
1
2 File system vs DBMS 1
4 Data Models 2
6
7
DBMS Components 2
8
9
DBMS Architecture
Client Server Technology
2
10
11
Oracle Basics Introductin to Oracle
Oracle Features
2
12 Oracle DataBase Architecture 1
13 SQL Types of SQL
statements(DDL,DML,DCL)
SQL Features
SQL Data types
1
14 Oracle Table Operations Oracle Demo tables
Table Creation
1
15 Insert 1
16 Select with with various
operations
1
17
18
SQL pre defined functions 2
19 Updating Table data 1
20
21
Deleting Table data
Dropping table
Truncating tables
2
Day Chapter Topic Hours
22 Rollback, commit, savepoint 1
23
24
Constraints Domain Integrity Constraints
Unique, Not Null, Primary Key,
Check
Referential Integrity Constrains
Foreign Key
Adding & Removing Constraints to
existing table
2
25
26
Sub Queries Nested Sub Queries
Correlated Sub Queries
2
27
28
Table Joins Equi join, outer join, Cartesian
join, self join
Set opeations
Union, intersect, union all , minus
2
29 Group by operations Select with group by
Aggrigate functions using group by
1
30
31
Views View definition, Advantages
Creating views various operations
2
32 Sequences Creating , retrieving data ,
modifying, dropping sequences
1
33 Indexing What is index, advantages
Types of indexes
Creating index
Retrieving data using index
Dropping sequence
1
34 Clustering What is clustering,
Advantages of clustering
1
Day Chapter Topic Hours
Creating cluster
Applying clusters to tables
35
36
SQL Reports Preparing SQL reports 2
37 PL/SQL Introduction to PL/SQL
PL/SQL features
PL/SQL Block Structure
1
38
39
40
Basic Programming with PL/SQL
Control statements,
loops
3
41
42
43
Cursors
Definition,Advantages,
Implementation,Explicit Cursor
Attributes,Ref cursors
3
44
45
PL/SQL
Stored Procedures introduction
Implementing Procedures for
various operations on data base
2
46
47
User Defined functions
Implementing User Defined
functions with various operations
Parameter Modes(in,out,inout)
2
48
49
Packages
importance, advantages
Implementing packages
2
50
51
Data Base Triggers
Definitions,
Implementing triggers for various
2
Day Chapter Topic Hours
DML operations (insert, delete,
update)
52 Other Tables User_tables,
User_views
User_constraints
User_procedures
User_objects
User_triggers
User_indexes
1
53
54
OOPS Object Oriented Programming
Creating Object types,
Implementing data members &
member functions in objects
Static methods, self , ref, deref
2
55 Varying Arrays Varying Arrays 1
56 Nested Tables Nested Tables 1
57 User Creation Creating users
Granting & Revoking permissions
on Data base
Granting & Revoking permissions
on Objects
58
59
Table partitions Various types of partitions
Range, list, hash
2