	Training/Mentoring

	E-Business Suite
	Business Intelligence
	Custom Development
	Database Services
	Managed Services
	Training/Mentoring
		The Service
		The Value
		References
		Contact Us / Registration
		Oracle Certification Prep
		Pricing
		Course Schedule
		Directions, Travel & Accommodations
		Register Online
	Oracle Licensing

Oracle Database Administration

Click here to contact us

Course Overview

Oracle Database Administration introduces students to major elements of the Oracle Database that are relevant to typical DBA work. Some of the features are demonstrated and experienced through hands-on lab exercises. This course intentionally doesn't cover ALL elements of the Oracle Database as there simply wouldn't be enough time to afford any single one of them a justified treatment. There are simply too many. If such an unfair effort is made to "cover" ALL elements of the Oracle Database, it's doubtful there would be real learning experienced by the student of any one feature. Such an approach would be only slightly beyond what would be gained by reading a database features list. On the contrary, a selection of very good and useful elements is covered in fair depth.

Course Goals

To describe major Oracle Database elements in a conceptual manner
To practice the use of some of the elements by implementing them in lab exercises
To facilitate discussion of student questions about the concepts and implementation of the database elements.

Prerequisites

SQL & SQL*Plus

Who Should Attend?

Database administrators

Course Materials

Database Administration Course Notes
Database Administration Sample Script Disk

Duration

Five days

Tuition

$2,325

Course Outline

Database administrator responsibilities
Oracle architecture
- Instance
  - SGA
  - Oracle processes
- Database
  - Physical and logical database structure
    - File types
    - Tablespace types
    - Storage configuration of individual tablespaces and objects
    - Oracle managed files
    - Automatic storage management
  - Schema objects (including clusters and hash clusters and temp tables, object-relational)
- Oracle Net
  - Connection manager
- MTS
- Replication
- RAC
- Grid
Oracle server installation
- Silent mode install, etc.
Oracle Database creation
- DBCA
- DBCA templates
- SPFILEs
How Oracle works
- How a transaction works
- How locking works, lock types, transactional consistency
Design and data modeling fundamentals
- Data types, globalization
- Partitioning
- Constraints
- DBMS_METADATA
- What is a data warehouse? What is an OLTP database?
- Data mining
- Analytics
- Oracle text
- HTML DB
Loading data
- SQL*Loader
- Nologging
- Materialized views
- Data pump, export, import
- Using external tables to load and unload data
- Merge functionality
- Transportable tablespaces (including cross-platform)
- Resumable transactions
Database security
- Privileges
- Roles
- Auditing (new 10g auditing)
- VPD/label security/security policies
Database administration
- Startup/shutdown
- Oracle Database administration tools
  - The data dictionary
  - OEM
  - Grid control
  - Advisors
  - The scheduler
  - Server-generated alerts
  - Resource manager
  - Pertinent DBMS* packages
- Space management
  - Online segment shrink
  - DBMS_REDEFINITION
  - Renaming tablespaces
  - Dropping databases
  - Database cloning
- Introduction to tuning
- Introduction to backup and recovery
  - Recovery manager
  - Data guard
  - Log miner
  - Flashback
    - Flashback version query
    - Flashback transaction query
    - Flashback table and the recycle bin
    - Flashback drop
    - Flashback database
- Upgrading Oracle
  - Upgrade information tool
- Upgrade paths from previous versions
- Migration utility
- Rolling upgrades
- Research, planning, expected downtime, testing, feature usage tracking
Miscellaneous
- Database cloning
Platform specific information
- UNIX
- VMS
- Windows