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