Posts in Category: Training

Real World Data Warehouse Class Files 

Sunday, April 5, 2015 11:35:00 PM Categories: Meeting Training

Thanks everybody who came out and joined the learning community and enjoyed the Real Life Data Warehouse build out.

Here's Mike's samples from the class: Class Files.

 

This following April's meeting is Tim Mitchell. More details to come. 

 

Class Begins 9 AM Saturday (March 7) Morning! 

Friday, March 6, 2015 3:31:00 PM Categories: Meeting Training
 

I hope you all benefited from a snow day or two. Or at least I hope you enjoyed the snowy view out the window as you worked from home. 

Class begins at 9 in the morning and you are welcome to bring a lunch. There are plenty of restaurants in the area as well and we will have about an hour break for you to go enjoy one. Class will go till 5 PM. The only caveat is our meeting facility has a door that auto-locks at 1 PM. Please try to be back before the outside doors lock. 

The other thing is you will have limited cell signal in the training lab as it is partially underground. There is wi-fi available.

 

First Saturday of Class Cancelled Due to Weather 

Friday, February 27, 2015 10:13:00 PM Categories: Meeting Training

Sorry everyone, looks like we need to call it a weather day for the first Saturday of the class.

We wanted to do a delayed start, but there's a good chance the ice shell will not be melted by then. We'll see you on the 7th

 

Stay safe and warm and enjoy the snow! 

Winter Weather Advisory: Possible Delays to Class Start 

Friday, February 27, 2015 11:48:00 AM Categories: Meeting Training
Happy snowy Friday!
 
If you have not paused to look out the window, it is beautiful and fluffy white in many parts of North Texas currently. 
 
We are under a Winter Weather Advisory until Saturday and road conditions are expected to get worse. 
 
We are taking a wait see approach on the class in the morning. 
 
We planned to start at 9 AM tomorrow and the following two Saturdays. 
It could be fine tomorrow, but there is a chance we may have to delay start until noon or worse. 
 
Please watch the web sites for weather postings BEFORE you make the trek to South West Fort Worth. 
 
Thanks and see you soon! 
The Folks of the Fort Worth SQL Server Users Group

Three Saturdays of Class: Real World Data Warehouse Build : Feb 28th, March 7 th & 14th 

Wednesday, January 28, 2015 10:10:00 PM Categories: Meeting Training

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

Happy New Year - And Get Well Soon!  

Tuesday, January 13, 2015 10:29:00 PM Categories: Announcement Meeting Training

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

 

Enterprise Information Architecture with Mike Hotek Oct 19th, 26th & Nov 9th 8 AM - 5 PM 

Friday, October 4, 2013 6:21:00 PM Categories: Training

Ah, it's autumn and back to school time with all our friends! The Forth Worth SQL Sever Users Group is here to facilitate a vibrant learning community of information professionals. Mike Hotek is donating his time and vast experience to focus on the fundamental processes that allow you to take data and forge it into actionable information. Any donations for the class will go toward the user group monthly meetings costs (pizza like substances). 

Sign up here to reserve your seat: https://hotekia.eventbrite.com

Day 1 - Oct 19th -  Data Governance

  • Overview
  • Data Governance Program
    • Building a Business Case
    • Charter
    • Roadmap
    • Establishing Metrics
    • Data Architecture
      • Data Modeling
    • Data Quality
    • Data Integration
      • Data Validation
      • Data Lineage
    • Data Management
    • Data Stewardship
    • Master Data Management

Day 2  - Oct 26th -   Enterprise Data Modeling

  • Building a Data Modeling Practice
  • Modeling Tools and Processes
  • Metadata
  • Conceptual Data Modeling
  • Logical Modeling
  • Physical Modeling
  • Data Dictionaries
  • Master Data Modeling

Day 3  - Nov 9th -   Business Intelligence

  • Business Intelligence
    • Enterprise BI Capabilities
    • Enterprise BI platforms
    • Metadata Repositories
    • Data Lineage
  • “Big Data” – what does it REALLY mean to you
  • Data Governance Lifecycle
 
Instructor Bio:
Mike Hotek is the Senior Business Intelligence Architect for CBRE. He has been building SQL Server systems and database management best practices for almost 20 years and has worked with companies across many industries. Mike has delivered hundreds of sessions and training events around the world and has published numerous articles along with 9 books. He is currently working on book two a four book series on SQL Server. Contact URL: www.ChampionValleySoftware.com 

Jump Starting Data Governance 

Tuesday, May 21, 2013 5:48:00 PM Categories: Training

Embarcadero just extended their ER Studio product line to include a piece to capture business rules. If you are involved in or are starting a data governance initiative and want an excuse to enjoy a weekend in Austin, this lunch and learn might be for you. http://forms.embarcadero.com/forms/ERStudioLunchLearnAustin

They will be discussing:

 

  • Obtaining reliable and relevant information via data governance
  • Using ER/Studio for key governance ingredients: enterprise information maps and metadata collaboration
  • Mapping  ER/Studio features to data governance maturity milestones

 

SQL Server 2012 Learning Opportunity on Saturdays in April in Fort Worth with Mike Hotek. 

Friday, March 29, 2013 10:37:00 PM Categories: Training

This is your chance to break past the learning curve and be ahead in your career. Budgets are tight and several people fail to make the case to get adequate training or experimentation time to stay current.

 

These weekend classes are a great way to build a solid foundation to be confident and capable with SQL Server. They also provide a great way to get to know the other SQL Server professionals in the area.

 

Training of this quality and this depth and length does not come around for free very often.  This will be the only class from Mike Hotek this year.

 

The course material will follow this book: SQL Server 2012 Data Design and Retrieval by Mike Hotek

 

You may purchase the class text book http://championvalleypress.com/data-design-and-retrieval.aspx.

You may still reserve your seat http://hoteksql.eventbrite.com.

 

For those of you who have signed up already, can't wait to see you and here are a few things to remember:

 

  • In the training lab your cell phones will have very limited signal.
  • Mark has graciously made wireless available, but that many laptops is a challenge for the access point.
  • There are vending machines and microwaves upstairs.
  • We break for lunch and go off site. This is a great time to get to know your classmates.
  • If you bring your own coffee and snacks, please be respectful of the space we have been granted for the class and cleanup after yourself.

 

Class dates: April 6, 13, 20 & 27 (all four Saturdays)

Class Times: 9 AM -  4 PM

Return of the Weekend SQL Server Classes! 

Saturday, March 16, 2013 7:13:00 PM Categories: Meeting Training

We are delighted to announce we are cancelling the monthly meetings in March and April.

 

We are happy about this because in replacement, we are offering you the return of the Weekend SQL Server classes! Instead of a small lecture, we're offering you 24 hours of solid SQL Server 2012 education!

 

Seating is limited, so reserve your spot here:  http://hoteksql.eventbrite.com

 

 

Mike Hotek is donating his Saturdays in April to the SQL community!

 The weekend SQL classes are back for a SQL Server 2012 round! For the veterans who have drank from this particular flavor of fire hose, we've missed you and we can't wait to see you again.

 We are excited to be able to invite you all back for four Saturday classes in April. They will be April 6, 13, 20 & 27 from 9 am to 4pm.

 For those of you who have not yet experienced Mike Hotek's training, what ever your experience level you will benefit from spending time talking about SQL Server with someone who has tirelessly worked with this product since its very beginning in more industries and sizes of environments and countries than you can imagine. 

The class is designed to go through the first book in a series of four. The book will be available just in time for the class. Check here at the end of March for class materials: http://www.championvalleypress.com/books.aspx

 

SQL Server 2012 Data Design and Retrieval

Courseware Modules:

 

Installation and Configuration

 

  • SQL Server Tools
  • Creating Databases
  • Database Structure
  • Contained Databases  
  • Designing Tables
  • Data Modeling
  • Data Types
  • Hierarchy
  • Constraints
  • FileStream
  • FileTable
  • Storage Engine Internals
  • Data Manipulation
  • Manipulating Hierarchies
  • Bulk Loading Data
  • Change Tracking
  • Transaction Management
  • Locking
  • Isolation Levels
  • Row Versioning
  • Data Retrieval
  • Joins
  • Subqueries
  • Aggregates
  • Advanced Data Retrieval
  • Set Operators
  • Table Expressions
  • Window Functions
  • XML
  • Spatial Objects
  • Spatial Calculations
  • Geography Data
  • Indexes
  • Clustered
  • Non-Clustered
  • Filtered
  • Covering
  • Statistics
  • Index Internals
  • Forwarding Pointers
  • Indexing Hierarchies
  • XML Index
  • Selective XML Index
  • Spatial Indexes
  • Index Maintenance
  • Columnstore Indexes
  • Full text index
  • Word Breakers and Stemmers
  • Stop Lists
  • Document Properties
  • Querying Full Text Data
  • Semantic Search
  • Partitioning
  • Functions
  • Schemes
  • Partitioning Tables and Indexes
  • Modifying Partition Functions
  • Manipulating Partition Tables

 

Site Map | Printable View | © 2008 - 2017 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund