Oracle SQL 10g: SQL for End Users

Scheduled Dates Locations filtered. Show all UK course locations.

Course Overview

This 2 day Oracle training course introduces this new version of SQL, using the SQL*Plus toolkit and introduces the concepts behind the SQL language.

Designed to introduce concepts and functionality in an accessible and simple format, the Oracle training course has been prepared to assist Oracle end-users in understanding how to retrieve and maintain information within a controlled Oracle 10g database environment. SQL*Plus, the primary interface to the Oracle Database server, provides a powerful yet easy-to-use environment for querying, defining, and controlling data.

Audience

Oracle SQL Users ANSI SQL Users

Course Outline

Oracle Overview

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

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

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

Filtering Data Using Where

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

Retrieve Data:Multiple Tables

• 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 Functions

• Group By Function Examples
• Group By Functions with Having

Sub-Queries

• Basic Subqueries
• Multiple Column Subqueries
• Subqueries with Having
• Correlated Subqueries

Data Definition Language

• Create, Drop Alter Keywords
• Tables
• Column
• Views
• Sequences

Data Manipulation Language

• Insert
• Update
• Delete

Oracle SQL 10g: SQL for End Users / OD10-SQ2