Understanding Oracle RDBMS

Course ID

31030

Course Description

This high-level course helps participants understand the components that comprise the Oracle Relational Database Management System (RDBMS). RDBMS concepts and database administration responsibilities are also covered. Topics in this course are: understanding relational databases, Oracle architecture, Oracle products, DBA responsibilities, and SQL.

Prerequisites

There are no prerequisites to this course.

Audience

An effective Oracle training plan begins with this course.
  • End Users
  • Support Staff
  • Managers

Course Content

    Understand Relational Databases
  • Relational Database Concepts
  • Relational Terminology
  • Oracle Relational Database Management System
  • SQL, SQL*Plus, and PL/SQL

    Oracle Architecture
  • Memory Structures
  • Physical Structures
  • User Process
  • Server Process
  • Client/Server Connections

    Oracle Products and Tools
  • Development Tools
  • Database Administration
  • Data Management Tools
  • Backup and Recovery Concepts

    Database Administrator Responsibilities
  • Security Administration
  • Network Administration
  • Data Administration
  • Backup and Recovery Administration
  • Data Integrity
  • Data Availability

    Query Fundamentals
  • Using SQL*Plus
  • SELECT Command
  • SELECT DISTINCT
  • Display Tables Structures
  • SQL*Plus Command Summary
  • SQL Command Summary

    Conditions, Expressions and Operators
  • The WHERE Clause
  • Comparison Operators
  • SQL Operators
  • Logical Operators
  • Negating Operators

    Single Row Functions
  • The Concatenation Operator
  • Literal Character String
  • Character Functions
  • Number Functions
  • Using Arithmetic Operators with Dates
  • Date Functions

    Group Functions
  • GROUP Function
  • GROUP BY Clause
  • The Where Clause

    Manage and Format Output
  • The ORDER BY Clause
  • Configure the Session Environment
  • Format Output
  • Format Headings
  • Add Titles

    Manage Script Files
  • Create/Execute Script Files
  • Call an External Editor
  • SPOOL Output
  • Interact with the Operating System

    Subqueries
  • Processing Subqueries
  • Single/Multiple Row Subqueries
  • Errors with Subqueries

    Customize Queries Using Variables
  • Substitution Variables
  • Single Ampersand Substitution Variables
  • Passing Values into Script Files
  • Accept Session Variables

    Oracle Data Dictionary
  • Data Dictionary Views
  • Display Dictionary Views

    Manipulate Table Data
  • UPDATE Command
  • INSERT Command
  • DELETE Command

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 3 days
Price - $1895.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.