Cloud SQL Backup and Restore
Create a Cloud SQL PostgreSQL instance, configure automated backups, perform on-demand backup and restore, and manage maintenance windows.

Lab Overview
Practice real-world Cloud SQL administration. Create a PostgreSQL instance, enable and configure automated backups with point-in-time recovery, take on-demand backups, perform a full restore to a new instance, and manage maintenance windows. Every step uses gcloud commands you will use on the job and in the ACE exam.
What You'll Learn
Create a Cloud SQL PostgreSQL instance with minimal cost configuration
Enable and configure automated backups with point-in-time recovery
Take an on-demand backup and restore it to a new instance
Inspect and configure maintenance windows
Clean up Cloud SQL resources to prevent ongoing charges
Prerequisites
Basic command line familiarity
Understanding of gcloud CLI
Familiarity with relational databases
Technologies Covered
Part of a Course
This lab is part of the Google Cloud Associate Cloud Engineer course
View All CoursesChoose your plan
Simple, Transparent Pricing
Unlock full access to TeKanAid courses, labs, and bootcamps
Pro
Course content without labs
Renews automatically. Cancel anytime.
Final price verified at checkout.
- Full access to all courses
- Progress tracking
- Certificate of completion
- Community access
- Bootcamp participation
- New content access
Premium
Full access with hands-on labs
Renews automatically. Cancel anytime.
Final price verified at checkout.
- Everything in Pro
- Unlimited hands-on labs
- Lab AI Assistant
- Accelerator bootcamps with live office hours
- Priority support
Prefer a single course?
Purchase individual courses for a one-time fee of $79. Full access to course content, quizzes, certificates, and community features, lab access is not included.
Browse CoursesTry it free, no credit card
Three free ways to start. All bridge into the paid Premium catalog when you're ready.
Not ready to commit? The crash course is email-only. No academy account required.
Ready to Get Started?
Start this hands-on lab and build real-world Platform Engineering skills
Get Access Now