Course Code: osql
Duration: 14 hours
Prerequisites:

None

Overview:

This instructor-led, live training (online or onsite) is aimed at providing an introduction of the SQL programme language.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request customized training for this course, please contact us to arrange.
Course Outline:

Introduction

  • Relational and Object Relational Database Management Systems
  • Structured Query Language (SQL)
  • Concept of 'Schema' in Oracle Database

Using SQL Developer

Retrieve Data using the SQL SELECT Statement

  • Capabilities of SELECT Statement
  • Basic SELECT statements
  • SELECT all columns
  • Column Aliases
  • Retrieving Distinct Values
  • Introduction to SQL Operators

Restrict and Sort Data

  • WHERE clause
  • Comparison operators and logical operators
  • Rules of precedence for comparison and logical operators
  • Character string literals
  • Date queries
  • ORDER BY clause

Single-Row Functions

  • ingle row verses multiple row functions
  • Using functions in the SELECT and WHERE clauses
  • Manipulate strings with character functions
  • Manipulate numbers with the numeric functions
  • Manipulate dates with date functions

Invoke Conversion Functions and Conditional Expressions

  • Describe implicit and explicit data type conversion
  • Conversion functions
  • Nesting functions
  • DECODE, NVL, NULLIF, and COALESCE functions
  • Using CASE expressions

Display Data from Multiple Tables Using Joins

  • Overview of joins
  • Write SELECT statements to access data from more than one table
  • Inner Joins
  • Outer Joins
  • Non-equi Joins
  • Cartesian Joins
  • Join a table to itself by using a self join
  • Joining multiple tables

Aggregation of Data using Group Functions

  • Aggregation functions
  • GROUP BY clause
  • HAVING clause

Use Sub-queries to Solve Queries

  • Overview of sub-queries
  • Define sub-queries
  • Common types of sub-queries
  • Single-row sub-queries
  • Multiple-row sub-queries
  • Multiple-column sub-queries
  • In-line Views
  • Correlated Sub-queries
  • The WITH clause

The SET Operators

  • Describe the SET operators
  • Use a SET operator to combine multiple queries into a single query
  • Control the order of rows returned