Oracle PL/SQL

Acuity Training Limited
Guildford, Surrey, United Kingdom

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

Course Description:

'' PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. All PL/SQL programs are made up of blocks, which can be nested within each other.

Oracle PL/SQL - 5 days

Learn to:

Describe relational and object relational database concepts
Retrieve, insert, update, and delete data
Use the Single row and Group functions
Retrieve data using additional advanced techniques like using ROLLUP, CUBE, set operators, correlated subqueries and hierarchical queries
Solve problems by using multicolumn subqueries, subqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueries
Use the iSQL*Plus environment
Write scripts to generate script files
Generate reports using iSQL*Plus
Create and maintain database objects
Control transactions
Control data/user access
Use the Oracle9i Single row functions
Use GROUPING SETS and the WITH clause
Use the Oracle9i extensions to DML and DDL statements
Apply techniques in real life simulation
...''

Phone:01483 688488

School Address:

Acuity Training Limited
The Surrey Technology Centre
40 Occam Road
The Surrey Research Park
Guildford
Surrey
GU2 7YG
United Kingdom

Jobs & Resumes: Guildford
Houses & Roommates: Guildford

Lotus 123
Lotus Domino
Lotus Freelance Graphics
Lotus iNotes
Lotus Notes
Mac - Apple Macintosh
Mac OS X Server
Troubleshooting for Mac OS X
Oracle Database Administration
Oracle Discoverer
SQL
Appraisal
Assertiveness
Business Planning
Dynamic Communication
Business Writing
Finance for non-financial managers
Finance for project managers
Influencing

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.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.