Registration From  

Introduction to Oracle 10g  SQL Fundamentals

• Introduction
• Writing SQL SELECT Statements
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Reporting Aggregated Data Using the Group Functions
• Displaying Data from Multiple Tables
• Using Sub queries to Solve Queries
• Manipulating Data
• Using DDL Statements to Create and Manage Tables
• Creating Other Schema Objects
• Managing Objects with Data Dictionary Views
• Controlling User Access
• Manage Schema Objects
• Manipulating Large Data Sets
• Generating Reports by Grouping Related Data
• Managing Data in Different Time Zones

 

Oracle 10g Administration Workshop I

• Installing and Configuring Oracle
• Creating and Managing an Oracle database
• Administering an Oracle database
• Configuring the Oracle Network Environment
• Configuring Shared Servers
• Creating and Managing Database Storage Structures
• Managing Redo Log Files and Control Files
• Managing Schema Objects
• Managing Users, Profiles, Privileges and Roles
• Managing Undo Data and Temporary Segments
• Monitoring and Resolving Lock Conflicts
• Maintaining Database Security
• Monitoring the Performance of the Database
• Loading and Unloading Data
• Backing up and Recovering the Database

 

Oracle 10g Administration Workshop II

• Plan a Disaster Recovery Strategy
• Alter a Database to Archive log and No Archive log Modes
• Online and Offline Backups
• Complete and Incomplete Database Recovery
• Recover a Database from Non-Critical Losses
• Perform Logical Backups with Export and Import Utilities
• Use RMAN to Perform Backups And Restore
• Use Flashback Technology to Recover a Database
• Use Flashback to Recover From User Errors
• Database Corruption
• Load Data into a Database
• Diagnostic Sources
• Use Automatic Database Management
• Monitor and Manage Storage
• Use Automatic Storage Management
• Monitor and Manage Memory
• Control Database Resources Using Resource Manager
• Automate Management Tasks with the Scheduler
• Secure the Oracle Listener
• Globalization Support