0345 4506120

Oracle 11g SQL for Users

  • Introducing Oracle
  • The Elements of the Oracle
  • System
  • Relational Concepts

We don't currently have any courses listed for Oracle 11g SQL for Users, would you like to view all courses for Oracle?

Learning Objectives

This Oracle 11g SQL for Users training course gives a basic introduction to Oracle SQL, this SQL course will introduce the concepts behind the SQL language and the basics of SQL*Plus.

Pre-Requisites

PC Fundamentals

Course Content

SQL*Plus and SQL Introduction

  • Logging on to SQL*Plus and
  • Leaving SQL*Plus
  • Choosing and Describing
  • Tables
  • Elements of the SQL Query
  • The SQL Buffer and Query
  • Layout
  • Editing SQL Statements
  • The System Dummy Table
  • Selecting Columns
  • Duplicate Information

SQL Functions

  • The Concatenation Operator
  • Elements of the SQL Query:
  • Arithmetic
  • Column Aliases
  • String Functions
  • Arithmetic Functions
  • Date Functions
  • Mixed Functions

Advanced SQL Functions

  • Nesting Different Functions
  • SQL Bar Charts
  • Decode Crosstab
  • Decode with ">", "<" & "="
  • Select with Minus Union and Intersect
  • Connect By Prior
  • Sorting Information

Filtering Data Using Where

  • Where Operators
  • Where with Keywords
  • Where and Logical Operators
  • Where and Soundex

Retrieving Data from Multiple

  • Joining Tables (Equi-Joins)
  • Aliases for Table Names
  • Thinking behind Creating Joins
  • Joining Tables (Non-Equi-
  • Joins)
  • Joining Tables (Outer Joins)
  • Joining Tables (Inner Joins)

Group By and Group By Function

  • Group Function Examples
  • Group Function with Having

Sub-Queries

  • Basic Subqueries
  • Multiple Column Subqueries
  • Subqueries with Having
  • Correlated Subqueries
  • Subquery Rules and
  • Suggestions

Data Definition Language

  • (DDL)
  • Create, Drop Alter Keywords
  • Tables
  • Column
  • Views
  • Sequences

Data Manipulation Language

  • Insert
  • Update
  • Delete

SQL*Plus Reporting

  • Introducing SQL*Plus for
  • Reporting
  • Using SQL*Plus

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include