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 intensive hands on Using SQL with SQL Developer Part I training course is broken down into over fifteen sections and includes the following aspects:
The SQL Developer Interface
The Object Details Dialog
Using Functions in SQL
Joining Tables in an SQL Worksheet
Exporting Data in SQL Developer
Totalling Data using SQL Developer
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:
Selecting from Tables in SQL Developer
Multiple Table Querying with Ansi SQL/92
Using a Where Clause in SQL Developer
Creating Snippets in SQL Developer
Duration
Two Days
© Copyright
Seer Computing Ltd.
SQL is the foundation of all Oracle database actions.
The SQL Developer Interface offers a GUI front end for creating SQL statements and offers a valuable alternative to third party products such as Toad.
This course covers all aspects using SQL Developer for extracting Data, essentially it is a two day version of our main 'Using SQL with SQL Developer' and takes the User through selecting and manipulating data.
Part II covers the insertion, updating and deletion of data as well as the creation of Database Objects.
Pre-Requisite Course(s)
None
Next Course(s)
Discoverer 10g Desktop
Using SQL with SQL Developer Part II
PLSQL I
Search the Site