Oracle SQL Developer Part II Training Course
Freephone +44 (0) 800 157 7519
dates of our public training courses
Belfast
Birmingham
Bristol
Cardiff
Carlisle
Cork
Dublin
Edinburgh
Leeds
London
Manchester
Newcastle
Swansea
The Week in News, As Seen Through the Photographer's Lens
The Week in News, As Seen Through the Photographer's Lens
It's Time to Stop Obsessing Over Facebook's Profitability
It's Time to Stop Obsessing Over Facebook's Profitability
Joe Klein: Would-Be Democratic Mayors Threaten to Return NYC to Horrors of 90s
Joe Klein: Would-Be Democratic Mayors Threaten to Return NYC to Horrors of 90s
Richard Corliss Previews 29 Movies of Summer
Richard Corliss Previews 29 Movies of Summer
David Beckham's Last Game: What He Means to Soccer
David Beckham's Last Game: What He Means to Soccer
Toronto Mayor Denies Crack Allegations, But There Could Be Video Proof
Toronto Mayor Denies Crack Allegations, But There Could Be Video Proof
Burma's Bagan: A Mecca of Historical Treasures Seeking International Fame
Burma's Bagan: A Mecca of Historical Treasures Seeking International Fame
5 Funny Facebook Parodies
Great Moments in Pizza Innovations
Great Moments in Pizza Innovations
Corliss on the Scene at Cannes
Corliss on the Scene at Cannes
Accounting, Auditing & Accountability Journal
Volume 26 issue 4
Advances in Positive Organizational Psychology
Volume 1
Anti-Corrosion Methods and Materials
Volume 60 issue 3
Arts Marketing: An International Journal
Volume 3 issue 1
Asia Pacific Journal of Marketing and Logistics
Volume 25 issue 3
Asian Education and Development Studies
Volume 2 issue 2
Volume 65 issue 3
Benchmarking: An International Journal
Volume 20 issue 3
Volume 115 issue 5
Career Development International
Volume 18 issue 2
Essential SQL
Advanced 11g SQL
10g SQL
9i SQL
SQL for Users Part I
SQL for Users Part II
SQL for Users Part III
Query Builder
Using SQL with SQL Developer
SQL Developer Part I
SQL Developer Part II
Discoverer Courses
Discoverer 11g Desktop
Discoverer 11g Plus
Discoverer 10g Desktop
Discoverer 10g Plus
Discoverer 9i Desktop
Discoverer 9iAS
Discoverer 4i Desktop
Discoverer 3.1 User
Discoverer Administrator 11g
Discoverer Administrator 10g
Discoverer Administrator 9i
Discoverer Administrator 4i
Discoverer Administrator 3.1
Developer Courses
PLSQL I
PLSQL II
PLSQL 11g
Advanced PLSQL 11g
PLSQL 10g
Advanced PLSQL 10g
PLSQL 9i
Forms 11g
Forms 10g
Forms 9i
Forms 6i
Forms 6i New Features
Reports 11g
Reports 10g
Reports 9i
Reports 6i
Reports 6i New Features
Oracle Graphics
Database Administration
10g New Features for DBAs
10g DBA I
10g DBA II
9i New Features for DBAs
9i DBA I
9i DBA II
9i Database Tuning
9i Network Administration
9iAS Basic Administration
8i New Features for DBAs
8i DBA I
8i DBA II
8i Database Tuning
8i Network Administration
Secretary Kerry To Address Security Overseas Seminar Class
05/18/2013 - Secretary Kerry To Address Security Overseas Seminar Class
Readout of Secretary Kerry's Meeting With Foreign Minister of Bangladesh Dipu Moni
05/17/2013 - Readout of Secretary Kerry's Meeting With Foreign Minister of Bangladesh Dipu Moni
Photo: Secretary Kerry With Bangladeshi Foreign Minister Dipu Moni
05/17/2013 - Photo: Secretary Kerry With Bangladeshi Foreign Minister Dipu Moni
Secretary Kerry To Release Report on International Religious Freedom
05/17/2013 - Secretary Kerry To Release Report on International Religious Freedom
05/17/2013 - Remarks at the Annual Meeting of the President's Interagency Task Force to Monitor and Combat Trafficking in Persons
Travel of Special Envoy for North Korean Human Rights Issues Robert King to Seoul and Tokyo
05/17/2013 - Travel of Special Envoy for North Korean Human Rights Issues Robert King to Seoul and Tokyo
Assistant Secretary Jose Fernandez Travels to Mexico, Turkey, Bangladesh, and Spain
05/17/2013 - Assistant Secretary Jose Fernandez Travels to Mexico, Turkey, Bangladesh, and Spain
Outcomes at the World Telecommunication/Information and Communication Technology Policy Forum
05/17/2013 - Outcomes at the World Telecommunication/Information and Communication Technology Policy Forum
Assistant Secretary Dr. Kerri-Ann Jones To Travel to Geneva and Galway
05/17/2013 - Assistant Secretary Dr. Kerri-Ann Jones To Travel to Geneva and Galway
Remarks With Bangladeshi Foreign Minister Dipu Moni Before Their Meeting
05/17/2013 - Remarks With Bangladeshi Foreign Minister Dipu Moni Before Their Meeting
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
Oracle SQL Developer
Part 2 Training Course
SynopsisSQL 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.
Course Preview
The following options give examples of Course content ...
Pre-Requisite Course(s)
None
Suggested Further Course(s)
Discoverer 10g Desktop
PLSQL I
This intensive training course has a dynamic face to face, tutor led learning framework and is delivered by an experienced Oracle professional. In-depth course notes are provided in a presentation file for the delegate to use, and this becomes a valuable reference guide following the course.
On completion all delegates receive a certificate.
On Site or Off Site ?
On Site
All that we require is a private room with tables and chairs, that is large enough to comfortably hold your delegates and a tutor. We will provide each delegate with an individual laptop and all other equipment that is required.
Off Site
If you prefer instead of delivering on site we can deliver the course off site at Seer House, Swansea or we will be happy to arrange a neutral venue that is convenient for you (please be aware this will incur additional costs).
Weekday or Weekend ?
This course has the provision to be delivered over the weekend.
Ideal for your company, if you are working on projects with tight timescales or need to train employees with incredibly busy working weeks.
Standard or Customised ?
If you feel that this is not entirely suitable for your company requirements we offer the service of creating bespoke training packages. We can either customise this training to your exact company requirements or work with you to build a completely new one (please be aware this will incur additional costs).
Contact Details
Please contact us on
+44 (0) 800 157 7519 or email at training@seercomputing.com