Loading...

Oracle 12c SQL for End Users

Course code: O018

3 days £1,380.00
+ VAT

In this course students with previous ANSI SQL experience are introduced to the Oracle Database 11g environment, SQL Developer, the SQL language and extensions to the ANSI SQL standard.

Course content >

Who Should Attend?

Oracle Analyst Programmers

Oracle Technicians

Oracle DBA's

Oracle Developers

ANSI SQL Users

Prerequisites

PC Fundamentals

iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835

COURSE DATES

Course Contents

The course provides students with an overview of the basic elements of SQL. Students learn about the SELECT statement, pseudonyms, and different types of operators, conditions, expressions, and functions in SQL. Students also learn how to query from tables using joins and other advanced subqueries. Students learn to create and manage database objects such as tables, views, indexes, sequences, and synonyms. In addition, you learn how to control user access to the database and how to create roles and grant privileges.

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

 

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

 

Sub-Queries

Basic Subqueries

Multiple Column Subqueries

Subqueries with Having

Correlated Subqueries

Subquery Rules and Suggestions

 

Data Control Language (DCL)

Data Security

Grant and Revoke

 

Oracle 12c SQL New Features

Extended data types

ROW limiting for Top-N result queries

Invisible columns

Miscellaneous SQL*Plus enhancements

Display invisible columns

Session level sequences

Contact us for more information