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 II training course is broken down into over twelve sections and includes the following aspects:
Creating Reports in SQL Developer
Using SQL Developer to import Excel data into an Oracle Database
Creating Tables, Indexes in SQL Developer
Creating Views and Materialized Views SQL Worksheet
Manipulating Table Constraints in 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:
Loading Excel Data into SQL Developer
Creating User Defined Reports in SQL Developer
Tree Walking Oracle tables in SQL Developer
Creating Tables and other Objects 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 aspects of using SQL Developer such as advanced query techniques, using the interface to amend and update information, creating Oracle Database objects etc ...
Please refer to either Part I of this course or the four day 'Using SQL with SQL Developer' if there is no previous knowledge of SQL, this course is designed for Users of SQL who now need to create Objects etc using SQL Developer.
Pre-Requisite Course(s)
None
Next Course(s)
Discoverer 10g Desktop
PLSQL I
Search the Site