Well wishes to our Mascot who is recovering. Let's all wish him a much better rest of the year.
We normally facilitate a small segment of time the third Wednesday of the month to get together and learn about SQL Server and related database technologies.
We want to start out the first quarter of 2015 a little differently How about we trade you three Wednesday evening 1 hour sessions for 3 full day training classes? Would you take that trade?
We are finalizing another round of Saturday classes. Back by popular demand, Mike Hotek is giving up more of his weekend time.
The 3 days of topics coming the last Saturday in Feb and the first two Saturdays in March:
Real World Data Warehouse Build
You’ve seen plenty of theoretical articles, lots of demos of disconnected snippets of solutions. We’re going to take all of these items plus a lot more and put them together into something useable and practical to build a real solution from start to finish. This class will provide the knowledge necessary to implement all of the processes you need to quickly, flexibly, and incrementally build out a data warehouse. You don’t need weeks of contiguous blocks of time, you just need a few hours here and there, directed appropriately to have a large impact. In this class we will cover the following:
Team Foundation Server (TFS)
What it is, how you use it, and why you need it (or a tool like it)
Source code control
What it is, how to implement it, how to manage your source code, branching/merging
Work items
Planning your work
Packaging into deliverable components (user stories)
Breaking down business deliverables into technical tasks (tasks)
Estimating work
Work flows
Data modeling
Building out a warehouse model
Source control
Data Dictionaries
Tagging
Automation macros
Basic ETL framework
Building your T-SQL layer
Merge procs
Watermark procs
Code generating the T-SQL layer
Unit testing
What is it, why you do it, how you do it
ETL workflows
Code generating the T-SQL layer
Code generating your SSIS packages using Biml
SSIS deployments
Parameters
Environments
References