Google BigQuery & PostgreSQL for Data Analysis

this lesson welcomes you to the course on google bigquery and postgresql for data analysis.

this lesson outlines the flow and structure of the course.

this lesson marks a significant milestone in your learning process.

this lesson covers the installation process for postgresql and pgadmin.

this lesson guides you through setting up bigquery on google cloud platform.

this lesson introduces you to the bigquery interface.

this lesson teaches you how to use the create statement in sql.

this lesson focuses on the create statement specifically in bigquery.

this lesson provides an exercise on creating a database and table.

this lesson discusses the insert statement in sql.

this lesson covers the insert statement in bigquery.

this lesson explains how to import data from a file.

this lesson shows how to import data from a file using bigquery's web user interface.

this lesson covers file upload in google bigquery through google cloud sdk.

this lesson explains how to import data from google drive.

this lesson provides an exercise on inserting and importing data.

this lesson focuses on the select statement in sql.

this lesson discusses the select statement in bigquery.

learn the processes involved in restoring and backing up data.

understand how to create data sets within BigQuery.

engage in a practical exercise focused on restoring and backing up.

learn how to filter records using the IN selection command.

discover how to use the IN command for filtering in BigQuery.

explore the BETWEEN command for filtering records within a range.

understand how to apply the BETWEEN command in BigQuery.

learn about filtering records using the LIKE command.

discover how to use the LIKE command for filtering in BigQuery.

engage in an exercise focused on filtering using IN, LIKE, and BETWEEN.

learn how to order query results using the ORDER BY clause.

understand how to implement ORDER BY in BigQuery for sorting.

explore how to limit the number of records returned by a query.

learn how to use the LIMIT clause in BigQuery.

practice sorting records in a hands-on exercise.

learn how to create an alias for a column or table using AS.

discover how to use the AS keyword for aliasing in BigQuery.

explore how to count records using the COUNT aggregate command.

learn how to use the COUNT function in BigQuery to tally records.

understand the SUM function to calculate total values.

explore how to apply the SUM function within BigQuery.

discover how to calculate the AVERAGE of a dataset.

learn to compute the AVERAGE in BigQuery.

get familiar with using MIN and MAX functions.

understand the application of MIN and MAX in BigQuery.

practice using aggregate functions through an exercise.