technifyed

Free online

Postgresql courses 128

Learn Postgresql online: university courses, full YouTube courses, and courses with free certificates, from the IITs, MIT, Harvard, Google, Microsoft and more.

Explore subjects

Showing 128 courses

Microsoft

Tune queries in Azure Database for PostgreSQL

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…

  • Microsoft Learn
  • 30 minutes
  • Self-paced
  • Free course
  • Free badge
  • Intermediate

Microsoft

Optimize vector search in Azure Database for PostgreSQL

Tune pgvector configuration, select vector indexes, design efficient data layouts, and scale Azure Database for PostgreSQL for high-performance AI workloads.

  • Microsoft Learn
  • 2 hours
  • Self-paced
  • Free course
  • Free badge
  • Intermediate

Microsoft

Filtering data: The WHERE clause and subqueries

Learn how to filter data in PostgreSQL using the WHERE clause, logical operators, pattern matching, and subqueries for advanced query control.

  • Microsoft Learn
  • 25 minutes
  • Self-paced
  • Free course
  • Free badge
  • Beginner

Microsoft

Convert Oracle schemas to Azure Database for PostgreSQL by using AI

Learn how to use the AI-powered Oracle to Azure Database for PostgreSQL schema conversion feature in the Visual Studio Code PostgreSQL extension to automate schema translation, validate results in a scratch database, and resolve flagged items with GitHub Copilot agent mode.

  • Microsoft Learn
  • 1 hour
  • Self-paced
  • Free course
  • Free badge
  • Intermediate

Microsoft

Understand write-ahead logging

Azure Database for PostgreSQL is an ACID compliant database service. Write-ahead logging ensures changes are both atomic and durable (the A and D in ACID). Changes are first written to the log before they're committed to the database. In this module, you learn how Azure Database for PostgreSQL impl…

  • Microsoft Learn
  • 45 minutes
  • Self-paced
  • Free course
  • Free badge
  • Intermediate

Microsoft

Understand concurrency in PostgreSQL

Azure Database for PostgreSQL is a multi-user relational database solution. The ability to support many concurrent users enables PostgreSQL databases to scale out and enable applications that support many users and locations at the same time. The increase in users brings a risk of conflicts. For th…

  • Microsoft Learn
  • 35 minutes
  • Self-paced
  • Free course
  • Free badge
  • Intermediate

Microsoft

Explore PostgreSQL architecture

PostgreSQL is an open-source relational database system that is now available as a service in Azure. In this module, you learn about the PostgreSQL architecture, and how to manage different aspects of PostgreSQL in Azure Database for PostgreSQL.

  • Microsoft Learn
  • 45 minutes
  • Self-paced
  • Free course
  • Free badge
  • Intermediate

Microsoft

Use system catalogs and system views in PostgreSQL

Relational databases can store vast quantities of data, but they also need to hold information about the structure of that data. For an operational database management system (DBMS) information about the structure of tables, and all other objects, security, and concurrency, amongst many other setti…

  • Microsoft Learn
  • 35 minutes
  • Self-paced
  • Free course
  • Free badge
  • Intermediate

Microsoft

Optimize vacuum in Azure Database for PostgreSQL

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

  • Microsoft Learn
  • 25 minutes
  • Self-paced
  • Free course
  • Free badge
  • Intermediate

IBM

Introduction to SQL

4.587 ratings

Learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in Data Engineering, Data Analytics or Data Science.

  • edX
  • 5 weeks, 2 - 4 hours per week
  • Self-paced
  • Free to audit
  • Paid certificate
  • Beginner

Microsoft

Migrate to Azure Database for PostgreSQL flexible server

Azure Database for PostgreSQL Flexible Server supports effective data migration from PostgreSQL servers. This module covers both online and offline migration methods and tools, helping you choose the right approach for your scenario. Learn practical techniques for managing migrations efficiently, i…

  • Microsoft Learn
  • 60 minutes
  • Self-paced
  • Free course
  • Free badge
  • Intermediate

University of Michigan

Database Design and Basic SQL in PostgreSQL

4.81,131 ratings

In this course you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON DELETE CASCADE, etc) will enable you to create tables, column types and define the schema of your…

  • Coursera
  • 14 hours
  • Self-paced
  • Paid certificate

Microsoft

Implement vector search with Azure Database for PostgreSQL

Learn how to implement vector search in Azure Database for PostgreSQL using the pgvector extension for semantic search, recommendations, and RAG pipelines.

  • Microsoft Learn
  • 1.5 hours
  • Self-paced
  • Free course
  • Free badge
  • Intermediate

freeCodeCamp

Relational Database Certification

Bash, SQL, PostgreSQL and Git, practised in a real terminal in your browser.

  • freeCodeCamp
  • Self-paced
  • Free course
  • Free certificate

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