Oracle Database: SQL and PL/SQL Fundamentals Ed 2/D80198GC20/1Z0-071


Oracle Database: SQL and PL/SQL Fundamentals Ed 2 Certification Training Course Overview

Oracle Database: SQL and PL/SQL Fundamentals Ed 2 training course is designed to learn the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology.

Course Objective:

  • 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.

Oracle exam can be taken from home.
This course prepares you for Exam 1Z0-071. Download Course Contents

Oracle Database: SQL and PL/SQL Fundamentals Ed 2 Course schedule & Prices

Schedule & Prices
Course Details Schedule
Live Virtual Classroom (Instructor-Led)
Duration : 5 Days (10 Days for 4 Hours/Day)
Fee : USD 2,700 (Includes Taxes) 



July
8 Hours/Day
4 Hours/Day
06-10
12-16
13-17
20-24
06-17
12-23
13-24
20-31
August
8 Hours/Day
4 Hours/Day
03-07
09-13
10-14
17-21
03-14
09-20
10-21
17-28
September
8 Hours/Day
4 Hours/Day
07-11
13-17
14-18
21-25
07-18
13-24
14-25
21-02
Fly-Me-a-Trainer
Duration : 5 Days
Fee : On Request 		Client's Location
As per mutual convenience
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : 5 Days
Fee : On Request
On Request

Enquire Now




Input symbols

Course Prerequisites
  • No formal pre-requisites for this course.

  • 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.

FAQ's