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.

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

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.

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

This course is an instructor led program with hands on labs and real life scenario. It is delivered with interactive lectures, PowerPoint presentations, question and answer sessions and project. This course is based on BYOD (Bring Your Own Device), participants are expected to bring their own device. There will be a special session for installation of software in their machines before the course starts. However, there will be provision for those who are unable to manage their device.