Postgres Extensions Tour

Surveys the certified Postgres extension catalog on Lakebase. Following the lecture-demo pattern, learners enable and verify extensions per branch, run PostGIS spatial queries, read pg_stat_statements, build a pgvector nearest-neighbor query, and try Lakebase Search (Beta) — then choose between pgvector, Lakebase Search, and Databricks AI Search for a given retrieval workload.

Skill Level

Associate

Duration

Prerequisites

The content was developed for participants with these skills/knowledge/abilities:

• Comfort with SQL and connecting to Lakebase (from LB-103)

• Awareness that branches isolate configuration (from LB-102 or LB-201) is helpful

Suggested prior course: LB-103 First Steps — establishes connecting and running SQL, which every extension demo builds on.

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

Customer registration Partner registration

See all our registration options

Registration options

Databricks has a delivery method for wherever you are on your learning journey

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

Instructor-Led

Public and private courses taught by expert instructors across half-day to two-day courses

Blended Learning

Self-paced and weekly instructor-led sessions for every style of learner to optimize course completion and knowledge retention. Go to Subscriptions Catalog tab to purchase

Purchase now

Skills@Scale

Comprehensive training offering for large scale customers that includes learning elements for every style of learning. Inquire with your account executive for details

Upcoming Public Classes

Migrating to Lakebase

Migrates an existing Postgres workload to Lakebase. Following the lecture-demo pattern, learners use a decision matrix to confirm fit, assemble a pre-migration checklist, execute a pg_dump/pg_restore migration (and its alternatives), and design a cutover strategy with validation queries that catch subtle drift.

Paid & Subscription

Lab

Associate

Production Operations: HA, Read Replicas, Instant Restore

Hardens Lakebase for production. Following the lecture-demo pattern and framed around an incident, learners configure High Availability across zones, add read replicas and route analytical traffic to them, tune the restore window, and recover from data loss with a point-in-time branch.

Paid & Subscription

Lab

Associate

Vector Search and RAG with pgvector on Lakebase

Builds a semantic retrieval layer on pgvector inside Lakebase Postgres, taught against a live "Ask the docs" app that Classroom Setup deploys. Following the lecture-demo pattern, learners decide when pgvector beats Databricks AI Search, design a document/chunk schema, choose and build HNSW and IVFFlat indexes, generate embeddings in batch with ai_query(), and write a hybrid search combining vector similarity, a metadata filter, and full-text ranking (ts_rank_cd cover-density) in one query. An optional closing section surveys Lakebase Search (Beta) and its lakebase_text (BM25) and lakebase_vector (ANN) extensions.

Paid & Subscription

Lab

Associate