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

Benefits of this Course at Mercury Solutions:

- Individuals will learn to Create PL/SQL blocks of application code that permit sharing across multiple forms, reports, and data management applications.
- Using DDL statements to manage database objects.
- Retrieving 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

Who Should Attend:

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

Training Modes:

- Training-On-Demand
- Live-Virtual-Training
- Classroom Training
- Self-Study
- Bootcamp Training

Training Date

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

What's Included in Training:

- Official Courseware
- Expert Trainers
- Customize Batches
- Exam Voucher
- Post Training Support
- Hands-on Labs
- Course Completion Certificate

Bootcamp:

- Visa Guidance
- Airport Pick & Drop
- Transport Facility
- Accommodation
- Daily Meals
- E-Kit

Learn more about Course at http://www.mercurysolutions.co/training/oracle-database-sql-pl-sql-fundamentals-certification-training?Nairaland

Or

Enquire at

E: training@mercury.co.in
M: +918882233777