18 July 2007

Updates to Training and Online Material

The Oracle SQL Developer Tutorial has been updated to support SQL Developer 1.2 features. This tutorial is packed full of short demonstration viewlets; from installation, creating connections, through using functions, working with collections of data, PL/SQL debugging to creating reports.

The great thing about this tutorial, is that you can dip in and out of it at any point. There is a flow from installation to building reports, as the tutorial follows a scenario, but if you just want to know how to work with constraints you can go straight there.

The brief viewlets are interactive, so you can get a feel for the actions. If you just want to flick through the demonstration you can click the forward control.

If you are new to Oracle, then this tutorial is also great in that it walks you through the basics of SQL and getting to grips with DDL and DML, all the while using SQL Developer.

Other Collateral Updates

You may be aware of our homepage on OTN: http://www.oracle.com/technology/products/database/sql_developer/
The front page has links to documents that are a result of general questions that often come up, for example, Pricing, Support & Licensing Questions. The front page also links to viewlets, white papers, magazine articles and tutorials. Each of these categories contain recently updated material. Some of you have been asking for some material on how to create extensions for SQL Developer. There is now a published article in the latest Oracle magazine on that.

So dip into the tutorial or have a browse around the SQL Developer content. If there is anything you'd like to see added, then drop me a line and we'll see what we can do.

Sue

2 comments:

SydOracle said...

I was impressed to see that SQL Developer documentation is now part of the 10gR2 database documentation set at
http://www.oracle.com/pls/db102/portal.all_books#index-SQL
That gives it the same credibility as SQL*Plus, rather than "something given away free with a packet of cornflakes".
Do you know if it will be on the Oracle Database 11g distribution media ?

Sue said...

Gary,

Yes, it's good to have SQL Developer appearing in different places. The Oracle University classes for the 11g SQL and PL/SQL course will be using SQL Developer instead of SQL *Plus, so that'll be great too.
The 11g Database distribution media will also include SQL Developer.

Sue