Oracle Fundamentals

Course

Online

£ 1,695 + VAT

Description

  • Type

    Course

  • Methodology

    Online

The Oracle 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. The course also provides practical experience in using Oracle's PL/SQL programming language to implement conditional execution, loop control, cursor handling and exception handling. 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. Learning 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.

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Programming
  • Database training
  • PL/SQL
  • SQL
  • Database

Course programme

The delegates will practise:

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

Oracle Fundamentals

£ 1,695 + VAT