Getting Started with Cloud SQL
Published by O'Reilly Media, Inc.
Despite the advent of NoSQL and distributed databases, relational databases are still widely used in the development of applications and websites. They allow us to store large amounts of data in an orderly manner, facilitating easy consultation and usage. At the same time, the popularity of cloud computing has changed the way we work with databases through the introduction of managed solutions on the cloud. One example of such a solution is Cloud SQL, a fully managed relational database service for MySQL, PostgreSQL, and SQL Server. It combines the benefits of these SQL databases with other features that their on-premises counterparts lack, including scalability, heightened security, and quicker management of time-consuming tasks.
Join expert Adriana Moya to explore the fundamentals of working with Cloud SQL. You’ll learn how Cloud SQL instances work and which instances you should use for certain use cases, as well as how to connect to a database, load data, and run SQL queries. You’ll review the ins and outs of managing users and permissions and creating backups, then dive into high-availability configurations and security best practices.
What you’ll learn and how you can apply it
By the end of this live online course, you’ll understand:
- How Cloud SQL instances work
- What type of instances to use for specific purposes
- The mechanisms for connecting to a database
- High-availability configurations
- Backup mechanisms
- Security best practices in Cloud SQL
And you’ll be able to:
- Create instances of MySQL, PostgreSQL, or SQL Server in Cloud SQL
- Connect to a MySQL client using a public IP address
- Run basic SQL operations
- Load data
- Create backups
- Manage users and permissions
- Manage instances configuration
This live event is for you because...
- You’re a developer who regularly works with relational databases and wants scalability, improved security, and high availability.
- You’re a consultant who supports clients with different needs.
- You’re a technology architect who wants to improve the performance of your applications.
- You work with SQL databases.
Prerequisites
- A Google Cloud account
- A computer with a MySQL client installed
- Familiarity with SQL (e.g., creating SQL databases and tables and making queries)
- A basic understanding of command-line environments
Recommended preparation:
- Take Google Cloud Fundamentals (live online course with Janani Ravi)
Recommended follow-up:
- Read chapters 1–4 in Learning SQL, third edition (book)
- Read chapters 3–5 in Learning MySQL, second edition (book)
Schedule
The time frames are only estimates and may vary according to how the class is progressing.
Creating your instance (35 minutes)
- Presentation: Creating a MySQL instance
- Group discussion: What database systems does Cloud SQL support?
- Hands-on exercises: Create an instance and connect to it from Cloud Shell
- Q&A
Managing users (25 minutes)
- Presentation: Managing users from Cloud SQL UI
- Hands-on exercise: Create three users, assign the next permissions, and test
- Q&A
- Break
Connecting to Cloud SQL (20 minutes)
- Presentation: Connectivity fundamentals
- Hands-on exercise: Test connection to your instance from your local machine
- Q&A
Exploring your data with Cloud SQL (40 minutes)
- Presentation: Loading data in your DB; executing commands
- Hands-on exercises: Import a data file; get the result of a set of statements
- Q&A
- Break
Backup mechanisms (20 minutes)
- Presentation: Backup overview
- Hands-on exercise: Create a backup using gcloud and restore it in a new instance
- Q&A
Security and access control (40 minutes)
- Presentation: Security best practices; Cloud SQL Auth proxy
- Hands-on exercises: Add proxy instance
- Q&A
Your Instructor
Adriana Moya
Adriana Moya currently works as a cloud architect for Globant, an IT and software development company. She has worked for more than 7 years with Google Cloud partners, implementing high-scale solutions and supporting different clients and needs in terms of development and devops practices. As a certified Google Cloud Associate Cloud Engineer and a member of the Google Developer Expert program in the Google Cloud category, Adriana is passionate about sharing knowledge and helping people grow professionally.