Oracle Database SQL and PL/SQL New Features Ed 1

Overview


In this Oracle Database 12c: SQL and PL/SQL Fundamentals training course, you will learn the fundamentals of relational databases, SQL & PL/SQL programming language. You will also learn how to write queries against single and multiple tables, manipulate data in tables & create database objects.

Course Objective

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

Target Audience

  • Developer
  • Implementer
This course prepares you for Exam 1Z0-071. Download Course Contents
Schedule & Prices
Course Details Schedule
Classroom Training*
Duration : 5 Days
Fee :  London: £5,500, Dubai : $3,470 , India : $1,292


December
16-20 (Bangalore)
16-20 (Chennai)
January
06-10 (Delhi)
06-10 (London)
12-16 (Dubai)
13-17 (Chennai)
13-17 (London)
20-24 (Bangalore)
February
03-07 (Delhi)
03-07 (london)
09-13 (Dubai)
10-14 (Chennai)
10-14 (London)
17-21 (Bangalore)
March
02-06 (Delhi)
02-06 (london)
08-12 (Dubai)
09-13 (Chennai)
09-13 (London)
Instructor-Led Online Training
Duration : 5 Days
Fee :  $3,200


December
16-20
January
06-10
12-16
13-17
20-24
February
03-07
09-13
10-14
17-21
March
02-06
08-12
09-13
Fly-Me-a-Trainer
Duration : 5 Days
Fee : On Request
Client's Location
As per mutual convenience

Enquire Now




Input symbols

  • Introduction
  • Retrieve Data using the SQL SELECT Statement
  • Restricted and Sorted Data
  • Usage of Single-Row Functions to Customize Output
  • Conversion Functions and Conditional Expressions
  • 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
  • Introduction to PL/SQL
  • PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures
  • Usage of Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures and Functions