Redgate Professional Services Training Courses

This Course Description sets out the description of each of the Training Courses as selected by You on Your Redgate Quote and Statement of Services, and forms part of and is incorporated into Your Professional Services Agreement. Each Training Day purchased shall be for a certain Software as determined by You and agreed in the Statement of Services. Where You have not purchased the full Training Course, the Parties shall mutually agree the topics that shall be included in the Training Day(s) purchased by You as set out in the Statement of Services.

1 Interpretation

1.1 Capitalized terms used in this Course Description, unless specifically defined in this Course Description, have the meanings given to them in the Terms and/or the SOW.

2 Attendee Recommendation

2.1 While there is no minimum knowledge requirement, the Training is primarily aimed at Users who are data governance or IT professionals.

2.2 The following would also be advantageous:

(i) some experience working with SQL Server and SQL Server Management Studio; and

(ii) some awareness of T-SQL syntax, SQL and Server performance optimization.

3 Training Recordings

3.1 Training sessions can be recorded by Us or You on request. If recorded by Us, the session will be made available to You after the conclusion of the session in a timely manner, with recordings stored for 365 days. If this option is selected, please take note of the data disclaimer that appears when recording is started.

4 Course Description

4.1 Subject to the provisions of paragraph 1 of Part C of the SOW, the Training Package comprises the Training Days listed below. The relevant Training Days shall apply to You as selected by You and as specified in Your Redgate Quote and/or Statement of Services.

4.2 Redgate Monitor. Where You have selected either Redgate Monitor Standard, Redgate Monitor Enterprise or SQL Monitor the following Course Description shall apply:

Training Day 1: Redgate Monitor

• Installation Architecture: Unboxing Redgate Monitor;
• Estate Overview: Using the home tab to gain rapid insight;
• Alert Management: Manage alerts for timely, quality, and actionable notifications;
• Performance Analysis: Investigate past performance events;
• Reports: Deliver regular reports against key performance metrics; and
• Estate Management: Understand your estate, and manage consistent configuration, storage, backups, patching etc.

4.3 Flyway. Where You have selected either Flyway Teams or Flyway Enterprise the following Course Description shall apply:

Training Day 1: Flyway Fundamentals and Developing Databases with Flyway

Summary of Training Day 1: This Training Day introduces Users to Flyway and shows how Flyway can help Users to develop Your databases.

We will cover the following components:

1. Database DevOps Primer;
2. Introducing Flyway and its key components;
3. Running Flyway commands;
4. Developing databases with Flyway, using Flyway Desktop, managing deployment scripts, working with shared and delicate databases and integrating with task management tools;
5. Alternative ways to invoke Flyway;
6. Using Flyway AutoPilot; and
7. Integration with Test Data Manager.

Training Day 2: Flyway's Core Concepts, Deploying to Production and CI/CD with Flyway

Summary of Training Day 2: This Training Day gives Users the chance to take a deeper dive into Flyway, demonstrates how to deploy to production and how Flyway can be used with CI/CD.

We will cover the following components:

1. Flyway's Core Concepts:
• Safety 2.0, Resilience, and DORA Metrics Primer
• How Flyway works "under the hood"
• Baselining
• Managing static data
• Patterns for re-ordering work: Branching, Cherry Picking, and Deployment Rules
• Checking and reporting. Reviewing deployments, both early and late
• Linting, code analysis, and warnings
• Squashing migrations and re-baselining
• Managing transactions
• Backward compatibility and near-zero downtime deployment patterns
• Legacy challenges: Tips and tricks
2. Deploying to Production and CI/CD with Flyway: Managing parameters and environments
• Secrets Management
• Running automated builds and deploys using GitHub Actions
• Managing build agents
• Deployment Reports
• Code Analysis
• Drift tests
• Dry runs
• Hot fixing
• Managing failed deployments
• Integration with SQL Monitor

Your Responsibilities: You will:

• Ensure that all Users of Training Day 2 have attended and completed Training Day 1.
• For the HANDS-ON-LABS, attendees should have the following:
• GitHub account
• Git installed on local machine
• Flyway installed on local machine
• Access to development copy of your database
• Flyway desktop
• Ability to open a remote desktop connection to a VM that is provided by Redgate, and hosted in AWS

Please Note. The HANDS-ON-LABS are designed based on the assumption that attendees can drop and recreate development databases. Under no circumstances should live production databases be used for this training.

Training Day 3: Flyway Implementation – Pair Programming

Summary of Training Day 3: This Training Day 3 gives Users the chance to put into practice the knowledge and skills gained on Training Days 1 and 2, and to apply them to their own database schemas, under Our guidance.

We will cover some or all of the following steps:

1. Scoping: As a group, we will discuss what we believe we can achieve in a single day.
2. Project set up: Based on the scoping step, we will configure a Flyway project for an existing customer database.
3. Automation: Based on the scoping step, we will attempt to automate some Flyway processes, for example, a CI/CD build or deployment.

Your Responsibilities: You will:

• Ensure that all Users of Training Day 3 have attended and completed all prior Training Days.
• Ensure that Users have prepared one or more small sample database(s) to be used for the training. These database(s) must NOT be live production database(s). Ideally, customers would have a backup close to hand so they can easily drop and recreate their database(s) in a suitable development environment in case any mistakes are made during development work. For the avoidance of doubt, any sample database(s) or backup must not contain any Personal Identifiable Information.
• Ensure that Users already have Flyway Desktop and the Flyway CLI installed in their environment.

4.4 Redgate Test Data Management. Where You have selected either Redgate Test Data Manager or Redgate Test Data Manager Data Treatment the following Course Description shall apply:

Training Day 1: Scrubbing data

Summary of Training Day 1: This Training Day is dedicated primarily to data privacy and compliance concerns.

We will cover the following components:

• Primer: Safety 2.0, Data Privacy, and Compliance 101
• Data classification
• Data subsetting
• Static data masking

Training Day 2: Provisioning data

Summary of Training Day 2: This Training Day 2 is focussed on development and testing concerns. How do you make appropriately scrubbed data images available to developers and testers.

We will cover the following components:

• Primer: DevOps, and the benefits of rapid self-service, dedicated environment provisioning
• Test Data Manager Cloning Cluster
• Core architectural components
• Installation options
• Build your first data-image
• Build your first data-container
• Saving work, reverting, and branching, on data-containers
• Integration with Flyway

Training Day 3: Automating Test Data Manager

Summary of Training Day 3: This Training Day 3 is dedicated to real-world implementation concerns.

We will cover the following components:

• Overview of the Test Data Manager development lifecycle
• Automating Test Data Manager
• Automating image creation
• Automating environment creation using git hooks
• CI/CD with Test Data Manager and Flyway
• Planning/understanding your implementation
• Time reserved to discuss/plan your own Test Data Manager implementation/roll out

4.5 SQL Provision. Where You have selected either SQL Provision, Data Catalog or Data Masker the following Course Description shall apply:

Training Day 1: Identifying and Anonymising Data – Introduction

Summary of Training Day 1: This Training Day covers the core technical and legal challenges associated with test data management solutions. It also teaches Users how many of these challenges can be met using Data Catalog and Data Masker.

We will cover the following components:

1. Introduction to test data management solutions (at a general level) and to Redgate's Test Data Manager Solution;
2. Data discovery and classification with Redgate's Data Catalog;
3. Data anonymization and Redgate's Data Masker core concepts;
4. Building your first masking set (HANDS ON LAB);
5. Redgate's Data Masker: advanced features and best practices; and
6. Tuning an existing Masking Set (HANDS ON LAB).

Please Note. The HANDS-ON-LABS are designed based on the assumption that attendees can drop and recreate development databases. Under no circumstances should live production databases be used for this training.

Training Day 2: Identifying and Anonymising Data – Pair Programming

Summary of Training Day 2: This Training Day gives Users the chance to put into practice the knowledge and skills gained on Training Day 1, and to apply them to their own database schemas, under Our guidance.

We will cover the following components:

1. Scoping: As a group, we will discuss what we believe we can catalog and mask in a single day.
2. Cataloging: Based on the database, schema, or set of tables we defined in our scoping exercise, we will catalogue all the columns using Redgate's Data Catalog.
3. Masking: Based on the scope defined above, and the catalog we've created, we will create a masking set together that effectively anonymises the data.
4. Optimization: Where necessary, we will practice optimizing our masking set to perform effectively on large quantities of data.

Your Responsibilities: You will:

• Ensure that all Users of Training Day 2 have attended and completed Training Day 1.
• Ensure that Users have prepared a small sample database, or a set of small databases which is visible in both Data Catalog and Data Masker. These databases must NOT be live production databases. Ideally, customers would have a backup close to hand so they can easily drop and recreate their database(s) in a suitable development environment as they build and optimize their masking sets. For the avoidance of doubt, any sample database or backup must not contain any Personal Identifiable Information.
• Ensure that Users already have Data Catalog installed in their environment, and the Redgate's Data Masker running on their workstation.

Training Day 3: Self-Service Deployment of Virtualized Test Data

Summary of Training Day 3: This Training Day is about making test data available to users for development and testing purposes.

We will cover the following components:

• An introduction to DevOps, self-service environment provisioning, and virtualization;
• Redgate's cloning technologies;
• Building your first data image (HANDS ON LAB);
• Building your first clone (HANDS ON LAB);
• Cloning best practices and common workflows/development lifecycles; and
• Automating image creation (HANDS ON LAB).

Please Note. The HANDS-ON-LABS are designed based on the assumption that attendees can drop and recreate development databases. Under no circumstances should live production databases be used for this training.