Oracle DB SQL And PL/SQL Fundamentals Classroom Training

Oracle DB SQL And PL/SQL Fundamentals Classroom Training


  • Oracle Database SQL and PLSQL fundamentals Training Cost

    Sale Date Ended

    INR 68310
    Sold Out

Invite friends

Contact Us

Page Views : 26

About The Event

Oracle Database: SQL and PL/SQL Fundamentals training at Mercury Solutions Limited offer the fundamentals skills and knowledge of SQL and PL/SQL to the developers and technical administrators.

Why Oracle Database SQL and PL/SQL Fundamentals?

The Individuals will learn to:

  • Create PL/SQL blocks of application code that permit sharing across multiple forms, reports, and data management applications.
  • Use of DDL statements to manage database objects.
  • Retrieve row and column data from tables.
  • Conditionally controlling code flow (loops, control structures)

Course Outline:

  • Course Introduction
  • Introduction to PL/SQL
  • PL/SQL Identifiers
  • Working with Oracle Cloud Exadata Express Cloud Service
  • Retrieve Data using the SQL SELECT Statement
  • Restricted and Sorted Data
  • Usage of Single-Row Functions to Customize Output
  • Aggregated Data Using the Group Functions
  • Display Data from Multiple Tables
  • Usage of Subqueries to Solve Queries
  • SET Operators
  • Data Manipulation
  • DDL Statements to Create and Manage Tables
  • Other Schema Objects
  • Write Anonymous PL/SQL blocks
  • SQL statements in PL/SQL block
  • Control Structures
  • Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures and Functions

More Details about the Course

Who Should Attend:

  • PL/SQL Developer
  • Portal Developer
  • Forms Developer
  • Functional Implementer
  • Reports Developer

Training Modes:

  • Live-Virtual-Training
  • Classroom Training

Training Date:

  • May 22-May 26, 2017
  • June 05- June 09, 2017

What's Included in Training:

  • Official E-kit
  • Hands-on-Lab
  • Participation Certificate from Oracle University
  • 25% on Discount Voucher for OCP Exam*

Contact At: 

Mercury Solutions Limited
464, Phase V, Udyog Vihar,
Gurgaon, Delhi/NCR

Note: *The Discount Voucher Code can be redeemed at any Pearson VUE Testing Center

Venue Map