Oracle SQL Training

Oracle SQL Training Syllabus

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

Book Your Course