Skip to main content

Get Started with Lakebase

This course introduces Databricks Lakebase, a fully managed PostgreSQL service built into the Databricks Data Intelligence Platform that brings operational (OLTP) and analytical (OLAP) workloads closer together.


The course begins with a conceptual lecture that compares OLTP and OLAP systems, explaining their different performance characteristics, storage models, and typical use cases. You will also explore the challenges organizations face when maintaining separate transactional databases and analytical platforms, including data movement, latency, and architectural complexity.


You will then learn how Databricks Lakebase helps address these challenges by providing a PostgreSQL-compatible operational database that integrates directly with the Databricks Lakehouse, enabling operational applications and analytics to work together within a unified platform.


This is a Get Started course, so the focus is on understanding the core concepts and basic workflows for working with Lakebase. Building full production applications on top of Lakebase is outside the scope of this course.


You can create a Databricks Free Edition account and try the follow-along demos in a hands-on environment.


Note: Databricks Academy is transitioning to a notebook-based format for classroom sessions within the Databricks environment, discontinuing the use of slide decks for lectures.

Skill Level
Onboarding
Duration
3h
Prerequisites

In this course, the content was developed for participants with these skills/knowledge/abilities:  

• Access to a Databricks workspace with the Lakebase Database feature enabled

• An available All-purpose-compute OR Serverless cluster and a SQL Warehouse (2X-Small is sufficient).

• Create permissions for catalogs in your workspace.

• Intermediate SQL skills - Able to write and understand SELECT, INSERT, UPDATE, and DELETE statements.

• Intermediate Python knowledge - Comfortable with Python functions, exceptions, and working with dictionaries/lists.

• Familiarity with OLTP fundamentals - Understands client-server relationships, ACID properties, database authentication, and concurrent access.

Outline

Get Started with Lakebase

• Lakebase Core Concepts and Architecture

• Demo - Creating and Exploring a Lakebase Project

• Demo - Querying Lakebase with Lakehouse Federation

• Demo - Lakehouse Sync Unity Catalog Tables to Lakebase Postgres Tables

• Demo - Lakebase Autoscaling and Python CRUD Quickstart


Upcoming Public Classes

Date
Time
Your Local Time
Language
Price
Jul 30
12 PM - 02 PM (Asia/Singapore)
-
English
Free
Aug 06
12 PM - 02 PM (Asia/Singapore)
-
English
Free
Aug 12
03 PM - 05 PM (Europe/London)
-
English
Free
Aug 27
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Sep 01
12 PM - 02 PM (Asia/Singapore)
-
English
Free
Sep 08
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Sep 23
03 PM - 05 PM (Europe/London)
-
English
Free
Oct 06
12 PM - 02 PM (Asia/Singapore)
-
English
Free
Oct 13
03 PM - 05 PM (Europe/London)
-
English
Free
Oct 27
09 AM - 11 AM (America/Los_Angeles)
-
English
Free

Public Class Registration

If your company has purchased success credits or has a learning subscription, please fill out the Training Request form. Otherwise, you can register below.

Private Class Request

If your company is interested in private training, please submit a request.

See all our registration options

Registration options

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

Runtime

Self-Paced

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

Register now

Instructors

Instructor-Led

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

Register now

Learning

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

Scale

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

Data Engineer

Automated Deployment with Declarative Automation Bundles

This course provides a comprehensive review of DevOps principles and their application to Databricks projects. It begins with an overview of core DevOps, DataOps, continuous integration (CI), continuous deployment (CD), and testing, and explores how these principles can be applied to data engineering pipelines.

The course then focuses on continuous deployment within the CI/CD process, examining tools like the Databricks REST API, SDK, and CLI for project deployment. You will learn about Declarative Automation Bundles (DABs) and how they fit into the CI/CD process. You’ll dive into their key components, folder structure, and how they streamline deployment across various target environments in Databricks. You will also learn how to add variables, modify, validate, deploy, and execute Declarative Automation Bundles for multiple environments with different configurations using the Databricks CLI.

Finally, the course introduces Visual Studio Code as an Interactive Development Environment (IDE) for building, testing, and deploying Declarative Automation Bundles locally, optimizing your development process. The course concludes with an introduction to automating deployment pipelines using GitHub Actions to enhance the CI/CD workflow with Declarative Automation Bundles.

By the end of this course, you will be equipped to automate Databricks project deployments with Declarative Automation Bundles, improving efficiency through DevOps practices.

Note: 

1. Databricks Academy is transitioning from video lectures to a more streamlined PDF format with slides and notes for all self-paced courses. Please note that demo videos will still be available in their original format. We would love to hear your thoughts on this change, so please share your feedback through the course survey at the end. Thank you for being a part of our learning community!

2. This course is the fourth in the 'Advanced Data Engineering with Databricks' series.

Languages Available: English | 日本語 | 한국어

Free
2h
Professional

Questions?

If you have any questions, please refer to our Frequently Asked Questions page.