Call 0203 995 1156 info@uniquelearn.co.uk

Oracle® 11g PL/SQL
Programming Bundle

  • Teacher
    Matthew Nicholson
  • Category
  • Course
    5 days
  • Course Price
    £2400
PL/SQL programming
Book Now

This 5-day PL/SQL course bundle combines the learning of programming, management, and security issues of working with PL/SQL program units with advanced features. By combining the Oracle 11g PL/SQL Programming and the Oracle PL/SQL Advanced Programming courses.  Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle®.

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
  • Database Design Concepts
  • SQL Sub queries
  • Hierarchical Queries
  • Object Types
  • Times, Dates, and Strings
  • Temporary Tables
  • SQL Tuning Tools
  • SQL Tuning
  • Indexes
  • Oracle Analytic Functions
  • Data Warehouse Features
  • Formatting Reports with SQL*Plus

Course Information

  • Class Start : | 18 May | 01 Jun
  • Course Duration : 5 days
  • Student Capacity : Small classes
  • Class Schedule : Mon -Fri
  • Class Time : 10am - 5pm
  • Course Price : £2400
  • 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