Database DevOpsSQLMaestros Admin2020-08-25T17:16:18+05:30
Creating a Database Deployment Pipeline Using DevOps Processes (Online)
This Master Class will be delivered by Hamish Watson
|Friendly Title ||Database DevOps|
|Class Title||Creating a Database Deployment Pipeline Using DevOps Processes|
|Trainer||Hamish Watson (New Zealand)|
| Delivery Type|| Online|
|Delivery Format||Total 8 hoursTwo consecutive days5 hours each day with one-hour break in between|
| Price|| Coming Soon|
* Conversion rate of INR 70 per USD has been taken into consideration
* For Indian Credit Cards, 18% GST will be charged extra
* Group discounts available
|Pre-requisites||Knowledge of SQL ServerKnowledge of TSQLEverything else will be explained and demonstrated|
|Key Highlights||Being able to get your database into source control easilyBeing able to automate the deployment of changes to your databasesBeing able to reliably deploy changes to your databasesBeing able to implement unit testing for your databases|
|Takeaways||Understand what DevOps is and how it can improve the quality of your softwareUnderstand 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.|
|Course Outline||Module 1: Introduce DevOps principlesModule 2: Database Lifecycle Management, source control and connecting a database to itModule 3: Infrastructure as Code, Test Driven Development & Continuous Integration – building databases from code and automating builds using source controlModule 4: How to implement Continuous Delivery across multiple staging environmentsModule 5: Using Containers and Azure in a database deployment pipelineModule 6: Creating a Database Deployment Pipeline with various DevOps tools|
|Demos||Demo 1 – Adding a database to Source ControlDemo 2 – Creating Continuous Integration Build pipelineDemo 3 – Creating Unit Tests in SQL ServerDemo 4 – Looking at Infrastructure as CodeDemo 5 – Automated Unit Tests in Continuous IntegrationDemo 6 – Creating Continuous Delivery PipelineDemo 7 – Different industry tools that achieve DevOps for Databases|
|Trainer’s Bio||Hamish is a Microsoft Data Platform MVP with a passion for efficient database & application deployments using DevOps methodologies.|
He has formed his own company – Morph iT – based in Christchurch, New Zealand and provides consultancy services for SQL Masters Consulting – who are based in Brisbane, Australia.
He has 20 years IT experience in managing and deploying large scale databases on SQL Server technologies. He has been managing SQL Server since SQL Server 2000 and pragmatic approaches to delivering business value to end users 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.
|SQLMaestros Contact Details|| Email: Classes@SQLMaestros.com|
Phone: +91 9606482131 / +91 9606482133