Introduction to SQL on Oracle

Duration: 1 Day

The Introduction to SQL on Oracle course is designed to give delegates practical experience in using SQL.

How can I attend my course?

Target Audience:

  • Anyone who needs to understand and use SQL to manipulate a database.
  • There are no formal prerequisites for this Introduction to SQL on Oracle course, although an understanding of databases and exposure to information technology in general would be useful.


Prerequisites.

We recommend that attendees of this course have the following prerequisites:

  • Some previous programming or database experience would be useful


Objectives.

To provide the knowledge and skills needed to retrieve data held in a relational database using Oracle Database.

You will learn how to:

  • 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 Outline.

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.

My Course Notes

You will receive a full set of course notes and all supporting materials for your course. Hard Copy Delivered to your premises or Downloaded to a chosen device.
 

     OR  

To book this course please call +44 (0) 1444 410296 or email at Info@kplknowledge.co.uk

© Copyright 2019 KPL KnowledgeSolutionsWeb Design By Toolkit Websites