Home
Public Courses
Oracle Courses
Microsoft Courses
Java Courses
Consultancy
Home
Contact Us
About Us
Download
FAQ
Public Courses
London
Edinburgh
Birmingham
Manchester
Dublin
Leeds
Cardiff
Newcastle
Belfast
Swansea
Oracle Courses
SQL
SQL for Users Part 1
Query Builder
Essential SQL
10G SQL
9i SQL
Using SQL with SQL Developer
SQL Developer Part 1
SQL Developer Part 2
PLSQL
PLSQL 1
PLSQL 2
PLSQL 10g
PLSQL 9i
9i New Features
8i New Features
Discoverer
10g Administration
10g Desktop
10g Plus
9i
Administration
Desktop
4i
Administration
Desktop
3.1
Administration
User
Forms
Forms 10g
Forms 9i
Forms 6i
Forms 6i New Features
Reports
Reports 10g
Reports 9i
Reports 6i
Reports 6i New Features
Graphics 6i
DBA
10g DBA 1
10g DBA 2
10g New Features
9i
New Features for DBAs
DBA 1
DBA 2
Database Tuning
Network Administration
AS Basic Administration
8i
New Features for DBAs
DBA 1
DBA 2
Database Tuning
Network Administration
Microsoft Courses
Word
Excel
Access
Powerpoint
Frontpage
Project
Java Courses
Fundamentals of Java
Java Programming
Java Swing
Consultancy
Discoverer Consultancy
Data Consultancy
Oracle Consultancy
Contents
This course concentrates purely on data extraction and manipulation and is ideal for users who will not have permission to do anything other than create select statements.
The following aspects are included:
The SQLPlus Interface
Single Oracle Table queries
Where clauses to limit data
Merging Tables in Oracle SQL
Tree Walks (Self Joined Tables)
Exercises
There are practical and comprehensive exercises scheduled throughout the course to ensure delegates leave with a sound theoretical and practical knowledge.
The exercises include
Navigation of SQL Plus
Manipulating data using Oracle functions
Selecting records using querying
Saving results of Oracle Queries into output files
Duration
One Day
© Copyright
Seer Computing Ltd.
Black and white, a simple breakdown of SQL for users who need to extract information from an Oracle Database.
Delegates who need more comprehensive information such as relational techniques or creating Objects should refer to our other SQL based courses
Pre-Requisite Course(s)
None
Next Course(s)
None
Search the Site