Database Migrations: What A Cloud Engineer Should Know

In this episode of ☁️ You Don't Know What You Don't Know ☁️ a series where we talk about advanced topics of cloud that you can use to extend your projects and talk about in your interviews, we talk about Database Migrations, what they are, and why they're important 🚀
00:45 - What is a Database Migration
01:07 - Manual vs Automated Database Migrations
01:20 - Features Of A Database Migration Tool
01:30 - Migrating Up & Down DB Versions
01:51 - Managing The "State" Of DB Migrations
02:06 - Database Migration Locks
02:30 - Demonstration Repo
02:39 - Knex.js Introduction
02:50 - Postgres Introduction
03:07 - Gitpod Introduction
03:29 - Running Postgres in Docker Compose
03:42 - Using PSQL To Navigate Postgres
04:43 - Running A Knex.JS Migration
05:41 - Database Schema Rollbacks
Code: github.com/openupthecloud/db-...
-
▶ A PRACTICAL START WITH CLOUD / AWS
I highly recommend Stephen Mareeks AWS courses. If you’re a total beginner I recommend the “Certified Cloud Practitioner” otherwise the “Associate Developer”. If you plan to take the exam, I also highly recommend Jon Bonso’s practice exams:
geni.us/bonso-practice-exams
geni.us/stephane-mareek-ccp
geni.us/stephane-mareek-dev
Why I recommend Stephane and Jon’s courses:
openupthecloud.com/aws-exam-b...
▶ WRITE A CLOUD RESUME THAT LANDS YOU THE JOB
There is no better book which explain Tech Hiring and how to write a resume that passes tech screening processes than “The Tech Resume: Inside out”. I am referenced in the book and my review (Twitter) is on the homepage. It’s free if you’re unemployed and is priced based on your location.
geni.us/techresumeinsideout
▶ BUILD YOUR RESUME (AS A PROJECT) USING CLOUD TECHNOLOGY
The “Cloud Resume Challenge” is a 12 step. I love the challenge, I’m an active member of the Discord, and I have a whole playlist on KZbin to help you complete the challenge. There is a book (it’s optional), but I strongly recommend it. Get the “Cloud Resume Challenge” book:
geni.us/cloudresumechallenge
▶ CLOUD BOOKS & COURSES COURSES
For my full set of recommended cloud books, courses, best monitors, keyboards and everything else, check out:
openupthecloud.com/recommende...
-
FIND OUT MORE:
Website: openupthecloud.com
About Me: openupthecloud.com/about
LET'S CHAT
Instagram: / openupthecloud
Twitter: / openupthecloud
Twitter (personal): / loujaybee
Legal Disclaimer: These videos are for education purposes only. I am not responsible for any incurred costs or damages from following any of these tutorials. Follow the tutorials at your own risk, taking necessary precautions for cost management, security, etc.

[@dassyareg7587]

Just the explanation I need right now. Thanks.

[@openupthecloud]

I hope you liked this first episode in the "You Don't Know What You Don't Know" series! Hopefully, it makes it easier to understand some of these commercial practices like database migrations! 🚀🚀🚀 What other topics would you like to see me cover? Let me know 👇👇👇