Cynosure Knowledge Solutions

Part 1

Installing Oracle Database 10g

· Install Oracle Database 10g

Exploring the Oracle Database 10g Architecture

· Understand Database Architecture

· Identify Database Object Types

· Recognize the Oracle Instance

· Understand the User Connection Process

· Identify Resources for the DBA

Creating a Database

· Create, Configure, and Delete a Database Using the DBCA

· Use Client and Administration Tools

Configuring Oracle Net Services

· Examine Oracle Net Services

· Perform Basic Oracle Net Server-Side Configuration

· Perform Basic Oracle Net Client-Side Configuration

· Configure Oracle Shared Server

· Configure Connect-Time Failover

Using SQL and PL/SQL

· Write Simple SQL SELECT Statements

· Filter and Sort Data

· Work with SQL Functions

· Work with Multiple Tables

· Modify Data

· Control Database Transactions

· Explore PL/SQL

Managing the Database Instance

· Obtain Instance Information

· Manage the Database Instance

· Organize Database Objects

· Describe Database Objects and Their Storage

Managing Tablespaces and Datafiles

· Manage Tablespaces

· Find Tablespace and Datafile Information

· Resize and Drop Tablespaces

· Configure Oracle Managed Files

Managing Tables and Indexes

· Create Tables

· Gather and Analyze Table Information

· Create Indexes

· Implement Integrity Constraints

· Maintain Integrity Constraints

Creating Views and Sequences

· Create Views

· Create Sequences

Managing Users and Security

· Manage Users

· Manage Privileges and Roles

· Manage Passwords and Resource Limits

· Audit Database Usage

Monitoring Performance

· Manage Locks

· Gather and Use Tuning and Troubleshooting Information

Loading and Unloading Data

· Manage Data Using the Data Pump

· Move Tablespaces

· Load Data Using SQL*Loader

· Create and Access External Tables

Managing Undo Data

· Configure Undo Segments and Tablespaces

· Understand Automatic Undo Retention

Administering and Performing Backups

· Create Redo Log Groups and Members

· Plan and Configure the Online Redo Log Group

· Manage and Maintain Control Files

· Back Up the Database

· Examine Recovery Manager Concepts

Administering and Performing Recovery Operations

· Manage Recovery

· Employ User-Managed and RMAN Recovery

· Tune Database Recovery

Part 2

Monitoring the Database

· Diagnose Issues Using Trace Files and the Alert Log

· Adjust Thresholds for Tracked Metrics

· Secure the Listener

Monitoring and Managing Memory

· Manually Configure SGA Parameters for Various Memory Components

· Using Automatic Shared Memory Management

· Configure Automatic PGA Memory Management

Monitoring and Managing Database Performance

· Improve Database Performance Using the SQL Tuning Advisor

· Manage Resources

· Tune Redo Log and Archive Log Operations

Monitoring and Managing Storage

· Manage Tablespace Usage

· Reclaim Wasted Space from Tables and Indexes

· Estimate the Size of New Tables and Indexes

· Improve Query Performance Using Different Storage Options

· Rebuild Indexes Online

Restoring Data With Oracle Flashback

· Recovering Data Using Flashback Technology

· Flashback the Database Using the OEM Recovery Wizard

· Maintaining the Flash Recovery Area

· Using Automatic Undo Retention Tuning

Backing Up and Recovering Data

· Recover Tablespaces and the Password File

· Perform Incomplete Recoveries

· Perform Database Recovery Through a RESETLOGS Operation

· Detect Database Corruption

Configuring the Recovery Manager (RMAN)

· Recovery Manager

· Configure the RMAN Environment

Performing RMAN Backups

· Create RMAN Image Copies

· Conduct RMAN Online Backups

· Conduct RMAN Incremental Online Backups

· Back Up Archive Logs

· Manage RMAN Backups

Performing RMAN Recoveries

· Perform an RMAN Complete Recovery

· Perform an RMAN Incomplete Recovery

· Repair Block Corruptions Using RMAN

Utilizing Automatic Storage Management (ASM)

· Automatic Storage Management

· Set up Initialization Parameters and Start an ASM Instance

· Administer ASM Disk Groups

· Migrate Your Database to ASM Using RMAN

Automating Tasks with the Scheduler

· Simplify Management Tasks by Using the Scheduler

· Reuse Scheduler Components for Similar Tasks

· View Information About Job Executions and Job Instances

Using Globalization Support Objectives

· Obtain Globalization Support Configuration Information

· Customize Language-Dependent Behavior

· Specify Different Linguistic Sorts for Queries

· Use Datetime Datatypes

· Query Data Using Case-Insensitive and Accent-Insensitive Sorting

Oracle Database 10g - Introduction to SQL

Relational Databases & SQL

· About Relational Databases

· Elements Of SQL

Using SQL*Plus

· About SQL*Plus

· Using The Ms Windows SQL*Plus Tool

· Using The Isql*Plus Web Tool

· Entering Commands & Syntax

Building A Select Statement

· About The Select Statement

· Selecting Columns

· Using Alias Names

Building A Where Clause

· About Logical Operators

· Equality Operator

· Boolean Operators

· Null & Between Operators

· Finding Text Strings

· In Operator

Ordering The Result Table

· About The Order By Clause

· Multiple Column Sorts

· Specifying The Sort Sequence

· About Null Values Within Sorts

· Using Column Aliases

Pseudo Columns & Functions

· About Pseudo Columns & Functions

· Using Rowid

· Using Rownum

· Using The Functions

· Using The Dual Table

· Sessiontimezone Function

Joining Tables

· About Joins

· Inner Join

· Reflexive Join

· Non-Key Join

· Outer Join

Using Set Operators

· About The Set Operators

· Set Operator Examples

Summary Functions

· About Summary Functions

· Summary Functions With Distinct

Using Subqueries

· About Subqueries

· Standard Subqueries

· Correlated Subqueries

Creating & Selecting Groups

· About Summary Groups

· Finding Groups Within The Base Tables

· Selecting Data From The Base Tables

· Selecting Groups From The Result Table

SQL*Plus Commands

· About SQL*Plus Commands

· More About Script Files

· Invoking Operating System Commands

· Saving Session Output

Build Simple SQL*Plus Reports

· About The SQL*Plus Report Features

· Session Output With Set

· Format Column Output With Column

· Defining Report Breaks With Break

· Produce Subtotals With Compute

SQL Data Definition Language

· About SQL Ddl

· Create Table Statement

· Alter Table Statement

· Drop Table Statement

· Supportive Statements

SQL Data Manipulation Language

· About SQL Dml

· About The Insert Statement

· About The Delete Statement

· About The Update Statement

· About Transactions

· Truncate Table

· Complex Table References

SQL99 Join Techniques

· About Ansi/Iso SQL99

· Cross Joins

· Natural Joins

· Inner Joins

· Outer Joins

· Antijoins

· Using Named Subqueries

Enhancing Groups With Rollup & Cube

· About Enhanced Group Processing

· Using Rollup

· Using Cube

Using The Case Expression

SQL Functions (Character)

· What Are The SQL Functions?

· Character Functions

SQL Functions (Non-Character)

· Numeric Functions

· Date Format Functions

· Date Arithmetic Functions

· Null Value Functions

Database Objects: Relational Views

· About Database Objects

· About Relational Views

· Updating View Data

· Maintaining View Definitions

Database Objects: Data Dictionary Storage

· About The Data Dictionary

· Object-Specific Dictionary Views

· Understanding The Data Dictionary Structure

Database Objects:

· Indexes

Database Objects: Other Objects

· Creating An Application Schema

· More About Creating Tables

· Defining Sequences

· About Synonyms

· Create Schema Authorization

Database Security

· About Database Security

· User Id Passwords

· Object Security

Data Integrity Using Constraints

· About Constraints

· Not Null Constraint

· Check Constraint

· Unique Constraint

· Primary Key Constraint

· References Constraint

· Defining Constraints On Existing Tables

Maintaining Constraint Definitions

· Maintaining Constraints

· Renaming & Dropping Constraints

· Enabling & Disabling Constraints

· Validate New Transactions Only

· Deferred Enforcement

· Managing Constraint Exceptions

· Constraints And Views

· Data Dictionary Storage

Advanced SQL*Plus Reports

· About The Report Commands

· Break

· Compute

· Column

· Ttitle & Btitle

Building SQL*Plus Scripts

· About Script Files

· Using SQL*Plus Variables

· Accept

· Prompt

· Pause