Oracle Fundamentals - Oracle Training

The Knowledge Academy's Oracle Fundamentals course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL.

Pre-requisites

There are no pre-requisites for this course, however an understanding of databases and exposure to information technology in general would be useful.

Who is this course for?

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.

What will I Learn?

• 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

Course Outline

• Session 1: Relational database concepts
• Session 2: Using SQL*plus
• Session 3: Using SQL developer
• Session 4: Retrieving data with the select statement
• Session 5: Aggregate functions
• Session 6: Joining tables
• Session 7: Numeric, character and date functions
• Session 8: Conversion and miscellaneous functions
• Session 9: SQL*Plus parameters
• Session 10: Using Subqueries
• Session 11: Managing data
• Session 12: Managing tables
• Session 13: Managing indexes and views
• Session 14: Managing sequences and synonyms
• Session 15: PL/SQL fundamentals
• Session 16: Program logic
• Session 17: Using cursors
• Session 18: Exceptions and nested blocks

This course covers the major topics required for the Oracle examination 1Z0-051: Oracle Database 11g: SQL Fundamentals. The exam is not included as a part of the course and will need to be purchased separately via Pearson Vue.