The Data Warrior

Changing the world, one data model at a time. How can I help you?

The 1st Tip is Free: Oracle SQL Developer Data Modeler

This year’s ODTUG KScope conference is less than a month away and I am ready to get to New Orleans and meet up with all my friends and colleagues to talk shop and learn some new things.

So in hopes of getting you to attend, I will share with you one of my productivity tips for using SQL Developer Data Modeler (SDDM).

DDL Previewer

I love this tool. I use it every single day in my work building data warehouses for my clients.

Really.

It’s easy – just right click on the table (or view) you want to check and Voila!

Right mouse over object to get preview option

Right mouse over object to get preview option

Once you pick “DDL Preview”, then you get the DDL in another window.

Example of DDL script in Preview Window

Example of DDL script in Preview Window

With this you can:

1. Check the design to see if it is what you wanted/expected.

2. Copy and paste it to a worksheet in SQL Developer where you can then execute it (if you have the rights!).

One more cool thing is that if you leave the DDL window open, you can now click on any other object in the open diagram and instantly see the DDL for that object.

So there you go – really 3 tips for the price of one!

If you want more, I will be presenting my Top 10 SDDM Tips and Tricks at KScope13 in New Orleans in a few weeks. So go register now!

See you in NOLA!

Kent

 

Are you certifiable?

Just a quick note to let everyone know that Dan Linstedt, (inventor of the Data Vault Model and Methodology) has announced that he will be teaching a live Data Vault 2.0 Certification Class on July 29th in St Albans, Vermont.

This class will cover all the new DV2.0 standards which incorporate big data, and NoSQL as options for implementation.

So do you have what it takes to become a Certified Data Vault Practitioner – CDVP2?

Check out these details:

Concepts that are covered include the following:

  • Implementation (ETL & SQL) best practices – structured, performance and restartability
  • Data Integration Strategies – real time, big data, and unstructured
  • Overview of Architecture – 3 tier systems architecture
  • Overview of Methodology – agile project planning & delivery
  • Overview of Data Vault Modeling – DV tables, patterns, business vault
  • Foundation of NoSQL & Big Data – where it fits, key structures, parallel loading
  • DV2.0 Methodology (Agility, Roles and Responsibilities, Architecture, CMMI Level 5)
  • DV2.0 Structure Changes
  • Managed Self Service BI
  • Loading Templates (including DV2.0 performance improvements)
  • Business Vault – introduction and overview, application & use

The new course relies heavily on the Super Charge your Data Warehouse book. Students must have completed reading the book before attending class. The class will spend minimal time covering the structural details of the Data Vault itself, and will focus more on the application of the Data Vault, the methodology (or project implementation), and the overall architecture. Including a look at managed self-service BI.

via Data Vault Certification | Class Descriptions.

Get the time, place, costs etc. on the Data Vault Certification site.

Join the elite ranks of certified Data Vault Practitioners.

Get certified!

Take care.

Kent

A New Limerick to start your week…

This was an assignment my son did for his 3rd grade class. They were studying styles of poetry. This one he was proud of and asked me to publish for him. Enjoy.

A New Limerick

by Biaggio Graziano (copyright 2013 all rights reserved)

Once there was a dog and a frog

They live in a log in a bog

With a bird named Bob

Who has no job

They all have a big blog

 

Paralyze resistance…

Paralyze resistance with persistence.

— Woody Hayes (College football coach)

Resistance is futile

— The Borg (Intergalactic marauders)

By failing to prepare

By failing to prepare, you are preparing to fail.

– Benjamin Franklin

Post Navigation