Advanced PL/SQL Tips and Techniques Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 3 Days

Course details

The focus of this course is to advance attendee knowledge of the PL/SQL programming language. This is an excellent course for those people that need a better knowledge of the PL/SQL language. This course covers all the latest features of PL/SQL using databases Oracle9i, Oracle10g, and Oracle11g.

Prerequisites:

A working knowledge of SQL and PL/SQL is required.

Oracle Architecture:

Introduction to PL/SQL :

Syntax and language structure review

PL/SQL Topics :

Package Usage (both User Defined and Oracle Defined Packages)
Profiling/Debugging/Compiling
Cursor Sharing/Cursor Variables
Collections
Dynamic SQL
Autonomous Transactions
PL/SQL Coding Tips
Debugging PL/SQL
PL/SQL Profiling
Tracing PL/SQL

Attendees Receive:

Study guide and relevant white papers
Diskette full of useful SQL and SQL*Plus scripts
A hands-on opportunity to learn more about Oracle, TOAD, and SQL Developer

Day 1: Advanced Oracle PL/SQL:

PL/SQL Overview/Review
PL/SQL Compiler
Definer/Invoker Rights
Executing and Exception handling
Autonomous Transactions
Package Options
Overloading
Database Triggers
DML, Instead of, ServerError, Startup, Shutdown, Logon

Day 2: Advanced Oracle PL/SQL:

Working with Cursors

User Defined Datatypes
Cursor Sharing
Cursor Variables
Strong vs Weak Cursors

Working with Collections

Associate Arrays
Nested Tables
Varrays
Bulk Collect/Forall Bulk Binding
Using Collections for Reference Table

Oracle Provided Packages

DBMS_Alert
DBMS_Job
DBMS_Output
DBMS_Scheduler
UTL_File
UTL_Mail
Other Provided Packages

Day 3: Advanced Oracle PL/SQL:

DBMS_SQL & Dynamic SQL
Working with Large Objects
Debugging PL/SQL Routines
PL/SQL Profile
Oracle Trace

About Dan Hotka:

Dan Hotka is a Training Specialist who has over 30 years in the computer industry and over 25 years of experience with Oracle products. He is an internationally recognized Oracle expert with Oracle experience dating back to the Oracle V4.0 days. Dan’s latest book is the SQL Developer Handbook by Oracle Press. He is also the author of Oracle9i Development By Example and Oracle8i from Scratch by Que and has co-authored 7 other popular books including the Database Oracle10g Linux Administration by Oracle Press. He is frequently published in Oracle trade journals, and regularly speaks at Oracle conferences and user groups around the world.

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for SQL Server online courses See all SQL Server Courses

See all current SQL Server jobs in Ireland

Are you from Professional Training Solutions Ltd ? Claim your course!

Courses you can instantly connect with... Do an online course on SQL Server starting now.