Online BOOKING FORM

View Terms & Conditions

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

Tel: 01483 688488
Fax: 01483 573704
info@acuitytraining.co.uk

Tell a Colleague

Bookmark this site

BlackBerry Logo

Microsoft Certified Application Specialist

Adobe Logo

Oracle PL/SQL Training

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

Please click here for an outline.

Please contact us for more information. One-to-one or group bookings can also be arranged on dates to suit you and customised to your specific requirements. Please give us a call on 01483 688488.

Back to Courses

Training in Access and SQL Server Database, Excel Spreadsheet Training, VBA, Development and Consultancy, Word, PowerPoint, BlackBerry, computer training, it courses, solutions, education, bespoke, graphics, microsoft, sage, SharePoint, Office 2007, Microsoft Windows Server 2003, dreamweaver, flash, html, internet, quarkxpress, photoshop, coreldraw, web, visio, Exchange 2003, Exchange 2007, adobe, acrobat, aftereffects, golive, illustrator, indesign, livemotion, pagemaker, premiere, Apple, Macintosh, OSX, Troubleshooting, C, C++, C/C++, Digital Repro, DVD Studio Pro, Final Cut Pro, Groupwise, Java, JavaScript, Lotus, 123, Notes, Freelance Graphics, macromedia, fontographer, freehand, access, excel, frontpage, outlook, powerpoint, project, publisher, visual basic, VBA, Windows, Word, Oracle Database Administration, PL/SQL, SQL, PHP, mySQL, Scanner, Digital Camera, Picture it, Unix, video production Video Streaming, XML All available at our training centre in Guildford, or on-site anywhere in the UK: Surrey, South, South East, London, City, Guildford, Godalming, Woking, Portsmouth, Southamton, Farnham, Haslemere, Camberley, Bracknell, Basingstoke, Hampshire, West Sussex, Kent, Farnborough, Dorking, Hersham, Horley, Gatwick, Reigate, Redhill, Kingston, Leatherhead, Aldershot, Frimley, West Byfleet, Cobham, Esher, Weybridge, Camberley, Alton, Bordon, Fleet, Horsham, Crawley