NZ$317.50 – NZ$437.10

Creating a Database Deployment Pipeline Using DevOps Processes - 31 August...

Event Information

Share this event

Date and Time

Location

Location

Unitec

139 Carrington Rd, Mount Albert

Auckland 1025

New Zealand

View Map

Event description

Description

Abstract:

In this all day training session you will learn the importance of getting both your application and database code into version control, how various tools can be used for automated continuous integration processes that will then feed into an automated release & deployment process for your database.

The demonstrations will take a database based application and deploy it in a Continuous Delivery pipeline utilising industry tools, such as SQL Server Data Tools (SSDT), Redgate SQL Toolbelt, Visual Studio Team Services (VSTS), Git source control, Octopus Deploy, Docker and the Azure platform. The demonstrations will showcase alternative methods that can help achieve a Continuous Delivery deployment pipeline.

DevOps has revolutionised software development and deployment, where companies have utilised Continuous Integration and Continuous Delivery to improve the speed and quality of their deployed applications in production.

DevOps does not just relate to Application Developers.

For too long Database Developers and Database Administrators have thought that the efficiencies and gains of implementing DevOps and agile principles are too hard for databases. Data is a key component of any application, changes in a database can affect the whole system, if the database is neglected this can result in it being the weakest link in a deployment pipeline.

Because application changes are not being synchronised with the database and the lack of automated versioned changes the efficiencies gained in application deployments can be lost when it comes to deploying to the database.

Modules:

Module 1

Introduce DevOps principles.

Module 2

Database Lifecycle Management, source control and connecting a database to it.

Module 3

Infrastructure as Code, Test Driven Development & Continuous Integration – building databases from code and automating builds using source control.

Module 4

How to implement Continuous Delivery across multiple staging environments.

Module 5

Using Containers and Azure in a database deployment pipeline.

Module 6

Creating a Database Deployment Pipeline with various DevOps tools.

Goals:

* Understand what DevOps is and how it can improve the quality of your software.

* Understand the challenges of database development using DevOps.

* Understand Test Driven Development and it can be applied to database code.

* Understand how to implement a Continuous Delivery process for databases using industry standard tools.

* Understand how to build a fully automated deployment pipeline with containers.

BIO: Hamish Watson (t | b)

Hamish is a Systems Management Specialist, VMware Expert and Microsoft Data Platform MVP with a passion for efficient database & application deployment using DevOps methodologies. His current role is contracting to SQL Masters Consulting as a DevOps Consultant.

He has 20 years in managing large scale systems built on the SQL Server platform. He has been managing SQL Server since SQL Server 2000 and pragmatic approaches to delivering business value to clients is his career passion.

Educating and helping others learn is a driver for Hamish and he is a PASS Chapter Leader, International speaker and a repeat guest lecturer at a local university

Cancellation:

Cancellation up to 5 weeks before the event: fully refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Cancellation from 2 weeks before the event: 100% cancellation charge, 0% refunded.

In case that cancellation happens from RADACAD you will be offered to choose either full refund or transfer to another date.

Transfer:

transfer can be done to another colleague at no extra charge.

No Show:

No fee will be refunded for no show.














Share with friends

Date and Time

Location

Unitec

139 Carrington Rd, Mount Albert

Auckland 1025

New Zealand

View Map

Save This Event

Event Saved