Overview

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.

Skills Covered

  • Run data manipulation statements (DML) to update data in the Oracle Database.
  • Design PL/SQL anonymous block that execute efficiently.
  • Describe the features and syntax of PL/SQL.
  • Handle runtime errors.
  • Describe stored procedures and functions.
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors).
  • Use cursors to process rows.
  • Identify the major structural components of the Oracle Database 11g.
  • Retrieve row and column data from tables with the SELECT statement.
  • Create reports of sorted and restricted data.
  • Employ SQL functions to generate and retrieve customized data.
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax.
  • Create reports of aggregated data.
  • Run data definition language (DDL) statements to create and manage schema objects.

Who Should Attend

  • Developer
  • Implementer

Course Curriculum

Prerequisites

N/A

Download Syllabus

Course Modules

Expand allCollapse all

Request More Information

Training Options

Intake: Available Upon Request
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Price:

RM6,500.00Enroll Now

Exam:
Intake: Available Upon Request
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Price:

RM6,500.00Enroll Now

Exam:

Exam & Certification

This course is not associated with any Certification.

Training & Certification Guide

Frequently Asked Questions