Oracle Database 11g - Program with PL / SQL

@ Netassist International

+94 11 2 375346, +94 77 0347777, 0776774772, 0776538036

June 19, 2019

40 Hours

LKR 48,500

Learn To

  • Create, and execute stored procedures and functions
  • Design and use PL/SQL packages
  • Create overloaded package subprograms for more flexibility
  • Utilize Oracle-Supplied Packages in Application Development
  • Create triggers to solve business challenges
  • Build and execute SQL statements dynamically

Benefits To You

Students are introduced to the utilization of some of the Oracle-supplied packages. Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies. In this course, students learn and use Oracle SQL Developer as the main environment tool to develop these program units. SQL*Plus is introduced as optional tools. Demonstrations and hands-on practice reinforce the fundamental concepts.

Audience

  • Database Administrators
  • Forms Developer
  • PL/SQL Developer
  • Portal Developer
  • System Analysts
  • Technical Consultant

Suggested Prerequisites

  • Familiarity with data processing concepts and techniques
  • Familiarity with programming languages

Course Objectives

  • Create triggers to solve business challenges
  • Manage dependencies between PL/SQL subprograms
  • Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions
  • Use the compiler warnings infrastructure
  • Create, use, and debug stored procedures and functions
  • Design and use PL/SQL packages to group and contain related constructs
  • Create overloaded package subprograms for more flexibility
  • Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
  • Write dynamic SQL for more coding flexibility
  • Use conditional PL/SQL compilation and obfuscate (hide) code


Level
Commencement
June 22, 2019
Closing Date
June 19, 2019
Location
Colombo
Category
Address
No 308 - 310 , R A De Mel Mw , Colombo 03

Send Inquiry


Scholarship Alerts!

Type "REG coursenet" and SEND to 77000

Get latest scholarships, offers & academic event alerts to your phone via SMS.

Service is available for Dialog, Mobitel, Hutch & Airtel users. Monthly (Rs. 30 + tax).


Related Courses