+44 (0) 845 643 1611 info@unitrain.co.uk

Oracle Database: PL/SQL Fundamentals

Official Oracle Curriculum

This Oracle Database: PL/SQL Fundamentals training introduces you to PL/SQL. It helps you understand the benefits of this powerful programming language, while teaching you real-world scenarios where these lessons can be applied.

Learn To:

  • Describe the features and syntax of PL/SQL.
  • Design a PL/SQL anonymous block that executes efficiently.
  • Write PL/SQL code to interface with the database.
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors
  • Handle runtime errors.
  • Describe stored procedures and functions.
  • Apply declaring identifiers and trapping exceptions.
  • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Gain Experience through Hands-On Practice

In this course, you'll learn from expert Oracle instructors, then engage in demonstrations and hands-on practice to reinforce the fundamental concepts. You'll use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.

Audience

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

Course Prerequisites

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

Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.

Oracle Database: PL/SQL Fundamentals Key Facts
Course Duration (days)

2.00

Course Price (ex VAT)

£1545.00

Course Vendor

Oracle

Contact Us

Submit this form and one of our friendly team will contact you within 4 working hours. Or give us a call on +44 0845 643 1611 and let us take care of your training needs.

    Links

    Home

    Location

    Health & Safety Training

    IT Courses

    eLearning Training

    Business Skills & Personal Development

    Project and Programme Management

    Tailor Made Courses

    Call Us

    +44 0845 643 1611

    Email Us

    info@unitrain.co.uk

    Privacy Policy