Course Description: This 100-hour course is designed for those
who are interested in learning the complete skills necessary to become a quality Oracle 8
DBA and be best prepared to obtain the industry recognition through Oracle 8 DBA
Certification Program. Learning the true knowledge and practical skills remains the first
priority of our training program. Our goal is to produce a team of top gun Oracle DBAs,
who are not only best prepared to pass Oracle's certification tests, but most importantly,
are equipped with the top notch technical skills capable of successful performance in
their future DBA tasks.
In this course,
students will get a jump start in 5 major Oracle areas : SQL and PL/SQL, Oracle
Installation and Database Administration, Backup and Recovery, Performance Tuning and
Net8. Upon completion of this course, participants will be able to do Oracle Development
and Database Administration on the SUN Solaris UNIX and Windows NT 4.0, and Redhat 5.2
Linux environment.
Tuition:
$2000 (100 hrs)
Schedule and Agenda
1.
Introduction of Oracle
Understanding
Data Model
- Entity Diagram Structure
- Common M:1 Relationships
- Less Common M:1 Relationships
- Unusal M:1 Relationships
- M:M Relationships
- Normalization
- Creating a Entity Relationship Diagram (ERD)
- Generate DDL
2. SQL
Develop Complex Queries
- Subqueries
- Single-row Subqueries
- Multiple-value Subqueries
- Multiple-Column Subqueries
- Correlated Subqueries
- SQL Character Function
- Generate SQL from SQL
3.Overview of PL/SQL
Creating Procedures
- Syntax for Creating Procedures
- Creating a Stored Procedures using SQL*Plus
- Procedural Parameter Modes (IN, OUT Arguments)
- Methods of Passing Parameters
- Removing Procedures
Creating Functions
- Syntax for Creating Functions
- Creating a Function using SQL*Plus
- Advantages of User-Defined Functions in SQL
Expressions
- Restrictions of Calling Functions from a SQL
Expressions
- Invoking Functions from a SQL Statement
- Removing Function
- Comparing Procedures and Functions
4. Creating Packages
- Overview of Packages
- Advantages of Packages
- Developing a Package
- Creating the Package Specification
- Creating the Package Body
- Public and Private Constructs
- Referencing a Global Variable Within the Package
- Persistent State of Package Variable, Package
Cursor
- Removing Packages
- Managing Packages
- Guidelines of Developing Packages
Creating Triggers
- Overview of Triggers
- Database Triggers and Cascading Triggers
- Trigger Components
- Firing Sequence of Database Triggers on a Single
Row
- Firing Sequence of Database Triggers on Multiple
Rows
- Syntax for Creating Statement Triggers
- Before Statement Trigger
- After Statement Trigger
- Using Conditional Predicates
- Using Old and New QualifiersRules Governing
Triggers
- Auditing Using a Trigger
- Protect Referential Integrity with a Trigger
- Replicate a Table with a Trigger
5. Manipulating Large Objects
- Overview of the Large Object Types
- Creating a Table with LOBs
- Managing LOBs and BFILEs
- Populating LOBs
- Removing LOBs
- Working with DBMS_LOB Package
6. Oracle Database
Administration
- Understand Oracle8 Server Architecture and its
components.
- Installation Oracle 8 (unix platform)
- Define variables
- Create directories
- Install Oracle Executable
7. Creating Oracle Database
- Create Database following OFA
- Create Data Dictionary Manage Oracle Database
- Create and Manage Tablespaces
- Create and Manage Datafiles
- Create and Manage Rollback Segments
- Create and Manage Temporary Tablespaces
- Create and Manage Redo logs
8. Manage Database Objects
- Manage Space
- Managing Disk space in Data Block
- Setting Storage Parameters
- Manage Tables
- Managing Tables
- Managing Partitioned Tables
- Manage Indexes
- Managing Indexes
- Managing Partitioned Indexes
- Manage Views, Sequences and Synonyms
9. Manage Users, resources and
Security
- Create users
- Manage resources with profile
- Manage passwords with profile
- Manage user privileges with role
Ensure Data Integrity
Audit the Oracle Database
- Overview
- Enable Auditing
- Audit Statements
- Audit Privileges
- Audit Objects
- Monitor and Manage the Audit Trail
- Display Auditing Information
10. Backup
- Overview
- Archive log
- Archive Processing
- Enable Archive
- Backup
- Export
- Cold Backup
- Hot Backup
- Offline Backup
- Online Backup
- Backup Control File
11. Recovery
- Reovery with Archive logs
- Perform Media Recovery Proc
- Import
- edures
- Perform Partial or Point-in-Time Database Recovery
- Recover an Online Redo Log File
- Recover a Control File
- Standby Database
- Create a Standby Database
- Create a Standby Control File
- Apply Archive log to Standby Database
- Activate a Standby Database
12. Performance Tuning
13. Net8
- Start up and
shutdown the listener
- Configure Listener on the Server side
- Configure Listener on the Client Side
- Connecting database using Sql*net
Database Links
- Creating a database link
- Connecting to a remote database using database
link
Loading Data using SQL* Loader
- Overview
- Loading Data Using Conventional Path
- Loading Data Using Direct Path
- Continue Aborted Loads
- Specify Load Paramete
|