PREREQUISITES: SQL and PL/SQL or comparable experience is required.
WHO SHOULD ATTEND? Oracle database administrators will benefit from this course.
COURSE DESCRIPTION: This course provides a starting point for administration of the Oracle database. The first 2-day segment considers an in-depth discussion of the database architecture, including installing the Oracle software, creating an Oracle database, the Oracle instance, background processes, the SGA and memory structures,. The remaining 3 days cover common administration tasks such as managing the use of disk space through data files, tablespaces, extents, blocks and rows, security, backup & recovery; Oracle network management and configuration, understanding the Oracle self-tuning database approach, background processes and the Enterprise Manager Database Control web interface. User creation and management through grants, roles and profiles is covered. The Oracle data utilities SQL*Loader, Import data pump and Export data pump are described. Finally an overview of backup and recovery concepts is given. If time permits, an optional chapter on monitoring and resolving lock conflicts is presented.
BENEFITS OF ATTENDANCE: The student will be able to:
Install, startup and shutdown an Oracle database
Explain the internal architecture of data, memory and process structures
Administer a security policy for the database
Control physical storage of tables and indexes
Build and modify efficient databases
Use Oracle Enterprise Manager Database Control for common tasks, including SQL tuning
Configure basic backup & recovery strategy
COURSE OUTLINE
CHAPTER 1: THE ORACLE DATABASE ENVIRONMENT
1) Application Architectures
2) The Oracle Database
3) Components of a Database
4) Instance Configurations
5) About the Administration Tool
CHAPTER 2: ORACLE INSTALLATION
1) Installing Oracle
2) Pre-Installation Tasks
3) Post-Installation Tasks
4) Understanding Oracle's Optimal Flexible Architecture (OFA)
CHAPTER 3: DATABASE CREATION
1) Database Creation using Database Creation Assistant (DBCA)
2) Managing databases using DBCA
CHAPTER 4: PROCESSING TRANSACTIONS
1) Parameters That Determine SGA Size Instance & User Processes
2) Instance Background Processes
3) SQL Execution Processes
CHAPTER 5: INSTANCE STARTUP & SHUTDOWN
1) Database Startup
2) Database Shutdown
3) Restricted Sessions
4) Database Files
CHAPTER 6: MANAGE DATABASE STORAGE
1) Datafiles
2) Tablespaces
3) Locally managed vs. dictionary managed tablespaces
4) Segments and objects
5) Extents
6) Database blocks
CHAPTER 7: MANAGING USERS
1) User Management
2) About Privileges
3) Resource Limits via Profiles
4) Password Management via Profiles
CHAPTER 8: MANAGING DATABASE CONSTRAINTS
1) Primary key constraints
2) Foreign key constraints
3) Unique constraints
4) Check and non null constraints
CHAPTER 9: MANAGING TABLE DATA
1) The Oracle SQL Loader utility
2) The Oracle Import Data Pump utility
3) The Oracle Export Data Pump utility
CHAPTER 10: PL/SQL CONSTRUCTS
1) Using database triggers
CHAPTER 11: DATABASE SECURITY
1) User security
2) Grants and roles
3) Using the Oracle audit trail
4) Auditing in the database
5) Auditing in the file system
CHAPTER 12: ORACLE NETWORK SERVICES
1) Understanding Oracle NET
2) Managing TNS connections
3) Managing "EZ" connections
CHAPTER 13: ORACLE SHARED SERVER
1) Understanding shared server architecture
2) Required parameter settings to use shared servers
3) Configuring and managing shared servers
CHAPTER 14: PERFORMANCE TUNING, PROACTIVE MONITORING AND MAINTENANCE
1) The Oracle tuning architecture
2) Understanding Automatic Database Diagnostic Monitor (ADDM)
3) Understanding Automatic Workload Repository (AWR)
4) How Oracle collects and utilizes statistics
CHAPTER 15: SELF-MANAGING DATABASE
1) Using OEM SQL Tuning Advisor
2) Using OEM SQL Access Advisor
3) Tuning materialized views
CHAPTER 16: SPACE MANAGEMENT
1) Exploring the physical storage hierarchy
2) Managing the data files
3) Managing tablespaces
4) Managing segments
5) Managing database blocks
CHAPTER 17: ORACLE BACKUP AND RECOVERY
1) Backup and recovery concepts
CHAPTER 18: DATABASE BACKUPS
1) Performing a full, cold backup
2) Understanding hot backups
CHAPTER 19: DATABASE RECOVERY
1) Performing a full complete recovery
2) Understanding partial and point-in-time recovery
