Introduction (6 topics)
- Oracle product overview
- Oracle Support services
- Relational database concepts
- Oracle architecture
- Database administration tasks
- Database administration tools
Installing and Configuring an Oracle Database (6 topics)
- Understand system requirements
- Use Oracle Universal Installer to install Oracle software (OUI)
- Create a database using Database Configuration Assistant (DBCA)
- Delete a database using DBCA
- Use DBCA to manage templates
- Upgrade a database using Database Upgrade Assistant (DBUA)
Administer a Database (6 topics)
- Administrative tools available to a DBA
- Use SQL*Plus and SQL Developer to manage a database
- Administer the database using Enterprise Manager (EM)
- Start and stop the EM Database Console
- EM navigation
- Grant EM administrative privileges to a user
Configure the Oracle Network Environment (9 topics)
- Overview of network configuration
- Oracle Net Listener configuration and management
- Oracle Net Naming methods
- Tools for configuring and managing the Oracle network
- Configure local naming for client connections with Net Manager
- Start and stop the Oracle listener
- Configure the listener with EM
- Use TNSPING to test Oracle Net connectivity
- Connect to the database
Oracle Instance (9 topics)
- Instance management
- Memory structures
- Background processes
- Access an Oracle database
- Initialization parameters
- Password file
- Shutdown the database
- Startup the database
- View alert log and trace files
Database Storage Structures (8 topics)
- Oracle database structures
- Control files
- Redo log and archive redo log files
- Tablespaces and data files
- Create tablespaces
- Manage tablespaces
- Manage undo and use the Undo Advisor
- Use EM to view the storage structure of the database
Manage Users (6 topics)
- Database administration accounts
- User accounts
- Create and administer user accounts
- Lock and unlock user accounts
- Change a user’s password
- Administer privileges and roles
Manage Schema Objects (10 topics)
- Create schema objects
- Create a new table
- View the attributes and contents of a table
- Understand data integrity
- Define constraints
- Create indexes
- View index attributes
- Create views
- Create synonyms
- Create sequences
Backup, Recover and Restore a Database (10 topics)
- Oracle backup strategy
- Overview of backup, restore and recovery
- Backup and recovery configuration
- Configure ARCHIVELOG mode
- Backup and recover the database using EM
- Schedule backups
- Configure backup settings
- Configure recovery settings
- Configure catalog settings
- Perform recovery
Performance Monitoring (7 topics)
- Self-monitoring architecture
- Monitor an Oracle database
- Automatic Workload Repository
- Automatic Database Diagnostics Monitor (ADDM)
- Use the advisors
- Set up notification rules
- Conclusion