Oracle SQL & PL/SQL Fundamentals
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 […]
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
No items in this section -
Implementing extended SQL functions
No items in this section -
Joining Tables
No items in this section -
Using subqueries
No items in this section -
Inserting, updating and deleting rows in database tables
No items in this section -
Writing and running PL/SQL programs from SQL*Plus or SQL Developer
No items in this section -
Declaring and using variables and constants
No items in this section -
Assigning and manipulating values
No items in this section -
Using SQL statements within PL/SQL
No items in this section -
Implementing conditional execution and loop constructs
No items in this section -
Declaring and using cursors with and without parameters
No items in this section -
Updating data with cursors
No items in this section -
Trapping and handling errors and exceptions in code
No items in this section -
Implementing nested and labelled loops and blocks
No items in this section -
Raising exceptions
No items in this section -
Handling PL/SQL records and Index-By tables
No items in this section -
Using PL/SQL Index-By table built-in functions
No items in this section
