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: https://github.com/openupthecloud/db-migration-demo

—

▶ 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:

https://geni.us/bonso-practice-exams

https://geni.us/stephane-mareek-ccp

https://geni.us/stephane-mareek-dev

Why I recommend Stephane and Jon’s courses:

https://openupthecloud.com/aws-exam-best-resources/

▶ 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.
https://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 YouTube to help you complete the challenge. There is a book (it’s optional), but I strongly recommend it. Get the “Cloud Resume Challenge” book:
https://geni.us/cloudresumechallenge

▶ CLOUD BOOKS & COURSES COURSES

For my full set of recommended cloud books, courses, best monitors, keyboards and everything else, check out:
https://openupthecloud.com/recommended-resources/

—

FIND OUT MORE:
Website: https://openupthecloud.com
About Me: https://openupthecloud.com/about

LET'S CHAT
Instagram: https://www.instagram.com/openupthecloud
Twitter: https://twitter.com/openupthecloud
Twitter (personal): https://twitter.com/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.