مشخصات فیلم
-
7528
-
2807
-
0
-
0.0
-
0
آموزش SQL Server Continuous Database Delivery بوسیله Flyway
با مشاهده این دوره آموزشی استفاده از Flyway را به منظور Continuous Database Delivery دیتابیس هایSQL Server را خواهید آموخت. بوسیلهContinuous Database Delivery می توان بسیاری از مشکلات مرتبط با تغییرات پایگاه داده و ارائه آن به مشتریان را رفع نمود.
این مجموعه آموزش ویدیویی محصول موسسه آموزشی PluralSight است که به صورت کاملا رایگان به همراه فایل های تمرینی و اسلایدهای مدرس و به مدت زمان 6 ساعت و 25 دقیقه در اختیار علاقه مندان قرار می گیرد.
در ادامه با برخی از سرفصل های درسی این مجموعه آموزش SQL Server آشنا می شویم.
Continuous Database Delivery
Welcome to the Course
Shared Development Databases
What Changed?
Manual Database Updates
Continuous Database Delivery
What Makes This Approach Worthwhile?
What You'll Learn in This Course
Tracking Changes
Introduction
Tracking and Applying Changes
Introducing Flyway
How We're Going to Build a New Payroll DB
Demo: Setting up SQL Server Locally for a Dedicated Dev DB
Demo: Downloading Flyway
Demo: Creating a payroll DB and Connecting Flyway to the DB
Demo: Adding a First Employee Table
Demo: How to Name Change Scripts
Demo: Adding a Second Titles Table with Data
Demo: Dropping and Recreating Dev DBs at the Push of a Button
Demo: Adding Table Relationships with Employee Titles
Demo: Adding an Employee Positions View
Recap
Development Workflow
Introduction
A Robust Development Workflow
Demo: Push Button Backup
Demo: Push Button Restore
Demo: Trying Out the Development Workflow
Careful with Database Name in Generated Scripts
Demo: What Happens When a Migration Fails?
Demo: How to Correct a Mistake in a Migration
Recap
Reverse Engineering Dev DB Changes
A Robust Reverse Engineering Workflow
Demo: Creating a Comparison DB from a Dev DB Backup
Demo: Trying the Reverse Engineering Workflow
Demo: Creating a Comparison DB From Migrations Alone
Recap
Pulling Changes
Introduction
Safely Applying Changes
Demo: We've Been Trolled
Demo: Finding Out About Changes on App Startup
Demo: Migrating Databases on App Startup
Demo: Catching Changed Migrations on App Startup
Two Cooks in the Kitchen
Recap
Delivery Workflow
Introduction
An Overview of CI and Database Changes
Demo: A Script to Test Database Changes
Demo: Setting up TeamCity to Test Database Changes on Checkin
The Sky's the Limit of What You Can Test in CI
Simulating a Production Database Release
Demo: Using TeamCity to Simulate a Production Release
Recap
Transition Existing Databases
Introduction
A Transition Strategy for Existing Databases
What We're Going to Do in This Module
Demo: Setting up a Dev and Prod Database
Demo: Step 1 Baselining Prod
Alignment Strategies
Demo: Step 2 Aligning Dev to Prod
Demo: Step 3 Writing Change Scripts
Demo: Step 4 Marking Dev as v2
Demo: Step 5 Marking Prod as v1
Demo: Step 6 Migrating Prod to v2
Detecting Drift in Production
Recap
Rethinking How We Develop
Introduction
Delivering Frequently
Incentives to Rally Support
Code Based Migrations
Creative Change
Down? What Does Rollback Look Like?
What About Branching?
What Next After This Course?
| دانلود آموزش SQL Server Continuous Database Delivery بوسیله Flyway بخش اول | |
| دانلود آموزش SQL Server Continuous Database Delivery بوسیله Flyway بخش دوم | |
| دانلود آموزش SQL Server Continuous Database Delivery بوسیله Flyway بخش سوم |