Oracle SQL
Learn how to to use and understand Oracle SQL to query and update data in an Oracle database.
Oracle SQL- Course Objectives
This three day Oracle SQL 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 and the basic table and view handling statements are introduced. Gain practical hands-on experience by completing guided exercises and examples throughout the course.
Oracle SQL – Course Contents
- Creating SQL statements to query database tables
- Using standard aggregate functions and related SELECT statement clauses
- Joining Tables
- Using basic subqueries and the set operators
- Using numeric, character and date functions
- Using conversion and other miscellaneous functions
- Using SQL parameters
- Using complex subqueries
- Creating and altering tables and views
- Inserting, updating and deleting rows in database tables
- Managing sequences and synonyms
Oracle SQL- Course Details
This is a three day course running from 9:30 am – 4:00 pm. Courses run on-site and online. Please email for further information.
Prerequisites
An understanding of IT is required.
Qualification
Certificate of achievement.