Khawarizmi Training Solutions
al khawarizmi International college - since 1985
  • Search
  • Home
  • ABU DHABI: +971-2-4080000
  • AL AIN: +971-3-7555005

Oracle PL/SQL 11g Advanced

In this course, instructors will help students explore the advanced features of PL/SQL to design and tune PL/SQL. Students will learn how it interfaces with the database and other applications in the most efficient manner.

Upon course completion, the student will be able to:

  • PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  •  Implement a virtual private database with fine-grained access control.
  •  Write code to interface with external C and Java applications.
  •  Write code to interface with large objects and use SecureFile LOBs.
  •  Write and tune PL/SQL code effectively to maximize performance

In this course, instructors will help students explore the advanced features of PL/SQL to design and tune PL/SQL. Students will learn how it interfaces with the database and other applications in the most efficient manner.

Upon course completion, the student will be able to:

  • PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  •  Implement a virtual private database with fine-grained access control.
  •  Write code to interface with external C and Java applications.
  •  Write code to interface with large objects and use SecureFile LOBs.
  •  Write and tune PL/SQL code effectively to maximize performance

Application Developers, Database Administrators and PL/SQL Developers will benefit from this course.

  • PL/SQL Programming Concepts Review
  • Designing PL/SQL Code
  • Using Collections
  • Manipulate Large Object
  • Using Advanced Interface Methods
  • Performance and Tuning
  • Improving Performance with Caching
  • Analyzing PL/SQL Code
  • Profiling and Tracing PL/SQL Code
  • Implementing VPD with Fine-Grained Access Control
  • Safeguarding your code against SQL Injection Attacks
  • Design PL/SQL packages and program units that execute efficiently
  • Write code to interface with external applications and the operating system
  • Create PL/SQL applications that use collections
  • Write and tune PL/SQL code effectively to maximize performance
  • Implement a virtual private database with fine-grained access control
  • Write code to interface with large objects and use SecureFile LOBs

120 hours – 3 months

Timing – 2 hours per day and 5 days a week – Morning, afternoon or evening

Contact Us

GET IN TOUCH

Fields marked with * are required

Close Panels

Abu Dhabi

AI Moroor Road,
Next To The Main Bus Station,
Abu Dhabi, United Arab Emirates.

Al Meryal, Next to Al Towaya park
68297. Al Ain, United Arab Emirates.

Email : info@khawarizmi.com; info.alain@khawarizmi.com
Telephone : +971-2-4080000, +971-3-7555005
Fax :+965 22427823