This course provides comprehensive training on PostgreSQL, Cloud SQL, and AlloyDB. It covers PostgreSQL server administration, user and database management, data import/export, backup/restore, performance tuning, and programming integration with Python, Go, and Java. It also explores Cloud SQL setup, connectivity, management, and high availability confi gurations with hands-on demos using pgAdmin, Google Cloud console, and command-line tools. Additionally, the course includes AlloyDB confi guration, migrations from various sources such as Oracle, and an optional section on AlloyDB Omni. Key focus areas include server maintenance, disaster recovery, and integration with Google Cloud services such as BigQuery and Database Center.

Learning Objectives

By the end of this course, you will be able to:

• Understand PostgreSQL server administration, including installation, configuration, and management.
• Manage PostgreSQL users, roles, databases, and schemas.
• Perform database maintenance tasks, including backups, restores, and optimizations.
• Import and export data effi ciently using various tools such as pgAdmin and psql.
• \Tune PostgreSQL for performance, including memory management, indexing, and partitioning.
• Integrate PostgreSQL with programming languages such as Python, Go, and Java.
• Understand Cloud SQL and AlloyDB, including high availability, disk management, and monitoring.
• Set up and manage Cloud SQL instances and integrate them with other Google Cloud services.
• Migrate data from other databases such as Oracle to Cloud SQL or AlloyDB.
• Utilize AlloyDB for high availability and performance optimization.
• Explore how to incorporate pgvector extension into AlloyDB to use it as a vector store of embeddings for vector search and retrieval.
• Explore AlloyDB Omni for advanced database confi guration and licensing.

After attending this class, you will be proficient in the following:

• Configuring and managing PostgreSQL servers, including installation, tuning, and maintenance for optimal performance.
• Using pgAdmin, psql, and Google Cloud console to perform tasks such as user management, database creation, data import/export, backups, and server monitoring.
• Implementing high availability solutions in both Cloud SQL and AlloyDB, ensuring continuous service during failures.
• Migrating data from on-premises databases such as Oracle to Cloud SQL or AlloyDB, leveraging the Database Migration Service and other tools.
• Integrating PostgreSQL with programming languages like Python, Go, and Java, and managing connections eff ectively using connection pooling techniques.

Who Should Attend

SQL DBAs, programmers, and data engineers on other platforms who want to migrate to Postgres and CloudSQL.

Prerequisites

Basic understanding of SQL as a DBA or user and general knowledge of Google Cloud such as VMs, Cloud Storage, and Google Cloud console.