What is this Training Codelab About?

This training codelab is a collection of videos on Google Cloud SQL and the SQL lanaguage designed by others combined with hands-on labs that I created. The goal is to show how to use SQL, PostgreSQL and Cloud SQL in an entertaining manner built with free resources.

Notice

I am still creating this training codelab. The video contents is present but I have not yet included my hands-on labs. This training codelab is my first attempt to organize resources into a learning path.

Last Update: August 7, 2019

What is SQL?

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS) such as Cloud SQL. SQL statements are used to perform tasks such as input data into a database, update data on a database, or retrieve data from a database.

What is Cloud SQL?

Cloud SQL is a fully-managed database service that makes it easy to set up, maintain, and administer your relational PostgreSQL and MySQL databases in the cloud. Cloud SQL offers high performance, vertical scalability, and convenience. Hosted on Google Cloud Platform, Cloud SQL provides a database infrastructure for applications running anywhere.

Credits

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Professional acting and voice by Ulka Mohanty

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

In this lab we will create a Cloud SQL PostgreSQL instance. Once you are finished remember to either stop the Cloud SQL instance or delete it.

  1. Go to the Google Cloud Console - SQL
  2. Login to the console or confirm which login credentials you are using.
  3. Confirm the project that you want to use.
  4. Click the CREATE INSTANCE button to start the wizard.
  5. Select Choose PostgreSQL.
  6. Enter a name for Instance ID.
  7. Enter a password for Default user password. Save the password.
  8. Select the Region. Leave Zone at Any unless you want a specific zone.
  9. Select PostgreSQL 9.6 for the Database version.
  10. Leave all other settings at their default.
  11. Review that your settings are similar to the screenshot below.
  12. Select Create

It will take several minutes to create the Cloud SQL instance. While waiting watch the next video.

Create Cloud SQL instance

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

Learn SQL with Socratica || SQL Tutorial || SQL for Beginners

What we've covered

Learn More