We're switching up the format for the first quarter of 2015. We're trading three monthly meetings for three full training days!
Mike Hotek is donating more time to the local SQL Community by teaching the class. Other people are donating their time and efforts to facilitate space and the rest of the event.
We're not charging for the class, but we are accepting donations to off set the monthly meeting costs.
We're here to be a part of a professional learning community, not to sell you something. But having said, that, please do sign up HERE as seating is limited.
We'll be meeting three Saturdays in a row from 9 AM to 5 PM on Feb 28th, March 7 th & 14th.
Be sure to thank Mark as we will be in our usual location for the class.
Class Description:
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