+44 20 7 193 893 7 info@zero2hero.training
+44 20 7 193 893 7 info@zero2hero.training
Zero To Hero IT Training
  • Home
  • About Us
  • Meet The Team
  • Courses
  • Contact Us
  • Home
  • -
  • Courses
  • -
  • Oracle SQL & PL/SQL Fundamentals
oracle-pl-sql-training.png1 copy

Oracle SQL & PL/SQL Fundamentals

By: Zero To Hero Date: Feb 09, 2020

The Oracle SQL & PL/SQL Fundamentals course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions, SQL*Plus parameters and the basic table and view handling statements are introduced. Who will the Course Benefit? Anyone who needs to use and […]

0 student
£999.00
536 Comments off
  • Overview
  • Curriculum
  • Instructor
  • Reviews

The Oracle SQL & PL/SQL Fundamentals course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions, SQL*Plus parameters and the basic table and view handling statements are introduced.

Who will the Course Benefit?

Anyone who needs to use and understand Oracle SQL to query and update an Oracle database; and who also needs an introduction to the PL/SQL programming language.

Course Objectives
To provide the skills needed to query and update data held in an Oracle Relational Database.

To provide an introduction to Oracle PL/SQL as a preparation for other Oracle products such as Forms and Reports.

Requirements
An understanding of databases and exposure to information technology in general would be useful.

  • Creating SQL statements to query database tables
    0
    No items in this section
  • Using standard aggregate functions and related SELECT statement clauses
    0
    No items in this section
  • Implementing extended SQL functions
    0
    No items in this section
  • Joining Tables
    0
    No items in this section
  • Using subqueries
    0
    No items in this section
  • Inserting, updating and deleting rows in database tables
    0
    No items in this section
  • Writing and running PL/SQL programs from SQL*Plus or SQL Developer
    0
    No items in this section
  • Declaring and using variables and constants
    0
    No items in this section
  • Assigning and manipulating values
    0
    No items in this section
  • Using SQL statements within PL/SQL
    0
    No items in this section
  • Implementing conditional execution and loop constructs
    0
    No items in this section
  • Declaring and using cursors with and without parameters
    0
    No items in this section
  • Updating data with cursors
    0
    No items in this section
  • Trapping and handling errors and exceptions in code
    0
    No items in this section
  • Implementing nested and labelled loops and blocks
    0
    No items in this section
  • Raising exceptions
    0
    No items in this section
  • Handling PL/SQL records and Index-By tables
    0
    No items in this section
  • Using PL/SQL Index-By table built-in functions
    0
    No items in this section
User Avatar
Zero To Hero

Reviews

Average Rating

0
0 ratings

Detailed Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
User Avatar

Zero To Hero

Subscribe

To Our Newsletter

Footer logo

A learning curve is essential to growth and could be achieved by involvement. Involve, Learn, Innovate

GET IN TOUCH

+44 20 7 193 893 7 info@zero2hero.training www.zero2hero.training Salisbury House, 29 Finsbury Circus, EC2M 7AQ, London

Useful Links

  • Become a Teacher
  • Upcoming Events
  • Courses
Copyright © 2021 Zero To Hero IT Training. All Rights Reserved.
Modal title

Message modal