SQL, PL/SQL, and SQL*Plus

ExecuTrain
Alpharetta, Georgia, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' In this course, you will examine the use of SQL, PL/SQL, and SQL*Plus, filter and sort data, use built-in SQL functions, create and modify tables and constraints, create and use database objects, use PL/SQL control structures, process cursors in PL/SQL, develop procedures and functions with runtime exceptions, develop Oracle packages, create Oracle triggers, and work with collections of data.

Objectives:
After completing this course, you will be able to use SQL, PL/SQL, and SQL*Plus, use SQL*Plus commands to filter and sort data, use built-in SQL functions, work with multiple tables, create and modify tables and constraints, create and use other database objects, build PL/SQL blocks, use PL/SQL control structures, process cursors in PL/SQL, handle runtime exceptions, develop procedures and functions, develop Oracle packages, create Oracle triggers, and work with collections of data.
Hardware and Software Required:
Browser Netscape Communicator 4.0
Browser Other: AOL 4.0
Operating System MacOS 8.5
Browser Microsoft Internet Explorer 4.0
Operating System MS-Windows 95

Table of Contents:

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus

Introduction to SQL*Plus and iSQL*Plus

Introduction to SQL

Introduction to PL/SQL

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: SQL*Plus Commands

Using SQL*Plus for Editing

Using SQL*Plus to Work with Files

Using SQL*Plus for Formatting Output

Using SQL*Plus Variables

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: Filtering and Sorting Data

WHERE Clause

ORDER BY Clause

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: SQL Functions

Expressions in a SELECT Statement

Single-row Functions

Group Functions

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: Working with Multiple Tables

Joins

Subqueries

Set Operators

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: Tables and Constraints

Creating and Modifying Tables

Integrity Constraints

Managing Data in Tables

Transaction Control Language Statements

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: Other Database Schema Objects

Sequences, Synonyms, and Indexes

Views

Database Object Security

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: Building PL/SQL Blocks

Creating PL/SQL Blocks

Manipulating Data in PL/SQL

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: PL/SQL Control Structures

Conditional Control Structures

Iterative Control Structures

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: Cursors

Introduction to Cursors

Implicit Cursors

Explicit Cursors

Cursor Loops

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: Exception Handling

Introduction to Exception Handling

Types of Exceptions

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: Procedures and Functions

Developing Procedures and Functions

Passing Parameters

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: Oracle Packages

Developing Packages

Oracle-supplied Packages

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: Oracle Triggers

Building a Trigger

Trigger Restrictions

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus: PL/SQL Collections

Defining and Using Collections

Collection Methods


...''

Phone:1-800-908-7246

School Address:



Jobs & Resumes: Alpharetta
Houses & Roommates: Alpharetta

Creating and Managing Controls with Visual C# .NET
Object-Oriented Programming
MCSD
DHTML
E-Business: Fundamentals of E-Commerce
COM+
HTML
IBM WebSphere Portal
Oracle 9i
Java Programming
J2EE: Web Component Development
Java 2: Using IBM VisualAge to Create Java Applications
Java 2: Advanced Programming
JSP: Basic Website Development
Oracle Database 10g
Perl/CGI
PHP 4
Domino R5 Application Development

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!