The Data Warrior

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

Archive for the tag “Training”

Data Vault 2.0 Online Training – Early Adopter

Finally! People have been asking for this literally for years – to be able to get authentic Data Vault 2.0 (CDVP2) training in an online format.

Please remember there are no refunds and to get the best deal on the Early Adopter offer ($300 off), you must purchase by Friday March 24th, 2017. After that, the price goes up to $997.

So if you have been waiting to get Data Vault 2.o training straight from the inventor, Dan “Data Vault” Linstedt – this is your chance! Get it here.

Happy Vaulting!

Kent

The Data Warrior

NB: I have seen the videos and can say the content is the quality and caliber I expect from Dan and Sanjay, but you should also know that by buying via the links in this post, I will get a cut. Thank you.

P.S. Don’t forget about the upcoming World Wide Data Vault Consortium in Stowe this May. Sign up here.

 wwdvc2017

Want to Learn Something New in 2017?

Happy New Year everyone!

This is the time of year when we all make plans and set goals for the new year, right?

So what are you going to do different this year? How about grow your career by learning something new?

How?

  1. Read a book on an area of tech you are not so familiar with. Cloud perhaps?  My recommendation, of course, is to check out the new Cloud Data Warehouse for Dummies book I mentioned in my post last month. Or maybe one of my ebooks listed on the blog sidebar?
  2. Attend a webinar. My favorite user group, ODTUG, has a continuous lineup of FREE webinars through out the year. You can see the list and sign up here. (I will be giving one next week!)
  3. Attend a conference or meetup.  As I mentioned in my post on staying current, nothing beats meeting and learning from folks face-to-face.  Plan ahead, budget some time and training money to attend one of the many industry events that happen all year. For some ideas, check out my speaking schedule for 2017 with options around the US.

 

So what will it be? If possible try to do at least one of each – read a book, attend a webinar, go to a meetup!

Make 2017 a great year!

Kent

The Data Warrior

P.S. If you plan to attend any of my in-person talks, please drop me a line to let me know! And be sure to follow me on twitter or check my schedule periodically as I am adding new talks and locations all the time.

Data Warrior LLC

 

Fire Sale #2: Loading Your Data Vault with Informatica

As I mentioned the other day, Dan and Sanjay have been hard at work re-vamping the Learn Data Vault site and have relaunched it. In celebration they are offering amazing deals on their world class Data Vault Implementation classes.

The 2nd course that is ready to go is Implementing Data Vault with Informatica. This online course walks you through the details of implementing a Data Vault-based data warehouse using Informatica. It includes a ton of examples and templates that you can use in your own ETL work to make it very easy to crank out your load processes.

You can see the full outline for all the topics and modules here.

The Deal

So the deal is that originally the Retail Price was  $1,497. But right now with the re-launched site, this class is marked down to $997  for a short time (a savings of $500). The price will eventually go back to the higher price.

The Better Deal: A Fire Sale

Starting today until February 15th, Learn Data Vault is having a Fire Sale! You can take another $500 off with this special Data Warrior Coupon Code:  DWFS500OFF.

So with the mark down price plus my coupon you can get the Data Vault Informatica Implementation class for only $497 (a savings of $1,000).

But remember is is only good until February 15 (1 week from today!).

So please sign up ASAP before the coupon code expires.

Data Vault Rules!

Happy Coding!

Kent, The Data Warrior

Data Vault Master (CDVDM, CDVP2)

Would You Like to Load a Data Vault like a Master?

If you are about to embark on a Data Vault project this year, and not quite sure the best way to load your data into a Data Vault efficiently, I have a great opportunity for you.

Dan and Sanjay have been hard at work re-vamping the Learn Data Vault site and are now ready to relaunch with a brand new look and feel.

The first course out of the gate is the SQL Implementation course. This online course walks you through the details of implementing a Data Vault-based data warehouse using plain and simple SQL. These are the same techniques I have been successfully using for over 10 years on my Data Vault (and even Non-DV) projects. I learned them from Dan in my very first Data Vault class and have used them ever since.

They just work!

If you are building on a standard relational database platform (on premises or in the cloud), this class gives you all the patterns and code examples you need to move data into not only Hubs, Links, and Sats but your staging areas as well. It also includes the techniques for implementing very efficient change data capture (i.e., delta detection).

You can see the full outline for all the topics and modules here.

The Deal

So the deal is that originally the Retail Price was  $997. But right now with the re-launched site, this class is marked down to $797  for a short time (a savings of $200). This course has sold in the past for $1497 and they could raise it back up at anytime.

The Better Deal: A Fire Sale

Starting today until February 13th, Learn Data Vault is having a Fire Sale! You can take another $400 off with this special Data Warrior Coupon Code:  DWFS400OFF.

So with the mark down price plus my coupon you can get the Data Vault SQL Implementation class for  only $397 (a savings of $600).

But remember is is only good until February 13 (1 week from today!).

UPDATE: If you are reading this after the sale is over you can still get a discount by using my special blog reader discount code: Kent10S which will get you 20% off.

So don’t delay – sign up for the class today. It is the quickest way for your to get productive with your Data Vault implementation I know. (And it does not hurt that you can uses these techniques for lots of non-data vault systems too. I have.)

Why a Fire Sale?

So if this class is so good, why such great sale?

I asked Sanjay the same thing. This is what he told me:

  1. This is really a re-launch on a new platform and they really want to give it a workout.
  2. There may be some small errors on the site that they missed during QA. (The price will go up once they are sure it is completely error free)
  3. They need feedback on the new site to be sure it is the best it can be and this is the best way to get that feedback quickly – get people using the site!
  4. It’s Valentines Day!

So please sign up ASAP before the coupon code expires.

SQL Rules!

Happy Coding!

Kent, The Data Warrior

Data Vault Master (CDVDM, CDVP2)

SALE: Oracle SQL Developer Data Modeler Jump Start

So in honor of the upcoming #OOW15 and User Group Sunday Symposiums, I decided to put my video workshop for #SQLDevModeler on Sale!

Why use #SQLDevModeler?

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 to look at Oracle SQL Developer Data Modeler (SDDM). Data Modeler has been around for 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. (And it works with MS SQL Server and DB2, not just Oracle.)

#SQLDevModeler is a fully functional 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. You also have options on the type of notation used in the diagrams (i.e., Barker, IE, etc.).

Workshop? What Workshop?

I’m so glad you asked! 😉

Since there was no one around teaching classes on SDDM, I figured I should build one that would be easily accessible and show you exactly how to use the tool for the most common data modeling tasks.

This workshop 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.

In this workshop, I introduce you to the tool and show you how to use some of the cool features I use almost daily. I provide step-by-step instructions on how to use these features.

In this 4+ hour long workshop you will see:

  • How to create new objects from a blank page
  • How to build a logical ERD (with sub-types!)
  • How to reverse engineer and document existing databases
  • How to reverse engineer logical models from physical
  • How to use the visual view builder
  • How to use the interactive view testing tool
  • How to reconcile a model to the database or the database to a model
  • How to generate DDL for multiple RDBMSs (Not Just Oracle!)
  • How to generate a script to change an existing database

Tips, tricks and features I will demonstrate:

  • 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
  • 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, I also give you a live demonstration of important aspects of the tool.

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

So how about a sample?

The platform that we used to deliver the video is pretty darn good, but I figured you might want to see what the content looks like so here are two modules taken right out of the class. The first one talks about using sub views in SDDM, and the 2nd one talks about creating Entities.

Enjoy!

 Subviews

Entities

Sale Coupon!

So ready to sign up?

Great. Go here to get right in!

Normally the price is $1299  (which is MUCH less than you would have to pay me to come to your office and teach you myself), but for a limited time, I am giving a big discount so that even more folks can afford it.

Use coupon code KentSDDM to get $300 off the regular price.

I am sure you will find this a very useful workshop with examples you can use (yes there are a few downloads when you finish the class). The examples alone will save you a bunch of time and money.

But don’t take my word for it:

So sign up today, start watching, then you can ask me questions at #OOW15!

Cheers.

Kent

The Data Warrior

P.S. The sale will not last long, so be sure to jump in now to save $300 while you can. Go on, sign up here (you know you should).

Post Navigation

%d bloggers like this: