Session 1: INTRODUCTION
- Oracle product overview
- Oracle Support services
- Relational database concepts
- Oracle architecture
- Database administration tasks
- Database administrators responsibilities
Session 2: INSTALLATION & CONFIGURATION OF AN ORACLE DATABASE
- 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)
Session 3: ADMINISTER A DATABASE
- Administrative tools available to a DBA
- Use SQL*Plus and iSQL*Plus 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
Session 4: CONFIGURE THE ORACLE NETWORK ENVIRONMENT
- 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
Session 5: MANAGE AN ORACLE INSTANCE
- Oracle instance
- 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
Session 6: DATABASE STORAGE STRUCTURES
- 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
Session 7: MANAGE USERS
- Database administration accounts
- User accounts
- Create and administer user accounts
- Lock and unlock user accounts
- Change a user's password
- Administer privileges and roles
Session 8: MANAGE SCHEMA OBJECTS
- 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
Session 9: BACK UP, RECOVER AND RESTORE A DATABASE
- 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
Session 10: PERFORMANCE MONITORING
- Self-monitoring architecture
- Monitor an Oracle database
- Automatic Workload Repository
- Automatic Database Diagnostics Monitor (ADDM)
- Use the advisors
- Set up notification rules