Oracle 11g SQL for Report Writers

Name: Oracle 11g SQL for Report Writers
Availability: InStock
Rating: 1 (1 reviews)

Professional Training Solutions Ltd

Add to wishlist

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 1 Day
Call: +971 4 5490356

Course details

This course gives a basic introduction to Oracle`s version of SQL, focusing on the select statement for use within reports. This will be relevant for all versions of the database, from 8i onwards Designed to introduce concepts and functionality in an accessible and friendly format, the course has been prepared to assist report writers understand what reporting tools will do behind the scenes and is aimed at those using any reporting tool that generates SQL. This is an ideal pre cursor for the Oracle Discoverer courses.

Prerequisites:

PC Fundamentals

Who Should Attend:

Report Writers
Oracle Discoverer Users
Oracle Discoverer Administrators

Oracle Overview:

Introducing Oracle
The Elements of the Oracle System
Relational Concepts
What reporting tools do

SQL*Plus and SQL:

Introduction
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*Plus Reporting:

Introducing SQL*Plus for Reporting
Using SQL*Plus

SQL Functions:

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

Filtering Data Using Where:

Where Operators
Where with Keywords
Where and Logical Operators

Retrieving Data from 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 and Group Functions:

Group Function Examples
Group Function with Having

Data Warehousing and OLAP:

Materialised views
Dimensions
ROLLUP functions
The ROLLUP operator
The CUBE operator
Analytical Functions
Ranking
Banding
Windowing
Moving Averages
LAG and LEAD

Advanced SQL Functions:

Nesting Different Functions
Select with Minus, Union and Intersect
Connect By Prior
Hierarchies

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current SQL Server and Oracle jobs in UAE