SQL Developer Blitz at ODTUG Kscope12

Oracle Development Tools User Group (ODTUG) puts on an outstanding event, and I enjoy that the content comes FIRST. Yes, the after-event parties and entertainment are first class, but I look forward most to sitting in on some excellent sessions.

For Kscope12 one would expect Oracle to have a large presence, and you would be absolutely correct! The APEX team will be there in full force, and we’ll have sessions on JDeveloper, ADF, and .NET. But what I want to talk about today is our awesome line-up of coverage for Oracle SQL Developer (Surprise!)

DB and Developer’s Toolbox Symposium

Kris Rice or @krisrice, Product Development Manager for SQL Developer, will speak at 10AM Sunday about SQL Developer Data Modeler. Our free data modeling solution allows one to reverse engineer a data dictionary to a model, modify it, and create a script of the changes. Collaboration is an important part of any development team; with built-in subversion support, the modeler makes collaboration easy, not just possible.

After the morning break, I’ll be talking about SQL Developer’s PL/SQL support. From creating your code, to debugging, tuning, testing, and documenting PL/SQL – SQL Developer fits the bill. Since I have a full hour, I should have time to do a little riff on using source control to version and manage your revisions too!

At 3:15 Jagan Athreya will talk about the new integration between SQL Developer and Enterprise Manager Cloud Control 12c. Enabling developers to define changes in SQLDeveloper and allowing DBAs to promote these changes to Test and Production via Enterprise Manager will reduce errors, accelerate productivity, and help eliminate unplanned downtime.

Presentations

SQL Developer Tips and Tricks

Monday June 25, Session 5, 4:15 pm – 5:15 pm

I’ll take you through my favorite keyboard shortcuts, top 10 preferences every user should tweak, and spotlight features that the average user probably hasn’t discovered yet. My goal for this session is for everyone to take 1-2 tips they can implement immediately to save mucho time. I enjoy interacting with the audience so no two versions of this presentation are the same.

Oracle SQL Developer and Data Modeler New Features

When: Tuesday June 26, Session 6, 8:30 am – 9:30 am

Ashley Chen, my PM-partner-in-crime, will be covering all the new features from our two latest updates. So if you’re new to SQL Developer, or you’ve been using an older version, stop by and see what new toys you have to play with. I also have a bet with Ashley that she will have more attendees than me, so be sure to show up so I can collect.

Debugging PL/SQL With SQL Developer

When: Wednesday June 27, Session 16, 3:00 pm – 4:00 pm

Me again – sorry. This time I have an entire hour to JUST talk about PL/SQL and debugging! Should you use a watch with a break condition, or a breakpoint with a passcount? How does external debugging with a Perl script work? Can I just debug an anonymous PL/SQL block. So if debugging to you is just a DBMS_OUTPUT.PUT_LINE() call, stop by and see how our IDE can help you take things to the next level! Or is that level++?

Reverse Engineering (and Re-engineer) an Existing Database Using Oracle SQL Developer Data Modeler

When: Thursday June 28, Session 18, 10:30 am – 11:30 am

Kent Graziano aka @KentGraziano will demonstrate how to capture the design of an existing database, retrofit it to a logical model, re-engineer it to multiple models (including multi-dimensional), and even apply standards, then generate revised DDL to implement your newly standardized design.

Hands-on-Training

SQL Developer Soup to Nuts

When: Tuesday, 8:00 AM – 9:30 AM

If you learn by doing, this is the session for you. Bring your own laptop or use one of the lab machines. We’ll give you a VirtualBox OEL image running 11gR2 EE Database with all the fixin’s (that’s Southern speak for Partitioning, Advanced Compression, Tuning & Diagnostic Packs, etc), TimesTen, APEX and much more.

All you have to do is login and run through our lab exercises. You can start with a model and work your way up to debugging and testing your own appliction, or you can pick and choose your lessons to suit your needs. We’ll have people on hand to help you out and answer your questions.

Booth Hours

We’ll be in the vendor area and have our very own ‘demo pod’ for SQL Developer. Between Kris, Ashley, and I we should be able to answer your questions or show you how to ‘do that thing’ in the tool. Or just stop by and say hello! We’ll be around the following hours’ish:

• Sunday, June 24, 2012 6:00 PM – 8:00 PM
• Monday, June 25, 2012 9:00 AM – 4:30 PM
• Tuesday, June 26, 2012 9:30 AM – 3:30 PM
• Wednesday, June 27, 2012 10:15 AM – 2:00 PM

No Excuses – If You Have Questions, This is Your Chance to Get Your Answers!

We’re doing just about everything outside of a scavenger hunt to bring information and value to our users. Let us know what you like, what you don’t like, and we’ll do our best to do more of the former and less of the latter!