This blog is mostly about Oracle development tools; the early posts are about Oracle SQL Developer and SQL Developer Data Modeler written as product manager for these products. There are also the occasional forays into travel, conferences and a few mentions of the Delhi missions done. In 2011 I left Oracle, spent a few more years in IT and then switched completely. I’m now a full time picture framer. The blog remains, with no updates, in case there is still something of interest here.
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.
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.
Posts
