[GCP] Data Engineer Notes - BigQuery

Hello, everyone. It's Gaby again.

Here with my summary of some important points on BigQuery:

Reference Sources

1. BigQuery Documentations at Google Cloud https://cloud.google.com/bigquery/docs/resources

2. Data Engineering with Google Cloud Professional Certificate at Coursera https://www.coursera.org/professional-certificates/gcp-data-engineering?

3. Data Engineer Certification Exam Guide at Google Cloud https://cloud.google.com/certification/guides/data-engineer

4. Introduction to Partitioned Tables at Google Cloud https://cloud.google.com/bigquery/docs/partitioned-tables

5. Using Cached Query Results at Google Cloud https://cloud.google.com/bigquery/docs/cached-results

6. Numbering Functions in Standard SQL at Google Cloud https://cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions

7. Legacy SQL Functions and Operators at Google Cloud https://cloud.google.com/bigquery/docs/reference/legacy-sql

8. Issuing a Query Dry Run at Google Cloud https://cloud.google.com/bigquery/docs/dry-run-queries

9. Introduction to Materialized Views at Google Cloud https://cloud.google.com/bigquery/docs/materialized-views-intro

10. BigQuery for Data Warehouse Practitioners at Google Cloud https://cloud.google.com/architecture/bigquery-data-warehouse

11. Basic Roles and Permissions at Google Cloud https://cloud.google.com/bigquery/docs/access-control-basic-roles

12. Predefined Roles and Permissions at Google Cloud https://cloud.google.com/bigquery/docs/access-control

13. Introduction to Authentication at Google Cloud https://cloud.google.com/bigquery/docs/authentication

14. Google Cloud Professional Data Engineer Practice Test at Udemy https://www.udemy.com/course/google-cloud-professional-data-engineer/

15. Google Professional Data Engineer (GCP) Practice Exam at TestPrep https://www.testpreptraining.com/certified-professional-data-engineer-practice-exam

Message or email me if you have any further questions. I will be happy to share my experience with you!