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

Oracle Database 12c: SQL and PL SQL Fundamentals

Official Oracle Curriculum

This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You'll explore the concepts of relational databases.

Learn To:

  • Write queries against single and multiple tables, manipulate data in tables and create database objects.
  • Use single row functions to customize output.
  • Invoke conversion functions and conditional expressions.
  • Use group functions to report aggregated data.
  • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
  • Develop anonymous PL/SQL blocks, stored procedures and functions.
  • Declare identifiers and trap exceptions.
  • Use DML statements to manage data.
  • Use DDL statements to manage database objects.
  • Declare PL/SQL Variables.
  • Conditionally control code flow (loops, control structures).
  • Describe stored procedures and functions.
  • Retrieve row and column data from tables.

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.

Hands-On Practices:

Demonstrations and hands-on practice reinforce the fundamental concepts that you'll learn in this course. By enrolling in this course, you'll begin using Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are available as optional tools

Target Audience:

  • PL/SQL Developer
  • Forms Developer
  • Application Developers
  • Reports Developer
  • Technical Consultant
  • Portal Developer
  • Functional Implementer

Course Prerequisites

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

Those delegates who are attending via either virtual or extended classroom will be required to provide either dual monitors or single monitor plus a tablet device.

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 12c: SQL and PL SQL Fundamentals Key Facts
Course Duration (days)

5.00

Course Price (ex VAT)

£2680.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