Session 1: INTRODUCTION TO ORACLE DATABASE 11g
- Relational database concepts
- Database administration tasks
- DBA responsibilities
Session 2: ORACLE DATABASE 11g ARCHITECTURE
- Oracle database architecture
- The Oracle instance
- Memory structures
- Background processes
- Server and client processes
- The Oracle database
- Overview of Oracle ASM architecture
Session 3: INSTALLATION AND CONFIGURATION OF AN ORACLE DATABASE
- System Hardware Requirements
- Optimal Flexible Architecture
- Authentication methods for a database
- Oracle environment variables
- Install Oracle software using the Oracle Universal Installer (OUI)
- Silent Install
- Use the database Configuration Assistant (DBCA)
- Create a database with DBCA
- Manage a database with DBCA
- Delete a database with DBCA
- Manage Templates using DBCA
Session 4: ADMINISTER A DATABASE INSTANCE
- Administrative tools available to a DBA
- Using SQL*Plus in Oracle to manage a database
- Administer the database using Enterprise Manager (EM)
- Start and stop the EM Database Console
- Access EM
- EM navigation
- Grant EM administrative privileges to a user
- Overview of Oracle Restart
Session 5: 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
- Use Enterprise Manager to create and configure the Listener
- Configure client connections with Net Manager
- View listener configuration
- Start and stop the Oracle listener
- Enable Oracle Restart to monitor the listener
- Use TNSPING to test Oracle Net connectivity
- Connect to the database
- Configure Net Services with Enterprise Manager
- Overview of Dedicated Server architecture
- Overview of Shared Server architecture
- Identify when to use Shared Servers and when to use Dedicated Servers
Session 6: MANAGE AN ORACLE INSTANCE
- Access an Oracle database
- Database authentication methods
- Password file
- The Startup Process
- The Shutdown Process
- Initialization parameters
- Shutdown a database and instance using SQL and EM
- Startup a database and instance using SQL and EM
- View alert log and trace files
- View or modify initialization parameters with EM
Session 7: TABLESPACE AND DATAFILE MANAGEMENT
- Overview of tablespaces and datafiles
- Use EM to view the storage structure of the database
- Create and alter tablespace commands
- Locally managed tablespaces
- Dictionary managed tablespaces
- Bigfile tablespaces
- Temporary tablespaces
- Multiple temporary tablespaces
- Create tablespaces
- Manage tablespaces
- Use standard and non-standard block sizes
- Create and manage tablespaces using OMF
- Drop tablespace command
Session 8: MANAGE REDO LOGS
- Redo log overview
- Plan redo logs
- Redo log data dictionary tables
- Log switches and checkpoints
- Log file maintenance
- Add and drop log file members and groups
- Clear a log file
- Move or rename an online redo log file
- Multiplex redo log files
- Use EM to manage redo logs
- Manage online redo log files with OMF
- List redo log information
Session 9: MANAGE CONTROL FILES
- The usage of the control file
- The contents of a control file
- Manage control files
- Replace a lost or damaged control file
- Mirror a control file
- Standby control file
- Manage control files with OMF
- List control file information
Session 10: MANAGE SCHEMA OBJECTS
- Create a new table
- View the attributes and contents of a table
- Understand data integrity
- Define constraints
- Alter tables
- Create indexes
- View index attributes
- Create views
- Create and use sequences
Session 11: MANAGE USERS
- Database administration accounts
- User accounts
- Create a user account
- Operating system authentication
- Change a user's password
- Manage a user account
- Drop a user account
- Monitor user information
- Terminate user sessions
- Product user profiles
Session 12: MANAGE PROFILES AND RESOURCES
- Overview of user profiles
- Profile resource parameters
- Create profile command
- Manage passwords with profiles
- Control resource usage with profiles
- Maintain profiles
- Drop profiles
Session 13: MANAGING PRIVILEGES
- Database access
- Oracle supplied roles
- System level privileges
- Object level privileges
- The grant and revoke commands
- Create roles
- Modify and drop roles
- Control the availability of roles
- Use predefined roles
- Synonyms
- Listing valid grants
Session 14: DATABASE AUDITING
- Overview of database auditing
- Auditing SYS statements
- Auditing end user sessions
- Statement auditing
- Privilege auditing
- Auditing modifications made to database objects
- Audit table relocation
- Auditing from Enterprise Manager
Session 15: UNDO MANAGEMENT
- Undo data overview
- Monitor and administer undo
- Configure undo retention
- Switch undo tablespaces
- Specify the retention period
- Guarantee undo retention
- Retention period for flashback queries
- View undo space information
- Use the undo advisor
- Size the undo tablespace
- Manage undo with EM
Session 16: MOVING DATA
- Create directory objects
- Data Pump Export and Import
- Data Pump architecture
- Data Pump data dictionary views
- Data Pump interactive mode
- Data Pump API
- Use Data Pump to export data
- Use Data Pump to import data
- SQL Loader
- Overview of SQL Loader
- Command line parameters
- Record filtering
- Control file keywords
- Datafiles
- SQL Loader data paths
Session 17: OVERVIEW OF MANAGING AN ASM INSTANCE
- Overview of Automatic Storage Management
- ASM Storage Components
- Set up initialization files for an ASM instance
- Startup and Shutdown ASM Instances
- Administer ASM disk groups
- Administer ASM Files
Session 18: DATA CONCURRENCY AND LOCK CONFLICTS
- Levels of locking in Oracle
- Methods used to acquire locks
- Possible causes of contention
- Deadlocks
- Prevent locking problems
- Detect lock contention
- Resolve conflicts in an emergency
Session 19: PROACTIVE DATABASE MAINTENANCE
- Self Monitoring Architecture
- Automatic Workload Repository
- Automatic Database Diagnostic Monitoring
- Monitor an Oracle database
- Use the Advisors
- Set up notification rules
Session 20: PERFORMANCE MANAGEMENT
- Tuning information sources
- Identify unusable objects
- Optimizer Statistics collection
- Automated statistics collection
- Performance metrics
- Use the advisors
- React to performance issues
Session 21: BACKUP AND RECOVERY CONSIDERATIONS
- Oracle Backup solutions
- Overview of Oracle Secure Backup
- Oracle Suggested Backup Strategy
- Database backup, restore and recover
- Types of failure
- Tune instance recovery
- Checkpoints, redo log files and archive log files
- Alter the ARCHIVELOG mode of a database
- Configure a database for recoverability
Session 22: DATABASE BACKUPS
- Types of RMAN backup
- Backup sets and image copies
- Perform backups using EM
- Automate database backups
- Configure backup settings
- Catalog settings
- Monitor the flash recovery area
- Manage backups
Session 23: DATABASE RECOVERY
- Restore and recovery operations
- Recover an entire database from backup
- Recover from the loss of a system critical data file
- Recover from the loss of a control file
- Recover from the loss of a redo log file
- Data Recovery Advisor
Session 24: ENHANCE THE CAPABILITIES OF THE DATABASE
- Enterprise Manager Support Workbench
- Register for security updates
- Work with Oracle support
- Log Service Requests
- Manage patches