Scribd
Upload
316 views2 pages

Course Outline SQL & PL-SQL

This 5-day instructor-led course teaches Oracle SQL and PL/SQL. Students will learn how to write SQL queries to retrieve, manipulate, and manage data in Oracle databases. They will learn DML, DDL, and transaction control SQL statements. Students will also learn how to use PL/SQL to query, manipulate, handle exceptions, and work with cursors. The course is intended for applications designers, developers, database administrators, and end users. At the end of the course students will be able to write SQL and PL/SQL code to perform various tasks in an Oracle database. Each student will receive a course manual to use after the class.

Uploaded by

api-3724182
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
316 views2 pages

Course Outline SQL & PL-SQL

This 5-day instructor-led course teaches Oracle SQL and PL/SQL. Students will learn how to write SQL queries to retrieve, manipulate, and manage data in Oracle databases. They will learn DML, DDL, and transaction control SQL statements. Students will also learn how to use PL/SQL to query, manipulate, handle exceptions, and work with cursors. The course is intended for applications designers, developers, database administrators, and end users. At the end of the course students will be able to write SQL and PL/SQL code to perform various tasks in an Oracle database. Each student will receive a course manual to use after the class.

Uploaded by

api-3724182
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Caribbean

Top Training for Professionals

Oracle SQL & PL/SQL


(5 day Instructor-Led Course)

Course Description
In this hands-on course, you will gain the skills necessary to understand Oracle’s SQL and PL/SQL
languages using SQL*Plus and iSQL*Plus tools. Through extensive hands-on labs, you will learn how
to use SQL commands for DML, DDL, query, and transaction control operations. You will learn
how to retrieve information from multiple tables and to use the Oracle built-in functions. You will
use SQL to insert, update and delete records and maintain existing tables. In
addition, you will use PL/SQL to query and manipulate data, to handle exceptions and work with
cursors. Course topics are applicable to users of Oracle8i and Oracle9i.

Who Should Attend


This course is intended for:
This course is intended for applications designers/developers, end users and database
administrators/operators

Prerequisites
In order to successfully complete this course, students should have:
A background in data processing, relational database concepts and programming is strongly
recommended.

What You Will Accomplish


At the end of the course, students will be able to:
Write basic SQL queries to retrieve desired data from a database
Use DML and DDL statements
Use transaction control statements to commit, rollback and create savepoints
Write advanced queries
Write scripts to do queries and display SQL*PLUS reports
Control access to your database objects
Write a PL/SQL block using all elements of the block structure
Write PL/SQL statements using lexical units, declared variables and assignment statements
Use control structures to loop, branch and jump
Utilize PL/SQL named and user-defined exceptions

What You Will Receive


Each student receives:
a copy of the course manual for post-class reference and review.

Follow-Up Courses
WEB Development with Oracle

Course Outline SQL & PL-SQL.doc


1-1

Top Training For Professionals


Aruba: +297-5887296, Suriname: +597-465385, Curaçao: +5999-7672945
Caribbean
Top Training for Professionals

Course Outline: Oracle SQL & PL/SQL

Write Basic Queries using SQL Apply SQL*Plus to access an Oracle Database
Select data from a database Start SQL*Plus
Apply conditions to the selected data Connect to and disconnecting from a
Order the selected data database
Use HOST and SPOOL command
Use DML and DDLStatements to Manipulate
Data Use SQL*Plus Commands to Format Database
INSERT and UPDAT data into an existing table Output
DELET records from an existing table Format column commands
CREAT a table Create and using variables
ALTER the structure of a table Use substitution variables
DROPP a table Develop and using scripts
Use substitution variables Design reports

Work with Transaction Control Statements Understand PL/SQL and using Basic Programming
Utilize COMMIT Tools
Use ROLLBACK and SAVEPOINT Determine PL/SQL capabilities
Work with PL/SQL block structure
Implement Advanced Queries Examine lexical units
Use pseudo columns Make variable declarations
Group data
Use CONNECT by Use Program Control Tools
Work with functions Implement conditional control – branching
Incorporate nested queries Examine iterative control – looping
Select data from multiple tables
Handle PL/SQL Errors and Using Cursors
Create other Database Objects and Controlling Manage Oracle and user-defined exceptions
Database Access Define cursor attributes
Apply sequences, views and indexes Work with cursor records and parameters
Use the data dictionary to obtain information Use a cursor FOR loop
about database objects
Create synonyms
Develop, grant and revoke database
privileges

Course Outline SQL & PL-SQL.doc


2-2

Top Training For Professionals


Aruba: +297-5887296, Suriname: +597-465385, Curaçao: +5999-7672945

You might also like