Course Brief

In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level.

Course Description

This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course discusses how to use the regular expression support in SQL. In this course, students use Oracle SQL Developer as the main development tool. SQL*Plus is introduced as an option.

Oracle abase 11g: Administration I

• Exploring the Oracle Database Architecture
• Preparing the Database Environment
• Creating an Oracle Database
• Managing the Oracle Instance
• Configuring the Oracle Network Environment
• Managing Database Storage Structures
• Administering User Security
• Managing Data and Concurrency
• Managing Undo Data
• Implementing Oracle Database Security
• Database Maintenance
• Performance Management
• Intelligent Infrastructure Enhancements
• Backup and Recovery Concepts
• Performing Database Backups
• Performing Database Recovery
• Moving Data

Oracle Database 11g: Administration II

• Database Architecture and ASM
• Configuring for Recoverability
• Using the RMAN Recovery Catalog
• Configuring Backup Specifications
• Using RMAN to Create Backups
• Performing User-Managed Backup and Recovery
• Using RMAN to Perform Recovery
• Using RMAN to Duplicate a Database
• Performing Tablespace Point-in-Time Recovery
• Monitoring and Tuning RMAN
• Using Flashback Technology
• Additional Flashback Operations
• Diagnosing the Database
• Managing Memory
• Managing Database Performance
• Space Management
• Managing Resources
• Automating Tasks with the Scheduler
• Administering the Scheduler