technifyed

Microsoft via Microsoft Learn

Tune queries in Azure Database for PostgreSQL

Overview

Relational databases store many different types of data for many different types of applications. Some databases have thousands of users and some have just one user. Some tables have tens of rows while others have millions of rows. Some data is unique while other data is duplicated. All of these va…

Syllabus 6

  1. Introduction 5 minutes
  2. Understand statistics 5 minutes
  3. Assess query performance with the Query Store 5 minutes
  4. Exercise - Assess query performance using Query Store 20 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 (30 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

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

Harvard University · YouTube

CS50 Fall 2023 - Lecture 7 - SQL (live, unedited)

*** This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming. *** TABLE OF CONTENTS 00:00:00 - Introduction 00:15:37 - Flat-file Databases 00:48:04 - Relational Databases 01:12:06 - Break 01:23:44 - Halloween Costume Contest 01:2…

Free video2.5 hours

Stanford University · edX

Databases: Relational Databases and SQL

4.547 ratings

This course is one of five self-paced courses on the topic of Databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011. The original "Databases" courses are now all available on edx.org. This course provides an introduction to relational d…

Free to audit2 weeks, 8 - 10 hours per week

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