Oracle 9i Database Administrator
Oracle Certified
Professional Database Administrator
Oracle
Certified Professional Database Administrator
PAPER
I : SQL (50
HOURS)
Oracle9i is a Relational Database Management System(RDBMS) with
Object Relational Database Management(ORDBMS) futures. Oracle9i
is the latest technology, which has many new features over previous
versions like 8i and 8. Oracle9i comes with new SQL enhancements.
SALIENT FEATURES
-
Oracle has sophisticated
security mechanisms control access to sensitive data by an assortment
of privileges.
-
Oracle provides sophisticated
backup & recovery routines. Backup creates a second copy
of Oracle Data, recovery restores a copy of data from back up.
-
Oracle provides flexible
space management. It has special abilities that are capable
of handling very large databases.
-
Oracle provides open
connectivity to & from other vendors software.
-
Oracle server supports
a wide range of Development tools, end user query tools, off
the shelf applications & office wide information tools.
APPLICATIONS
TOPICS
COVERED
-
Writing Basic SQL
Select Statement.
-
Restricting and Sorting
Data.
-
Displaying Data from
Multiple Tables.
-
Aggregating Data
Using Group Functions.
-
Sub queries.
-
Producing Readable
Output with iSQL*Plus.
-
Manipulating Data.
-
Creating and Managing
Tables.
-
Including Constraints.
-
Creating Views.
-
Other Database Objects.
-
Controlling User
Access.
-
SQL Workshop.
-
Using Set Operators.
-
Date time Functions.
-
Enhancements to Group
by Clause.
-
Advanced Sub queries.
-
Hierarchical Retrieval.
-
Extensions to
DML and DDL Statements.
SQL
(Paper I)
TOPICS
COVERED
- SQL as an extension of SQL
- Stored Procedures
- Packages
- Tools for Creating a Stored
Procedures
- Visual Database Tools
- Oracle Procedure Builder
- Error Handling in SQL
- Creating Stored Procedures
(a) SQL Data Types
(b) Declaring Variables
(c) Statements and Assignments
(d) Flow Control Statements
(e) Loops
- Using SQL Statement in SQL
- SQL Cursors
- User Defines Data Types
- SQL Tables and Collections
- Cursor Variables
- Using Triggers
| Course Duration |
Fees
(Indian RS.) |
Fees
(US $) |
| 50 sessions
of 1 hr. each |
8,000 |
230 |
Paper
II : DBA I (50 Hours)
- Oracle architectural components.
- Getting started with oracle server.
- Managing Oracle instance.
- Creating a database.
- Using data dictionary and dynamic
performance views.
- Maintaining Control File.
- Maintaining Redo Log Files
- Managing tablespaces &
datafiles.
- Storage structure and relationship.
- Managing Undo Data.
- Managing Indexes and tables.
- Managing password security
and resources.
- Managing users .
- Managing privileges.
- Managing Roles.
- Auditing.
- Loading data into database.
- sing globalization support.
Paper
III : DBA
II
(50 Hours)
- Networking Overview.
- Oracle Net Architecture
- basic Oracle Net Server Side
Configuration.
- Naming Method
Configuration
- Usage and Configuration
of Oracle Shared Server
- Backup and Recovery
Overview.
- Instance and
Media Recovery Structures
- Configuring the Database Archiving
Mode.
- Oracle Recovery
Manager Overview and Configuration
- User Managed
Backups
- RMAN Backups
- User-Managed
Complete Recovery
- User-Managed Incomplete Recovery
- RMAN Incomplete
Recovery
- RMAN
Maintenance
- Recovery Catalog
Creation and Maintenance
- Transporting
Data Between Databases
Paper
IV : Performance Tune(50 Hours)
-
Overview of Oracle
9i Performance Tuning.
-
Diagnostic and Tuning Tools
-
Sizing
the Shared Pool
-
Sizing
the Buffer Cache
-
Sizing
Other SGA Structures
-
Database
Configuration and I/O Issues
-
Optimizing
Sort Operations
-
Diagnosing
Contention for Latches
-
Monitoring
and Detecting Lock Contention
-
Tuning
the Oracle Shared Server
-
SQL
Statement Tuning
-
Using
Oracle Blocks Efficiently
-
Application
Tuning
-
Tuning
the Operating System and Using Resource Manager
Exam
details:
