Duration: 1 Day
Course Overview
The Introduction to SQL on Oracle course is designed to give delegates practical experience in using SQL.
How can I attend my course?
COURSE OBJECTIVES
To provide the knowledge and skills needed to retrieve data held in a relational database using Oracle Database.
• Create SQL statements to query a database table
Use standard aggregate functions and related SELECT statement clauses
• Join Tables
• Use basic subqueries and the set operators
Course Content
Session 1: RELATIONAL DATABASE CONCEPTS
• What is an Oracle Database
• Relational Database Structures
• Tables, Rows and Columns
• Indexes, Primary Keys and Foreign Keys
• Supported Datatypes
• The Data Dictionary
Session 2: USING SQL*PLUS
• What is SQL*Plus
• Getting Started
• Entering and Executing SQL Statements
• Editing SQL Statements
• Creating, Editing and Executing SQL Files
Session 3: USING SQL DEVELOPER
• What is Oracle SQL Developer
• Starting SQL Developer
• Configure a Connection
• Navigation Tabs
• SQL Worksheet
• Query Builder
Session 4: RETRIEVING DATA WITH THE SELECT STATEMENT
• The SELECT Statement
• The SELECT and FROM Clauses
• Conditions and the WHERE Clause
• Other Conditional Operators
• Logical Operators
• The ORDER BY Clause
• Column Aliases
• Arithmetic Expressions
• Precedence of Operators
Session 5: AGGREGATE FUNCTIONS
• Overview of Built In Aggregate Functions
• The GROUP BY Clause
• The HAVING Clause
Session 6: JOINING TABLES
• Overview of Table Joins
• Inner Joins
• Table Aliases
• Outer Joins
• Self Joins
• ANSI Standard Joins
Session 7: BASIC SUBQUERIES AND SET OPERATORS
• Overview of Subqueries
• Basic Subqueries
• Set Operators
• The Union,Intersect and Minus Operators
Notes:
• There is an overlap between the content of this 1 day Introduction to SQL course and the content on the suggested follow-on Oracle and MySQL/MariaDB courses.
• You may wish to review the content of the 3 day Oracle SQL course, the 3 day Introduction to MySQL course or the 3 day Introduction to MariaDB course and if more suitable to your training needs attend one of those courses rather than this 1 day Introduction to SQL course.
• Course technical content is subject to change without notice.
• Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Additional Resourcing:
• If you have a number of delegates to train then this course can be conducted on your premises or at a venue of your choice as a Closed event. Closed courses can be tailored to meet the specific needs of your business and can prove to be cost effective, convenient and relevant.
• There are options to take this as a Virtual course. Please contact us to discuss your specific requirements and to arrange a date to run this course as a virtual event to suit your schedule.