Call 0800 860 6719 info@uniquelearn.co.uk

Oracle® 11g PL/SQL
Programming

  • Teacher
  • Category
  • Course
    5 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
  • Free Re-training
  • 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: 20 Jan |16 Mar | 13 Apr | 18 May
  • Course Duration : 5 days
  • Student Capacity : Small classes
  • Class Schedule : Mon-Fri, 5 Saturdays
  • Class Time : 10:00-17:00
  • Course Price : £1600
  • Teacher Name :

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

Social Media Auto Publish Powered By : XYZScripts.com

This website uses cookies to improve your experience. We’ll assume you are ok with this, but you can opt-out if you wish.