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

A Relational Database Management System (RDBMS) is a software system that allows you to create and manage a relational database. Minimum requirements for such a system are defined by both ANSI and ISO. PL/SQL is Oracle’s Procedural Language for SQL. It is Oracle’s database programming language for creating stored procedures, functions, database triggers, and object methods. PL/SQL can be used for implementing business rules, computing algorithms, manipulating data, and for stand-alone programs. The Oracle® 11g release has greatly enhanced the features and functionality of PL/SQL. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features.

Learning Objective

In this course, delegates will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle®. Students will learn programming, management, and security issues of working with PL/SQL program units. 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

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: 17 Feb
  • Course Duration : 5 days
  • Student Capacity : Small classes
  • Class Schedule : Weekdays, Weekends
  • Class Time : 10:00-17:00
  • Course Price : £1600
  • Teacher Name :

Comments

Leave a Reply

Your e-mail 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

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