0345 4506120

Oracle 11g SQL

Oracle 11g SQL training courses gives an excellent introduction to Oracle 11g SQL, covering the SQL*Plus toolkit and Oracle 11g RDBMS SQL contextual operating environment.

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

Learning Objectives

Oracle 11g SQL training courses gives an excellent introduction to Oracle 11g SQL, covering the SQL*Plus toolkit and Oracle 11g RDBMS SQL contextual operating environment.

Pre-Requisites

PC Fundamentals

Course Content

Oracle 11g Overview

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

Oracle 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 (DISTINCT)
  • Sorting Information

Oracle SQL Functions

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

Advanced Oracle SQL Functions

  • Nesting Different Functions

Oracle SQL Bar Charts

  • Decode Crosstab
  • Decode with ">", "<" & "="
  • Select with Minus Union and Intersect
  • Connect By Prior

Filtering Data Using Where

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

Retrieving Multiple Table Data

  • 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 / Group By Functions

  • Group Function Examples
  • Group Function with Having

Object Support

  • Object - relational database
  • Oracle Object Type definition
  • Nested objects
  • Object constructors
  • Objects as NULL/ attributes as NULL
  • Object Tables
  • Type Hierarchy and Inheritance
  • Abstract and Final Types
  • Object Evolution
  • Propagation of Changes
  • 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/Partitioning/Column
  • Views/Synonyms/Sequences

Integrity Constraints

  • Types of Constraint
  • Referential Integrity
  • Defining Constraints
  • Integrity Constraints and Data Dictionary
  • Alter table

Indexes

  • Create Index
  • Unique Option
  • When and What to Index
  • Drop Index
  • Validate Index
  • Index Type Overview

Data Manipulation Lang (DML)

  • Insert /Update/Delete
  • OPS Commands (Commit, Rollback and Savepoints)

Data Control Language (DCL)

  • Data Security
  • Grant and Revoke

LOBs

  • LOB Migration
  • LOB SQL Features

 

Oracle SQL*Plus Reporting

  • Introducing SQL*Plus for Reporting
  • Using SQL*Plus
  • Using the System Editor for SQL*Plus
  • SQL*Plus Command Variables
  • Building SQL*Plus Reports
  • Titles and Headings
  • Using NEW_VALUE and OLD_VALUE

ANSI Standardisation

  • Oracle (since 9ir2) Joins improvements
  • Case Expressions
  • SQL NULLIF and COALESCE
  • Scalar Subqueries
  • Date Datatype
  • TIMESTAMP Datatype
  • INTERVAL Datatypes
  • CURRENT_DATE

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