Duration: 5 Days
In this class, you will learn how to install and maintain an Oracle database.
You will gain a conceptual understanding of the Oracle database architecture and
how its components work and interact with one another. You will learn how to
create an operational database and properly manage the various structures in an
effective and efficient manner, including performance monitoring, database
security, user management, and backup/recovery techniques. Hands-on exercises
reinforce the material covered. This course is designed to prepare you for the
Oracle Certified Associate exam.
What You Will Learn
- Install and configure the Oracle 10g database
- Create and administer user accounts in the Oracle 10g database
- Backup and recover the database
- Monitor, troubleshoot, and maintain the database
- Configure Oracle Net services for the database
Audience
Database administrators, support engineers, technical consultants, systems
administrators, network managers and technical support personnel
Prerequistes
- Knowledge of SQL, Introduction to Oracle 10g SQL and SQL* Plus, or equivalent
experience
- Introduction to Oracle 10g PL/SQL or equivalent experience is highly
recommended
Course Outline
1. Introduction
- Basic concepts of a relational database
- Core database administrator tasks
2. Installing Oracle Database 10g Software
- System requirements
- Use optimal flexible architecture
- Install software with the Oracle Universal Installer
3. Create an Oracle Database
- Oracle database architecture
- Instance architecture
- Use the management framework
- Database Creation Assistant
4. Database Interfaces
- Use structured query language (SQL)
- Procedural Language/Structured Query Language (PL/SQL)
- Java
- Oracle C++ Call Interface (OCCI)
5. Controlling the Database
- Start and stop the agent
- Enterprise manager database console
- Listener
- Start up and shut down the database
6. Storage Structures
- Purpose of tablespaces and data files
- Create and manage tablespaces
- Use Oracle Managed Files (OMF)
- Obtain tablespace information
7. Administering Users
- Create and manage database user accounts
- Manage roles
- Grant and revoke privileges
- Control resource usage by users
8. Managing Schema Objects
- Create and modify tables, indexes, and views
- Define constraints
- View the attributes and the contents of a table
9. Managing Data
- Manipulating data through SQL
- Import
- Export
- Data pump
- SQL Loader
10. PL/SQL
- PL/SQL objects
- Triggers and triggering events
- Configuration options that affect PL/SQL performance
11. Oracle Database Security
- Principal of least privilege
- Manage default user accounts
- Implement standard password security features
- Audit database activity
12. Oracle Net Services
- Oracle Net concepts
- Use Oracle Net Manager to create and configure listeners
- Configure client and middle-tier connection
- Use the listener control utility to control the Oracle Net Listener
- Use TNSPING to test Oracle Net connectivity
13. Oracle Shared Server
- When to use Oracle Shared Servers
- Configure and monitor Oracle Shared Servers
14. Performance Monitoring
- Troubleshoot invalid and unusable objects
- Gather optimizer statistics
- View performance metrics
- React to performance issues
15. Proactive Maintenance: Objectives
- Set warning and critical alert thresholds
- Collect and use baseline metrics
- Tuning and diagnostic advisors
- Automatic Database Diagnostic Monitor (ADDM)
- Manage the automatic workload repository
16. Undo Management
- Monitor and administer undo information
- Configure and guarantee undo retention
- Use the undo advisor
17. Monitoring and Resolving Lock Conflicts
- Detect and resolve lock conflicts
- Manage deadlocks
18. Backup and Recovery Concepts
- Basics of database backup, restore, and recovery
- Types of failure that may occur in an Oracle Database
- Ways to tune instance recovery
- Importance of checkpoints, redo log files, and archived log file
- Configure ARCHIVELOG mode
19. Database Backups
- Consistent database backups
- Incremental backups
- Automate database backups
- Monitor the flash recovery area
- Back your database up without shutting it down
20. Database Recovery
- Loss of a control file
- Loss of a redo log file
- Loss of a data file
21. A Day in the Life of a DBA
- Daily tasks
- Weekly tasks
- Monthly tasks
- As-needed tasks
Course Labs
Lab 1: Creating an Oracle Database
Lab 2: Starting and Stopping the Database
Lab 3: Using the Database Console
Lab 4. Managing Tablespaces
Lab 5: Oracle Database Files
Lab 6: Using Oracle-Managed Files
Lab 7: Creating Tables, Indexes, and Constraints
Lab 8. Users and Security
Lab 9: Import, Export, Data Pump, and SQL Loader
Lab 10: Oracle Auditing
Lab 11: Oracle Listener
Lab 12: Using Shared Servers
Lab 13: Performance Metrics and Monitoring
Lab 14: The Undo Advisor
Lab 15: Lock Conflict Identification
Lab 16: Configuring the Database for Backup
Lab 17: Basic Database Media Recovery
