Custom Search
Home > Computer > Databases and SQL > Serebra Learning Corporation > Oracle8i PL/SQL > Oracle 8i PL/SQL - Functions, Tables, and Groups
Provided by: Serebra Learning Corporation

Oracle 8i PL/SQL - Functions, Tables, and Groups

Oracle PL/SQL

 Serebra Learning Corporation
Training Provided by Serebra Learning Corporation

This course covers the concepts of single row functions that enable the manipulation of data. The course essentially focuses on three single row functions: character functions number functions and date functions. The course also covers the concept of conversion that enables the conversion of a value from one datatype to another. The concept of retrieving data from more than one table by using join statements is also covered. Additionally the course discusses group functions that operate on sets of rows to give one result. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL.

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Duration:5 hours
Training Presented in:English
Oracle 8i PL/SQL - Functions, Tables, and Groups

Audience

This course is designed for database administrators application developers business analysts designers/developers managers systems analysts and technical support professionals. It will prepare students for the Introduction to Oracle: SQL and PL/SQL Exam.

Prerequisites

The audience of this curriculum should be familiar with RDBMS concepts and Graphical User Interface (GUI).

Objective

Upon completion of this course the student will be able to:

  • Identify the two types of functions in SQL
  • Use the single row (or scalar) function types
  • Use the join statements to display data from multiple tables
  • Operate on sets of rows to derive a summary result using the group (or aggregate) functions

    • Topics Include

    Unit 1: Single Row Functions

    • Character Functions
    • Number Functions
    • Date Functions
    • Nested Single Row Functions

    Unit 2: Conversion Functions

    • TO_CHAR function
    • TO_NUMBER Function
    • TO_DATE Function

    Unit 3: Display Data From Multiple Tables

    • Join Types
    • Simple Join Statements
    • Non-Equijoin
    • Self Joins

    Unit 4: Working With Groups

    • Group Functions
    • GROUP BY Clause
    • Groups Within Groups
    • Invalid Queries
    • HAVING Clause

    Duration

    5 Hours

    Minimum Requirements

    IBM-compatible PC with 166 MHz or higher processor 32 MB RAM (64 MB RAM recommended); 800x600 SVGA color monitor with 16-bit high color display; Internet Explorer 4 or Netscape Navigator 4 or later with Shockwave 7.0.1; Windows 95 Windows 98 Windows NT; 3.5 diskette (for tracking); 28.8 kbps connection or higher for on-line use.

    Media

    CDROM
    Web Based Training

    Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC    V3W 1K5 Canada
    About The Training Provider: Serebra Learning Corporation
    Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
    Click here for more information or to take this course
    Home > Computer > Databases and SQL > Serebra Learning Corporation > Oracle8i PL/SQL > Oracle 8i PL/SQL - Functions, Tables, and Groups
    Advertise With Us
    Do you teach oracle8i pl ?
    This page was last updated on sb5- 08/07/08 at 02:04:15 - 17:30:41