The Data Warrior

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

Archive for the tag “Training”

Do you want a Data Vault 2.0 Bootcamp in The Woodlands, Texas?

Survey time peeps!

Simple Yes/No question:

Would you like me to hold a DV 2.0 Bootcamp (and private certification) west of the Mississippi?

If I set one up a in “America’s Hometown” (really it is even trademarked), The Woodlands, Texas (20 minutes north of Houston Bush Intercontinental Airport), would you come?

The Woodlands Waterway and our concert venue The Pavillion

The beautiful Woodlands Waterway and our concert venue, The Pavilion. You can take a water taxi to a concert!

Since I am an authorized DV 2.0 Trainer, I figure it is time I actually teach a class. And why not in my hometown in Texas?

So what is in a DV 2.0 Bootcamp class?

Three days of intense training on all things DV (followed by a chance to become a Certified DV 2.0 Practitioner).  NOTE: If you are new to Data Vault, you must read the Super Charge book before attending the class.

This class covers what you need to know as a practitioner in the world of Data Warehousing and Business Intelligence.  This is our foundational course.  This is a 3 day (in person) course that covers end-to-end best practices.  Major topics for this class are:

  • Architecture – Including NoSQL, Big Data, Hybrid Systems and Relational stores
  • Methodology – Including CMMI, Six Sigma, Optimization, Automation, and Generation
  • Implementation – Including Performance and Tuning, Set Logic, ELT vs ETL, Parallelism
  • Modeling – Including replacing of surrogates with Hash Keys, data layout, data co-location

This class takes you through the why/what/how of Data Vault 2.0.  It includes the coverage of the business justifications, then follows with the technical descriptions of the architecture, implementation, methodology, and modeling.  Included in the topics are reaching agility, practicing Six Sigma, measuring and optimizing at CMMI level 5, the KPA’s and KPI’s of Data Warehousing, and more.

We also discuss the use of Hadoop, and NoSQL platforms along side the relational world.  The objective is to enrich your understanding of how and when to apply Big Data Solutions.  The course finishes with descriptions on ETL and ELT design time paradigms, including templates, best practices and working SQL.  This class is a prerequisite for anyone wishing to achieve DV2.0 Certified Practitioner status.

When:

Late summer – early fall (depending on interest) of 2015

Cost:

TBD based on how much the space costs me here!

But will definitely be less than $3,000.

Where:

Someplace nice and central in The Woodlands within walking distance to great food and drink.

Apartments over looking the waterway that flows to Lake Woodlands. A great natural setting. Not the usual suburban wasteland.

Apartments over looking the waterway that flows to Lake Woodlands. A great natural setting. Not the usual suburban wasteland.

So who is in?

Please respond in the comments so I can tell if I should start setting something up.

Thanks.

Kent

The Data Warrior

P.S. Since you know I am into fitness, we have great options here to exercise here too. MIles of running trails and even kayaking on the waterway.

The Riva Boathouse were you can rent single and double kayaks by the hour (look close and you find a picture of my son and & on the sign from when they first opened).

The Riva Boathouse were you can rent single and double kayaks by the hour (look close, when you are here, and you find a picture of my son and & I on the sign from when they first opened).

End Your Data Modeling Pain

Tired of hand drawn data models, or models drawn in Visio or even PowerPoint?

Still limping along on an old Oracle Designer repository?

Can’t afford the license for your current modeling tool anymore?

Or maybe your shop has no documented data model diagrams at all (horrors!).

Well, if you were an Oracle Designer user and are looking for a replacement data modeling tool, or you are using one of the other mainstream, expensive modeling tools and want a more cost effective alternative, then you owe it to yourself (and your organization) to look at Oracle SQL Developer Data Modeler (SDDM). Data Modeler has been around for over five years now and is up to version 4.1. It really is an industrial strength data modeling tool that can be used for any data modeling task you need to tackle.

As I have mentioned before (many times) in this blog, SQL Developer Data Modeler (SDDM) is a fully functional modeling tool provided for FREE by Oracle. It has many features built in that can be leveraged to capture the design of an existing (probably undocumented) database and re-engineer it or you can use it to design a new database, even a data warehouse from scratch. There are features to apply standards, and then generate DDL to implement your newly standardized design. You can even use one logical model to develop multiple physical models that can be deployed to different RDBMS (like Oracle, SQL Server, and DB2). You even have options on the type of notation used in the diagrams (i.e., Barker, IE, etc.).

Unfortunately there are no comprehensive, end-to-end classes that can teach you how to really get started with SDDM and can point you to some of the awesome features and show you how they work.

Not until NOW!

Announcing my new online class: Introduction to Oracle SQL Developer Data Modeler.

This course will start from a totally blank page and walk you through all the major features and options of the tool to show you how to design build and deploy a database. I provide lots of examples and tips on how to do all this so that you can quickly be productive (while you watch!).

In this class, I will introduce you to the tool and show you how to use some of the cool features I use almost daily. I will provide step-by-step instructions on how to use these features. The class includes both lectures with screen shots and hands on demos of the tool (recorded live by me). Hint: some of my best tips are in the demos.

In this course you will see:

  • How to create new objects (entities, attributes, relationships) from a blank page
  • How to reverse engineer and document existing databases
  • How to reverse engineer logical models from physical to get a clean ERD
  • How to reconcile an existing data model to the database or the database to a model
  • How to generate a script to change an existing database

Tips, tricks and features I demonstrate include:

  • Modifying the delivered reporting templates
  • How (and when) to use the abbreviations utility
  • How to use and apply domains
  • How to create and applying object naming templates
  • How to add audit columns to every table in a model
  • How to add custom design rules for model quality checks
  • How to use the built in quality checks
  • How to use the newest find and extract feature to enable updating table and column comments by end users
  • How to generate a simple data dictionary

As an added bonus, in addition to step by step slides, and the demos, I have included a zip file with example output, templates, and DDL scripts that I created during the demos. You will be able to download these to your machine to try the exercises yourself.

If you have questions along the way, our modern learning management system (LMS) lets you enter your questions in the course comments whenever you want. I will get an immediate email notification so I can promptly answer your questions.

Unlike typical user group presentations, where I can only scratch the surface or show a few tricks, this course contains over four and a half hours of content broken up into bite-sized modules so you can easily digest the detailed information. If it does not make sense, you can simply play the same segment over again and even follow along on using your own install of SDDM.

By the end of the course you will be able to effectively use Oracle SQL Developer Data Modeler for all your data modeling tasks.

So head over to Learn Data Vault and check out the preview video of the class, then sign up and learn. Use my special offer code of GRAZIANO10S to get 10% off.

See you online!

Kent

The Data Warrior

P.S. The current price of the course is the initial sale price. I am not sure when the price will go up but Dan and Sanjay tell me that I set the price too low and they will have to raise it in the near future. So, I would sign up now, before that price goes up.

Free Introduction to Data Warehousing the Data Vault Way

My good friend Dan (@dlinstedt) has put together a sweet set of three videos to introduce everyone to the wonderful world of Data Vault.

When you sign up you will get a set of email messages from Dan discussing the Data Vault Approach to data warehousing. You get access to three videos about the architecture, the methodology, and the modeling technique.

Plus you get free downloads of the first few chapters of the data vault book Super Charge Your Data Warehouse.

So if you have always wanted to learn more about Data Vault, but don’t have the budget for a full on class, this offer will get you headed in the right direction.

Head on over to the Learn Data Vault site now. It is all free.

(NB: this is an affiliate link. If you eventually buy the book or some other training off Dan’s site, I will get a small piece of the action. Not enough to retire mind you, but it might buy lunch.)

The videos are pretty cool. Enjoy.

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

Hurry – Only 24 Hours Left to Get a Free Conference Registration

As I have written before, I love Oracle User Groups.

My two most favorite groups are the Oracle Development Tools User Group (ODTUG) and the Rocky Mountain Oracle Users Group (RMOUG).

These two groups put on what are arguably the best annual conferences for users of Oracle technology – by users, for users.

Over the past 20+ years I have attended most of their events – and NEVER paid a registration fee.

This was very helpful when my boss said there was no money for training. I just said “I get in free”.

So would you like to attend one of these events for FREE?

All you have to do is submit an abstract to present a session. If you get selected, your registration fee is waived. This is worth over $1000.

But you have to hurry, the deadline for submission is Monday October 15th, 2012.

Details:

RMOUG Training Days is  February 11-13, 2013 in Denver, Colorado. (Right in the middle of ski season!)

Go here to submit an abstract.

ODTUG’s KScope event will be June 23-27th in wonderful New Orleans.

Go here to submit an abstract.

I have submitted multiple abstracts to both events.

So what are you waiting for – go submit now!

See you in Denver and New Orleans in 2013.

Kent

P.S. My Kindle ebook  started out as a user group presentation. No telling what you might do with your presentation.

Post Navigation

%d bloggers like this: