Call 0203 995 1156 info@uniquelearn.co.uk

Oracle® 11g PL/SQL
Programming

  • Teacher
    Matthew Nicholson
  • Category
  • Course
    3 days
  • Course Price
    £1600
PL/SQL programming
Book Now

Delegates will learn programming, management, and security issues of working with PL/SQL program units. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle®. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features.

Target Audience

  • Application developers and database administrators.

Prerequisites

Oracle 11g SQL Fundamentals

What is Included

  • All accompanying course material
  • Hands-on Tutor Led Training
  • Classroom Based Practical Training
  • Unlimited Practice Lab Access
  • Small Size Class and Interactive Sessions
  • Lab Exercises
  • Mock Exam
  • Completion Certificate
  • Refreshments will also be provided throughout the duration of your training.

Course Outline

  • Triggers
  • PL/SQL Variables and Datatypes
  • PL/SQL Syntax and Logic
  • Stored Procedures and Functions
  • Exception Handling
  • Records, Collections, and User-Defined Types
  • Cursors
  • Bulk Operations
  • Using Packages
  • Creating Packages
  • Working with LOBs
  • Maintaining PL/SQL Code
  • Dynamic SQL
  • PL/SQL Versions, Datatypes and Language Limits

 

Course Information

  • Class Start : Days: | 01 Jun | 29 Jun | 06 Jun |
  • Course Duration : 3 days
  • Student Capacity : Small classes
  • Class Schedule : Mon-Fri, Saturdays:
  • Class Time : 10:00-17:00
  • Course Price : £1600
  • Teacher Name : Matthew Nicholson

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts