Oracle DB SQL And PL/SQL Fundamentals Classroom Training

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
122016
Haryana

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