Training teams and building resilience to inevitable churn over time

• Ensuring more than one permanent staff member understands every capability, so no one is indispensable.

• Training as we learn and implement together, making time for training and knowledge share every week.

• Embedding a culture of teaching as-you-learn, rather than once-you’ve-learnt is key.

• People move on once-they’ve-learnt, and teaching as-you-learn is effective.

• But it requires a culture where it’s okay to fail: fail-fast, fix-fast, insist-on-quality --> Deliver-Fast.

Syllabi (I Build New Courses as required, even whilst Investigating New Technologies myself)

• Training: SQL

  • Overview

  • SQL Server Engine Install

  • SQL Server Management Services Install

  • The Powershell Method: Labs

  • Database Diagrams

  • Automatic Database Diagrams

  • The Select Statement

• Training: Data Modelling

  • The Relational Model

  • SQL Demonstrators

  • Normal Forms

  • SQL Demonstrators

  • Kimball DWH

  • SCD Loads

  • SCF Loads

  • Collapsed SCD Loads

  • SQL Demonstrators

  • Reviewing the Difference in Representation: Normalised Data Stores v Kimball DWH

  • Erwin Data Modeller Tool

  • Erwin Templates

  • Importing Existing Models to Erwin

  Training: Performance Tuning on SQL Server

  • Training

  • Practice

• Training: Introduction to Azure

  • An Overview of Azure

  • Creating Azure Accounts and Subscriptions

  • Azure DevOps Service Creation

  • Infrastructure-As-Code: Powershell7, Biceps, Terraform, Blueprints, Azure Landing Zones

  • Microsoft Learn

• Training: Git and DevOps

  • TBC

• Training: Good Team Behaviours (By continual demonstration)

  • Learning on the Job

  • Sharing Knowledge (Even as you learn)

  • Consolidating Prototype Code

  • Using Microsoft Learn

• Example Training Content

  • An Overview of Azure.doc

  • The Powershell Method & Automatic Generation of Database Diagrams

  • Normalisation Overview