Welcome

Introduction
Evolution of Oracle Database
Introducing Oracle 10g
What the Course is About

Overview

Features of Oracle 10g
Performance & Scalability
Availability
Security
Grid Computing
Automatic Storage Management
Data Warehousing
Management of Records
Oracle Application Builder
Choice of Development Tools
Different Versions of 10g

Getting Started

Preinstallation Checks
Installation
Post Installation Tasks
Upgrading an Existing Oracle Database
Creating a New Administration Account
Creating a New Database User Account Pt.1
Creating a New Database User Account Pt.2
Loading Data

Creating Database Objects

Overview
Tables Creation
Tables Modification
Dealing with Constraints Pt.1
Dealing with Constraints Pt.2
Removing Tables

Retrieving & Manipulating Data

Overview
Basic Query Construction
Joining Tables
Report Customization
Handling Groups of Data
Data Addition/Modification & Removal
Saving & Discarding Data

Administering & Monitoring Database

Managing Database Settings
Managing Memory
Oracle Shutdown & Start Up
Managing Tablespaces
Freeing Space
Managing Database User Accounts
Schemas/Roles & Privileges
Altering a Password for a User
Dropping a User
Monitoring the Database
Monitoring Performance Issues
Viewing Top SQL
Monitoring Sessions
Viewing System Statistic

Service Availability in 10g EE

Transparent Application Failover in RAC
Recovery from Error Using Flashback
Using Oracle Secure Backup
Database Backups & Recovery
Rebuilding Database Objects Online

Security in 10g EE

Transparent Data Encryption Feature
Using Secure Application Roles
Using Oracle Label Security
Use of Virtual Private Database
Using Fine Grained Auditing

Data Manageability

Management of Large Database
Exploring Cluster Database
Automatic Memory Management Feature
Automatically Managing Undo
Managing ASM Disk Groups
Using the Segment Advisor
Resolving Performance Issues Using ADDM
SQL Tuning & Access Advisor
Using Oracle Data Pump
Advanced Scheduling
Information Lifecycle Management
Managing Enterprise Manager Policies

Data Warehousing

Oracle Warehouse Builder
Working with Flat File Data
Designing Relational Target Warehouse
Designing ETL Data Flow Mappings
Deploying Objects in Target Warehouse
Inter-Row Calculations
Filling Gaps in Sparse Data
High Speed Data Loading
ETL Infrastructure
Using Basic Warehousing Functionality
Using Materialized Views

Application Development

Using Oracle Application Express
Adding PL/SQL Functionality
Creating a .NET Application
Creating an Application Using PHP

 

Oracle 10g

 

Oracle 10g is a database that runs on Linux, Unix and Windows servers. Oracle Database 10g can be used to automate administrative tasks, providing security and regulatory compliance features, and enabling the highest availability with Real Application Clusters. In this VTC tutorial you will install and configure an Oracle 10g database, as well as review several programming choices to work with your database. To begin learning today simply click the links.

Get Oracle certification!

 

oracle 10G

oracle 10G

$39.00 – Buy now! Excluding 4% tax

Featured FREE Resource:

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close