Oracle 11g DBA - OCP
Oracle Database 12c: Introduction to SQL Ed 1.1
Audience
- Data Warehouse Administrator
- Developer
- Application Developers
- PL/SQL Developer
- Forms Developer
- System Analysts
- Business Analysts
Required Prerequisites
Familiarity with data processing concepts and techniques, Data processing
Course Topics:
- Retrieving Data using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data from Multiple Tables Using Joins
- Using Subqueries to Solve Queries
- Using the SET Operators
- Managing Tables using DML statements
- Introduction to Data Definition Language
- Introduction to Data Dictionary Views
- Creating Sequences, Synonyms, Indexes
- Creating Views
- Managing Schema Objects
- Retrieving Data by Using Subqueries
- Manipulating Data by Using Subqueries
- Controlling User Access
- Manipulating Data
- Managing Data in Different Time Zones
Oracle Database 11g: Administration Workshop I Release 2
Audience:
- Database Administrators
- Technical Administrator
- Support Engineer
- Technical Consultant
- Java Developers
Course Topics:
- Exploring the Oracle Database Architecture
- Installing your Oracle Software
- Creating an Oracle Database
- Managing the Oracle Database Instance
- Manage the ASM Instance
- Configuring the Oracle Network Environment
- Managing Database Storage Structures
- Administering User Security
- Managing Data Concurrency
- Managing Undo Data
- Implementing Oracle Database Auditing
- Database Maintenance
- Performance Management
- Backup and Recovery Concepts
- Performing Database Backups
- Performing Database Recovery
- Moving Data
- Working with Support
Oracle Database 11g: Administration Workshop II Release 2
Audience:
- Database Administrators
- Technical Administrator
- Support Engineer
- Technical Consultant
Course Topic:
- Core Concepts and Tools of the Oracle Database
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Configuring Backup Settings
- Creating Backups with RMAN
- Restore and Recovery Task
- Using RMAN to Perform Recovery
- Monitoring and Tuning RMAN
- Diagnosing the Database
- Using Flashback Technology I
- Using Flashback Technology II
- Performing Flashback Database
- Managing Memory
- Managing Database Performance
- Managing Performance by SQL Tuning
- Managing Resources
- Automating Tasks with the Scheduler
- Managing Space in Blocks
- Managing Space in Segments
- Managing Space for the Database
- Duplicating a Database