Google Cloud — Introduction to SQL for BigQuery and Cloud SQL

Structured Query Language (SQL)

SQL is a standard language for data operations that allows you to ask questions and get insights from structured datasets. It’s commonly used in database management and allows you to perform tasks like transaction record writing into relational databases and petabyte-scale data analysis.

BigQuery

BigQuery is a fully-managed petabyte-scale data warehouse that runs on the Google Cloud. Data analysts and data scientists can quickly query and filter large datasets, aggregate results, and perform complex operations without having to worry about setting up and managing servers. It comes in the form of a command line tool (pre installed in cloudshell) or a web console — both ready for managing and querying data housed in Google Cloud projects.

Cloud SQL

Cloud SQL is a fully-managed database service that makes it easy to set up, maintain, manage, and administer your relational PostgreSQL and MySQL databases in the cloud. There are two formats of data accepted by Cloud SQL: dump files (.sql) or CSV files (.csv).

In the below video, you will learn how to:

• Distinguish databases from tables and projects.
• Use the SELECT, FROM, and WHERE keywords to construct simple queries.
• Identify the different components and hierarchies within the BigQuery console.