|
Provided by: Serebra Learning Corporation Oracle 8i PL/SQL - Adv SQL, SQL *Plus & Data DictionaryOracle PL/SQL |
 |
In this course you will learn to create subqueries and queries using SET operators. The course describes the SQL *PLUS file commands and SET commands that are used to customize the SQL *PLUS environment. Furthermore the course discusses the SQL *Plus format commands and script files. The concept of data dictionary tables and views is also covered in the course. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL.
|
|
||||||||||
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:
Topics Include
Unit 1: Subqueries
- Subqueries: Overview
- Single and Multiple Row Subqueries
- Nested Subqueries
- Multiple Column Subqueries
- Subqueries with Comparison Operators
- Set Operators
Unit 2: SQL *Plus Commands
- SQL *Plus File Commands
- Formatting using SQL *Plus SET Commands
- Controlling Display using SQL *Plus SET Commands
Unit 3: Creating Reports
- SQL *Plus Format Commands
- Script Files
- Substitution Variables
Unit 4: Data Dictionary
- Oracle Data Dictionary Views
- Querying Oracle Data Dictionary
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
