9.11.2008

Administration Part - 1

LESSON 1: INSTALLINGORACLE DATABASE 10

A. Install Oracle Database 10g


LESSON 2: EXPLORING THEORACLE DATABASE 10 ARCHITECTURE

A. Understand Database Architecture

B. Identify Database Object Types
  • Database Object Types
  • Database Object Naming Conventions
C. Recognize the Oracle Instance
  • The System Global Area
  • Background Process Types
D. Understand the User Connection Process
  • The User Connection Process
E. Identify Resources for the DBA
  • Data Dictionary
  • Data Dictionary Views
F. Oracle Enterprise Manager Framework
  • OEM Database Control
  • OEM Grid Control
  • OEM Performance Pages
  • Grid Control Performance Pages

LESSON 3: CREATING A DATABASE

A. Create, Configure, and Delete a Database Using the DBCA
  • Logical Design Planning
  • DBCA Management Options
  • Creating a Database with the DBCA
  • Optimal Flexible Architecture
  • Template Management
  • Common Template Sections
B. Use Client and Administration Tools
  • Database Interfaces
  • SQL*Plus
  • iSQL*Plus

LESSON 4: CONFIGURINGORACLENET SERVICES

A. Examine Oracle Net Services
  • Client-Server Architecture
  • N-tier Architecture
  • Oracle Net
  • Oracle Net Features
  • Oracle Net Layered Architecture

B. Perform Basic Oracle Net Server-Side Configuration
  • The Oracle Listener
  • Listener Management
  • Instructor Edition

C. Perform Basic Oracle Net Client-Side Configuration
  • Name Resolution
  • Name Resolution Methods
  • Host Naming Configuration
  • Local Naming Configuration
  • Connection Issue Troubleshooting
  • Tnsping Utility
  • Oracle Net Logging
  • Oracle Net Tracing
D. Configure Oracle Shared Server
  • Shared Server Architecture
  • Shared Server Connection Process
  • Shared Server Configuration
  • Shared Server Monitoring and Tuning
E. Configure Connect-Time Failover
  • Connect-Time Failover

LESSON 5:USING SQL AND PL/SQL

A.Write Simple SQL SELECT Statements
  • Structured Query Language
  • Types of SQL Commands
  • SQL Query Processing Steps Statement
B. Filter and Sort Data
  • The WHERE Clause
  • The ORDER BY Clause
C.Work with SQL Functions
  • Expressions
  • Single-Row Functions
  • Single-Row Function Types
  • Group Functions
  • Group Function Options
Labels: