DBClarity Webinar - Reusing SQL Queries

In my last entry I said that I'd watched Tristan's webinar on reusing a SQL query to create insert and merge statements. I enjoyed the re-usability aspect, so quickly created a video to show the feature, not having the patience to wait for Tristan's webinar to be published! The full webinar is now available; we've edited out the noise in the Q&A section, so it's all good content.  There are few useful questions and answers on pricing and a snippet of news about the great feature coming in the next release.  You can find the video on YouTube:  http://www.youtube.com/watch?v=EbLEmZf79Hc.
If you missed these webinars, we're re-running the series to coincide with a SQL Server Relay, a 5-day event running in various cities and ending in London on the 30th May and we'll be there! Visit the Microgen/DBClarity website to register.

Learn to Reuse your SQL Queries: Working with Subqueries and Merge

This week we ran a new webinar for DBClarity Developer, focusing on creating SQL queries, first by creating a query and then reusing that query - using DBClarity Developer  - to make things nice and easy.  I go back and forth on this"nice and easy" because I started life writing SQL at the command line, so visual, graphical queries are still relatively new to me.  As I watched the webinar this week, I felt that same twinge of excitement when I show anyone something new.  Over the years I have loved teaching and presenting neat features in products.  I have not been at a conference or event in over a year, but I couldn't wait to show you this piece of code  - hence this little video.  It's all easy stuff, and I'm sure you'll like the "reuse" aspect of the demo.

I'm stealing a bit of Tristan's thunder. He did the webinar and the demo and in the video below, I'm doing an exact rework of his demo.  In the webinar he also talks of the benefits of the product and mentions an exciting new feature in the next release, so you'll have to watch the webinar to get all that news!

If your SQL is a little rusty, perhaps it takes a little while to build up a query or if you're wanting to learn new SQL syntax, then take a look at this demo.

More Information

• This is the link to previous webinars and other demos. 
• Future webinars are listed under Events
• Download the product and try these queries:  http://www.microgen.com/uk-en/products/microgen-dbclarity-developer

First Webinar on DBClarity Developer - Learn More!

Conference season may be over and you may all be into the swing of the end of year activities, but things are still happening here. DBClarity Developer Beta 1 has been out for just under 2 months and we're about to release a second beta.  Before we do that, we thought we'd show you more about the product and give you the opportunity of seeing what it does and to ask questions.  Register for the live Microgen DBClarity Developer Webinar to be run on Thursday 15th December, and because this is a webinar, it's "at a city near you"; just join in, watch, listen, learn, and ask questions.

DBClarity Developer is a standalone product that provides a graphical interface for creating SQL queries, procedures and functions. The beauty of the graphical interface is that you can create the code graphically and let the product build the SQL, once done, you can revisit the diagram.  It's great for maintenance because you don't need to trawl through lines of code, in an attempt to figure out what it's designed to do, and it's great for collaborative work, because the visual aspect helps when you're explaining how the code works. DBClarity Developer generates SQL code for Oracle, Teradata and SQL Server and works alongside your other development tools.

Why not join the webinar, take a look and see what it's all about? Register here:  Microgen DBClarity Developer Webinar.

Working on a few more demos: EDFs and the SQL Editor

I tried adding a new entry to my blog a few times since my last entry. My plan is to highlight a few key areas in DBClarity Developer so that you can learn a little more about what the product does. I have a list of around 10 topics, which morphs and expands as my ideas change. Having shown you how to “Get Started” in my first video, the next step is to write about the SQL Editor, as described in the presentation, Tutorial 1 - Introducing the SQL Editor , which is on the DBClarity website. There’s the rub..., for those of you who know me and my back ground, I can almost hear you say, “SQL Developer does this and more” or even “TOAD has a richer editor than this”, and so what am I up to? Well, that’s the point, this is a different product.


I have created a new video, Microgen DBClarity Developer: SQL Editor, which instead of focusing on the SQL Editor, shows you where it fits in, and then goes on to show you how you can start creating the visual queries, what we call SQL Rules. Take a look.

In the next video I’ll take a look at how to deploy your project.

A Learning Library!

Oracle has added a new Learning Library which will help you when you're looking for demonstrations or online tutorials. This is a neat (Oracle APEX) application which basically provides a new user interface to the same Oracle by Example (OBE) tutorial content available on OTN. The difference is that you don't need to scroll down through lists of OBEs or search various sites to find online demonstrations.

You can find the Learning Library here: http://otn.oracle.com/obe. The material from my team is under the database section, so you can select that node and then add in your search criteria. For example, just add "model" to the search and you'll see the 3 current Data Modeler tutorials and the latest data Modeler tutorial, published just this week.
We also have a new SQL Developer 2.1 New Features OBE.

The library also lists online demonstrations, which are all typically around 3 - 5 minutes long, focusing on just a small feature area. This means that a search for SQL Developer material will result in tutorials and online demonstrations. It saves you wading through endless pages looking for help. Select "All Content" and add the search SQLDEV and you'll find quite a nice long list... Let us know what you'd like to see next!