sql Server Course Content
Introduction to Oracle Database
- List the features of Oracle Database 11g
- Describe the Process StructuresDiscuss the basic design, theoretical, and physical aspects of a relational database
- Categorize the different types of SQL statements
- Describe the data set used by the course
- Log on to the database using SQL Developer environment
- Save queries to files and use script files in SQL Developer
Preparing the Database Environment
- Identify the tools for Administering an Oracle Database
- Plan an Oracle Database installation
- Install the Oracle software by using Oracle Universal Installer (OUI)
Creating an Oracle Database
- Create a database by using the Database Configuration Assistant (DBCA)
Managing the Oracle Instance
- Setting database initialization parameters
- Describe the stages of database startup and shutdown
- Using alert log and trace files
- Using data dictionary and dynamic performance views
Configuring the Oracle Network Environment
- Configure and Manage the Oracle Network
- Using the Oracle Shared Server architecture
Managing Database Storage Structures
- Overview of table space and data files
- Create and manage table spaces
- Space management in table spaces
Administering User Security
- Create and manage database user accounts
- Grant and revoke privileges
- Create and manage roles
- Create and manage profiles
Managing Data and Concurrency
- Monitor and resolve locking conflicts
Managing Data and Concurrency
- Overview of Undo
- Transactions and undo data
- Managing undo
Managing Data and Concurrency
- Use and manage optimizer statistics
- Use and manage Automatic Workload Repository (AWR)
- Use advisory framework
- Manage Alerts and Thresholds
Performance Management
- Use Automatic Memory Management
- Use Memory Advisors
- Troubleshoot invalid and unusable objects
Backup and Recovery Concepts
- Identify the types of failure that can occur in an Oracle database
- Describe ways to tune instance recovery
- Identify the importance of checkpoints, redo log files, and archived log files
- Overview of flash recovery area
- Configure ARCHIVELOG mode
Performing Database Backups
- Create consistent database backups
- Back up your database without shutting it down
- Create incremental backups
- Automate database backups
- Manage backups, view backup reports and monitor the flash recovery area
Performing Database Recovery
- Overview of Data Recovery Advisor
- Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
Moving Data
- Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
- Explain the general architecture of Oracle Data Pump
- Use Data Pump Export and Import to move data between Oracle databases
Configuring for Recoverability
- Configure multiple archive log file destinations to increase availability
- Define, apply and use a retention policy
- Configure the Flash Recovery Area
- Use Flash Recovery Area
Using the RMAN Recovery Catalog
- Identify situations that require RMAN recovery catalog
- Create and configure a recovery catalog
- Synchronize the recovery catalog
- Create and Use RMAN stored scripts
- Back up the recovery catalog
- Create and use a virtual private catalog
Configuring Backup Specifications
- Configure backup settings
- Allocate channels to use in backing up
- Configure backup optimization
Using RMAN to Create Backups
- Create image file backups
- Create a whole database backup
- Enable fast incremental backup
- Create duplex backup and back up backup sets
- Create a multi section, compressed and encrypted backup
- Report on and maintain backups
Using RMAN to Perform Recovery
- Perform complete recovery from a critical or noncritical data file loss using RMAN
- Perform incomplete recovery using RMAN
- Recover using incrementally updated backups
- Switch to image copies for fast recovery
- Restore a database onto a new host
- Perform Disaster recovery
Using RMAN to Duplicate a Database
- Creating a duplicate database
- Using a duplicate database
Performing Table space Point-in-Time Recovery
- Identify the situations that require TSPITR
- Perform automated TSPITR
Monitoring and Tuning RMAN
- Monitoring RMAN sessions and jobs
- Tuning RMAN
- Configure RMAN for Asynchronous I/O
Storage options for RAC
- 1. RAW devices
- 2. Clustered file system
- 3. ASM