technifyed

Microsoft via Microsoft Learn

Optimize vacuum in Azure Database for PostgreSQL

Overview

Azure Database for PostgreSQL uses vacuum and autovacuum to remove rows that have been marked as soft-deleted after an update or deletion.

Syllabus 6

  1. Introduction 5 minutes
  2. Explain the purpose of vacuum and autovacuum 5 minutes
  3. Configure autovacuum server parameters 5 minutes
  4. Exercise: Configure autovacuum server parameters 15 minutes
  5. Module assessment 5 minutes
  6. Summary 5 minutes

Skills you'll practise

Azure Database Postgresql

Advantages and disadvantages

Advantages

  • Free, official and kept up to date by Microsoft.
  • Free sandbox environments for many Azure exercises, no credit card needed.
  • Counts toward Microsoft certification exams (AZ-900, AI-900, PL-300…).
  • From Microsoft, a well-regarded name.
  • Free digital badge you can add to LinkedIn.
  • Completely free.
  • Self-paced: start any time.
  • A clear syllabus (6 parts) you can see before you start.

Disadvantages

  • Mostly reading, not video.
  • Focused on Microsoft products.
  • Short (25 minutes): an overview, not deep coverage.

Some points apply to every course of this kind; see how we rank.

Free, with a free credential

  • Free: Sign in with any Microsoft account.
  • Badge: Finish it to earn a free badge on your Microsoft Learn profile.

Microsoft is in Tier 2: excellent universities and the companies that build the technology of our institution ranking (86/100).

Similar courses

Compare these

Harvard University · YouTube

CS50's Introduction to Databases with SQL

This is CS50’s introduction to databases using a language called SQL. Learn how to create, read, update, and delete data with relational databases, which store data in rows and columns. Learn how to model real-world entities and relationships among them using tables with appropriate types, triggers…

Free video8 videos, 11 hours

Harvard University · edX

CS50's Introduction to Computer Science

An introduction to the intellectual enterprises of computer science and the art of programming.

Free to audit12 weeks, 5 - 14 hours per week

Google · YouTube

Cloud at Google I/O 2024

This playlist brings you all the cloud sessions and keynotes from Google I/O 2024. Whether you're a seasoned developer or just getting started, these videos will equip you with the knowledge - and inspiration - to simplify and scale your next cloud project with newly debuted and improved Google Clo…

Free video24 videos, 14 hours

Google · YouTube

All Google I/O 2022 Sessions

At Google I/O 2022, developers and enthusiasts from around the world came together online and in person to celebrate the latest updates to Google products and services. Hear what's new in Android, Firebase, Flutter, AI/ML, Google Cloud, and so much more and dive into technical sessions and workshop…

Free video138 videos, 50 hours

Harvard University · edX

CS50's Introduction to Programming with Python

An introduction to programming using Python, a popular language for general-purpose programming, data science, web programming, and more.

Free to audit10 weeks, 3 - 6 hours per week

Harvard University · edX

CS50's Web Programming with Python and JavaScript

This course picks up where CS50 leaves off, diving more deeply into the design and implementation of web apps with Python, JavaScript, and SQL using frameworks like Django, React, and Bootstrap.

Free to audit12 weeks, 6 - 14 hours per week

Enter your email and the official page opens. Phone is optional.