Udemy - BigQuery for Big data engineers - Master Big Query Intern...

  • Category Other
  • Type Tutorials
  • Language English
  • Total size 2.1 GB
  • Uploaded By tutsnode
  • Downloads 628
  • Last checked 3 days ago
  • Date uploaded 5 years ago
  • Seeders 8
  • Leechers 11

Infohash : 358044A2A61362326C4F16F21685F0B0F3A1648D




Description

Note : This Bigquery course is NOT intended to teach SQL or PostgreSQL. The focus of the course is kept to give you In-depth knowledge of Google Bigquery concepts/Internals.

**Coming Soon** – Streaming Pipeline in GCP

“BigQuery is server-less, highly scalable, and cost-effective Data warehouse designed for Google cloud Platform (GCP) to store and query petabytes of data.”

What’s included in the course ?

Brief introduction to the set of services Google Cloud provides.
Complete In-depth knowledge of Google BigQuery concepts explained from Scratch to ADVANCE to Real-Time implementation.
Each and every BigQuery concept is explained with HANDS-ON examples.
Includes each and every, even thin detail of Big Query.
Learn to interact with BigQuery using its Web UI dashboard, Bq CLI and Python Client Library.
Create, Load, Modify and Manage BigQuery Datasets, Tables, Views, Materialized Views etc.
*Exclusive* – Query Execution Plan, Efficient schema design, Optimization techniques, Partitioning, Clustering.
Build and deploy an end-to-end data pipeline of a Real-Time case study in GCP.
Services used in the pipeline- Dataflow, Apache Beam, Bigquery, Cloud storage, Data Studio, Cloud Composer etc.
Learn Best practices and Optimization techniques to follow in Real-Time Google Cloud BigQuery Projects.

After completing this course, you can start working on any BigQuery project with full confidence.

Add-Ons

Questions and Queries will be answered very quickly.
Queries and datasets used in lectures are attached in the course for your convenience.
I am going to update it frequently, every time adding new components of Bigquery.

Who this course is for:

Students who want to learn Deep Internals of BigQuery components
Data engineers, intending to build end-to-end Data pipelines in GCP (Google Cloud Platform)
Anyone planning to give Google Cloud Data engineer certification.

Requirements

Basic knowledge of SQL

Last Updated 12/2020

Files:

BigQuery for Big data engineers - Master Big Query Internals [TutsNode.com] - BigQuery for Big data engineers - Master Big Query Internals 15. Build end-to-end Data Pipelines
  • 3. Write Transformations in Beam.mp4 (59.5 MB)
  • 1. Case Study Requirements.mp4 (21.4 MB)
  • 1. Case Study Requirements.srt (4.5 KB)
  • 1.1 Batch Pipeline.zip (24.4 KB)
  • 2. Apache Beam Pipeline creation.mp4 (19.2 MB)
  • 2. Apache Beam Pipeline creation.srt (6.6 KB)
  • 2.1 Batch Pipeline.zip (24.4 KB)
  • 3. Write Transformations in Beam.srt (9.2 KB)
  • 3.1 Batch Pipeline.zip (24.4 KB)
  • 4. Write to BigQuery.mp4 (54.2 MB)
  • 4. Write to BigQuery.srt (8.9 KB)
  • 4.1 WriteToBigQuery.html (0.1 KB)
  • 5. Create View for Daily data.mp4 (19.5 MB)
  • 5. Create View for Daily data.srt (2.5 KB)
  • 6. Run the Beam Pipeline.mp4 (31.5 MB)
  • 6. Run the Beam Pipeline.srt (5.1 KB)
  • 7. Create Reports in Cloud DataStudio.mp4 (58.0 MB)
  • 7. Create Reports in Cloud DataStudio.srt (8.2 KB)
  • 8. Create monthly reports in DataStudio.mp4 (38.9 MB)
  • 8. Create monthly reports in DataStudio.srt (3.4 KB)
1. Introduction to GCP & its services
  • 1. Introduction to Google Cloud Platform.mp4 (9.2 MB)
  • 1. Introduction to Google Cloud Platform.srt (3.4 KB)
  • 2. GCP vs AWS vs Azure - Why choose GCP.mp4 (20.5 MB)
  • 2. GCP vs AWS vs Azure - Why choose GCP.srt (9.2 KB)
  • 3. Compute Services in GCP.mp4 (19.3 MB)
  • 3. Compute Services in GCP.srt (8.3 KB)
  • 4. Storage Services in GCP.mp4 (23.9 MB)
  • 4. Storage Services in GCP.srt (7.6 KB)
  • 5. Big data Services in GCP.mp4 (14.8 MB)
  • 5. Big data Services in GCP.srt (5.7 KB)
  • 6. AI & ML Services in GCP.mp4 (26.5 MB)
  • 6. AI & ML Services in GCP.srt (12.7 KB)
  • 7. Big data ecosystem in GCP.mp4 (19.2 MB)
  • 7. Big data ecosystem in GCP.srt (7.2 KB)
  • 8. Quiz 1.html (0.1 KB)
2. Introduction to BigQuery
  • 1. Conventional Datawarehouse Problems.mp4 (9.8 MB)
  • 1. Conventional Datawarehouse Problems.srt (5.5 KB)
  • 2. What is BigQuery.mp4 (12.2 MB)
  • 2. What is BigQuery.srt (5.6 KB)
  • 3. BigQuery Out-of-the Box Features.mp4 (14.3 MB)
  • 3. BigQuery Out-of-the Box Features.srt (5.9 KB)
  • 4. Architecture of BigQuery.mp4 (18.5 MB)
  • 4. Architecture of BigQuery.srt (8.9 KB)
3. Dataset & Table creation
  • 1. Setup a GCP account.html (1.2 KB)
  • 2. Create a Project.mp4 (24.8 MB)
  • 2. Create a Project.srt (6.1 KB)
  • 3. BigQuery UI Tour.mp4 (15.7 MB)
  • 3. BigQuery UI Tour.srt (4.1 KB)
  • 4. Region Vs Multi-region.mp4 (29.4 MB)
  • 4. Region Vs Multi-region.srt (9.9 KB)
  • 5. Create a Dataset.mp4 (10.6 MB)
  • 5. Create a Dataset.srt (3.9 KB)
  • 6. Create a Table.mp4 (40.0 MB)
  • 6. Create a Table.srt (11.1 KB)
  • 6.1 names.zip (7.9 MB)
  • 7. Assignment 1.html (0.1 KB)
4. Using BigQuery Dashboard options
  • 1. Running query with various Query Settings.mp4 (39.4 MB)
  • 1. Running query with various Query Settings.srt (10.2 KB)
  • 1.1 runing 1st query.txt (0.1 KB)
  • 2. Caching features & limitations.mp4 (16.7 MB)
  • 2. Caching features & limitations.srt (5.5 KB)
  • 3. Querying Wildcard Tables.mp4 (36.8 MB)
  • 3. Querying Wildcard Tables.srt (9.8 KB)
  • 3.1 wildcard queries.txt (1.6 KB)
  • 4. Wildcard Table Limitations.mp4 (16.6 MB)
  • 4. Wildcard Table Limitations.srt (5.5 KB)
  • 5. Schedule, Save, Share a Query.mp4 (49.7 MB)
  • 5. Schedule, Save, Share a Query.srt (12.0 KB)
  • 5.1 Cron format.html (0.2 KB)
  • 6. Schema Auto detection.mp4 (30.1 MB)
  • 6. Schema Auto detection.srt (5.6 KB)
  • 6.1 auto_detect.txt (32.6 KB)
5. Efficient Schema Design in BigQuery
  • 1. Design an Efficient schema for BigQuery Tables.mp4 (16.3 MB)
  • 1. Design an Efficient schema for BigQuery Tables.srt (7.5 KB)
  • 2. Nested & Repeated Columns.mp4 (34.0 MB)
  • 2. Nested & Repeated Columns.srt (6.1 KB)
  • 2.1 nested.zip (0.6 KB)
  • 3. Quiz 2.html (0.1 KB)
  • 4. Assignment 2.html (0.1 KB)
6. Operations on Datasets & Tables
  • 1. Copying Datasets.mp4 (31.0 MB)
  • 1. Copying Datasets.srt (6.2 KB)
  • 1.1 Roles.html (0.1 KB)
  • 1.2 Pricing.html (0.1 KB)
  • 1.3 Locations supporting Dataset copying.html (0.1 KB)
  • 2. Transfer Service for scheduling Copy Jobs.mp4 (18.9 MB)
  • 2. Transfer Service for scheduling Copy Jobs.srt (5.5 KB)
  • 2.1 Pricing.html (0.1 KB)
  • 3. Native operations on Table for Schema change.mp4 (42.6 MB)
  • 3. Native operations on Table for Schema change.srt (7.8 KB)
  • 3.1 modify table schema data - Copy.txt (0.1 KB)
  • 3.2 modify table schema data.txt (0.1 KB)
  • 4. Manual operations on Table.mp4 (47.8 MB)
  • 4. Manual operations on Table.srt (7.5 KB)
  • 4.1 modify table schema queries.txt (0.5 KB)
7. Execution Plan of BigQuery
  • 1. How BigQuery creates Execution Plan of a Query.mp4 (31.1 MB)
  • 1. How BigQuery creates Execution Plan of a Query.srt (11.9 KB)
  • 1.1 execution plan query.txt (0.2 KB)
  • 2. Understanding Execution Plan in UI Dashboard.mp4 (29.2 MB)
  • 2. Understanding Execution Plan in UI Dashboard.srt (8.3 KB)
8. Partitioned Tables in BigQuery
  • 1. What is Partitioning & its benefits.mp4 (21.4 MB)
  • 1. What is Partitioning & its benefits.srt (7.7 KB)
  • 2. Ingestion time Partitioned Tables.mp4 (53.8 MB)
  • 2. Ingestion time Partitioned Tables.srt (10.7 KB)
  • 2.1 Partitioning.zip (8.3 KB)
  • 3. Date column Partitioned Tables.mp4 (41.4 MB)
  • 3. Date column Partitioned Tables.srt (7.2 KB)
  • 4. Integer based Partitioned Tables.mp4 (28.0 MB)
  • 4. Integer based Partitioned Tables.srt (5.5 KB)
  • 5. ALTER, COPY operations on Partitioned Tables.mp4 (29.5 MB)
  • 5. ALTER, COPY operations on Partitioned Tables.srt (7.6 KB)
  • 6. DML operations on Partitioned Tables.mp4 (30.0 MB)
  • 6. DML operations on Partitioned Tables.srt (2.6 KB)
  • 6.1 Partitioning.zip (8.3 KB)
  • 7. Best Practices for Partitioning.mp4 (40.9 MB)
  • 7. Best Practices for Partitioning.srt (8.3 KB)
  • 7.1 Partitioning.zip (8.3 KB)
9. Clustered Tables in BigQuery
  • 1. What is Clustering.mp4 (17.7 MB)
  • 1. What is Clustering.srt (6.7 KB)
  • 2. When to use Clustering OR Partitioning OR Both.mp4 (13.7 MB)
  • 2. When to use Clustering OR Partitioning OR Both.srt (5.4 KB)
  • 3. Create Clustered Table.mp4 (15.9 MB)
  • 3. Create Clustered Table.srt (2.3 KB)
  • 3.1 clustering_data.txt (21.4 KB)
  • 4. Dos & Don'ts for Clustering.mp4 (24.3 MB)
  • 4. Dos & Don'ts for Clustering.srt (4.7 KB)
  • 4.1 clustering_queries.txt (0.2 KB)
10. Loading & Querying External Data Sources
  • 1. Introduction and Create Cloud Storage Bucket.mp4 (36.4 MB)
  • 1. Introduction and Create Cloud Storage Bucket.srt (9.4 KB)
  • 1.1 Limitations of file formats.html (0.1 KB)
  • 2. Create & Query Permanent Table on Cloud Storage bucket.mp4 (27.3 MB)
  • 2. Create & Query Permanent Table on Cloud Storage bucket.srt (5.3 KB)
  • 3. External data source Limitations.mp4 (10.4 MB)
  • 3. External data source Limitations.srt (3.3 KB)
11. Views in Bigquery
  • 1. Introduction to Views & its Advantages.mp4 (16.0 MB)
  • 1. Introduction to Views & its Advantages.srt (7.1 KB)
  • 2. Create Views in BigQuery.mp4 (33.6 MB)
  • 2. Create Views in BigQuery.srt (8.2 KB)
  • 3. Restrict rows at User level in Views.mp4 (24.1 MB)
  • 3. Restrict rows at User level in Views.srt (4.4 KB)
  • 3.1 view.zip (0.5 KB)
  • 4. Limitations of Views.mp4 (12.3 MB)
  • 4. Limitations of Views.srt (3.3 KB)
12. Materialized Views in BigQuery
  • 1. What are Materialized Views.mp4 (18.6 MB)
  • 1. What are Materialized Views.srt (6.9 KB)
  • 2. Create a Materialized View.mp4 (44.7 MB)
  • 2. Create a Materialized View.srt (7.7 KB)
  • 2.1 materialized views.txt (0.9 KB)
  • 3. ALTER Materialized View.mp4 (11.4 MB)
  • 3. ALTER Materialized View.srt (2.3 KB)
  • 4. Design an optimized query for Materialized View.mp4 (18.7 MB)
  • 4. Design an optimized query for Materialized View.srt (5.8 KB)
  • 4.1 materialized views - patterns.txt (0.4 KB)
  • 5. Auto & Manual Refreshes of Materialized Views.mp4 (40.1 MB)
  • 5. Auto & Manual Refreshes of Materialized Views.srt (9.3 KB)
  • 5.1 materialized views - refreshes.txt (0.3 KB)
  • 6. Limitations & Quotas of Materialized Views.mp4 (6.3 MB)
  • 6. Limitations & Quotas of Materialized Views.srt (2.1 KB)
  • 7. Best Practices in Materialized Views.mp4 (18.1 MB)
  • 7. Best Practices in Materialized Views.srt (6.8 KB)
  • 8. Quiz 3.html (0.1 KB)
13. BQ Command Line
  • 1. Introduction.mp4 (14.1 MB)
  • 1. Introduction.srt (4.7 KB)
  • 2. Cloud SDK Setup.mp4 (18.5 MB)
  • 2. Cloud SDK Setup.srt (4.2 KB)
  • 2.1 Cloud SDK installer download.html (0.1 KB)
  • 3. BQ Basic commands.mp4 (26.2 MB)
  • 3. BQ Basic commands.srt (8.5 KB)
  • 3.1 Global flags link.html (0.1 KB)
  • 4. BQ - Querying Commands.mp4 (34.1 MB)
  • 4. BQ - Querying Commands.srt (10.3 KB)
  • 4.1 Commands.txt (1.7 KB)
  • 4.2 BQ commands.html (0.1 KB)
  • 5. BQ- Dataset creation command.mp4 (6.4 MB)
  • 5. BQ- Dataset creation command.srt (3.4 KB)
  • 5.1 Commands.txt (1.7 KB)
  • 6. BQ - Create all types of Tables.mp4 (18.6 MB)
  • 6. BQ - Create all types of Tables.srt (5.8 KB)
  • 6.1 Commands.txt (1.7 KB)
  • 6.2 BQ_json_schema.txt (0.3 KB)
  • 7. BQ - Load data into Table.mp4 (7.1 MB)
  • 7. BQ - Load data into Table.srt (2.4 KB)
  • 7.1 Load Options link.html (0.1 KB)
  • 8. BQ - Exclusive operations.mp4 (36.5 MB)
  • 8. BQ - Exclusive operations.srt (7.5 KB)
  • 8.1 exclusive commands.txt (0.7 KB)
  • 9. Assignment 3.html (0.1 KB)
14. Python Client Library of BigQuery
  • 1. Setup.mp4 (17.4 MB)
  • 1. Setup.srt (3.6 KB)
  • 2. Python code to create dataset.mp4 (20.3 MB)
  • 2. Python code to create dataset.srt (5.1 KB)
  • 2.1 Attributes link.html (0.2 KB)
  • 2.2 create dataset.py.txt (0.9 KB)
  • 2.3 Client class link.html (0.2 KB)
  • 3. Python code to create table.mp4 (20.1 MB)
  • 3. Python code to create table.srt (4.4 KB)
  • 3.1 LoadConfig Options.html (0.2 KB)
  • 3.2 create_table.py.txt (1.0 KB)
  • 4. Python code to query tables.mp4 (18.8 MB)
  • 4. Python code to query tables.srt (4.1 KB)
16. BigQuery Pricing
  • 1. Storage Pricing.mp4 (11.8 MB)
  • 1. Storage Pricing.srt (5.8 KB)
  • 1.1 Active storage pricing.html (0.1 KB)
  • 2. Query Pricing.mp4 (37.4 MB)
  • 2. Query Pricing.srt (14.7 KB)
  • 2.1 Promotional slots Form.html (0.2 KB)
  • 3. API, DML pricing.mp4 (17.2 MB)
  • 3. API, DML pricing.srt (7.4 KB)
  • 4. Free operations in BigQuery.mp4 (13.6 MB)
  • 4. Free operations in BigQuery.srt (4.7 KB)
  • 5. Google Cloud Pricing Calculator.mp4 (12.9 MB)
  • 5. Google Cloud Pricing Calculator.srt (4.8 KB)
17. Best Practices Optimization Techniques
  • 1. Introduction.mp4 (6.2 MB)
  • 1. Introduction.srt (4.3 KB)
  • 2. Methods to restrict data scan.mp4 (13.8 MB)
  • 2. Methods to restrict data scan.srt (6.3 KB)
  • 3. Ways to reduce CPU time.mp4 (19.0 MB)
  • 3. Ways to reduce CPU time.srt (8.4 KB)
  • 3.1 Approximate Aggregate Functions.html (0.2 KB)
  • 3.2 Native UDFs.html (0.2 KB)
  • 4. Which SQL anti-patterns to avoid.mp4 (18.9 MB)
  • 4. Which SQL anti-patterns to avoid.srt (8.3 KB)
18. BONUS - Different File Formats & BEAM
  • 1. What do we need from a File.mp4 (7.5 MB)
  • 1. What do we need from a File.srt (4.0 KB)
  • 2. Text, Sequence, Avro Files.mp4 (13.1 MB)
  • 2. Text, Sequence, Avro Files.srt (5.2 KB)
  • 3. RC, ORC, Parquet Files.mp4 (13.2 MB)
  • 3. RC, ORC, Parquet Files.srt (4.2 KB)
  • 4. Performance Test results of Various Files.mp4 (8.7 MB)
  • 4. Performance Test results of Various Files.srt (4.0 KB)
  • 5. Which File Format to choose.mp4 (5.8 MB)
  • 5. Which File Format to choose.srt (3.6 KB)
  • 6. Introduction to Apache Beam.mp4 (24.5 MB)
  • 6. Introduction to Apache Beam.srt (7.7 KB)
  • 7. Google PubSub Architecture.mp4 (29.1 MB)
  • 7. Google PubSub Architecture.srt (10.2 KB)
  • 8. Thankyou.mp4 (3.6 MB)
  • 8. Thankyou.srt (2.6 KB)
  • 8.1 BigQuery release notes link.html (0.1 KB)
  • 8.2 Google cloud release notes link.html (0.1 KB)
  • TutsNode.com.txt (0.1 KB)
  • [TGx]Downloaded from torrentgalaxy.to .txt (0.6 KB)

There are currently no comments. Feel free to leave one :)

Code:

  • udp://inferno.demonoid.pw:3391/announce
  • udp://tracker.openbittorrent.com:80/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://torrent.gresille.org:80/announce
  • udp://glotorrents.pw:6969/announce
  • udp://tracker.leechers-paradise.org:6969/announce
  • udp://tracker.pirateparty.gr:6969/announce
  • udp://tracker.coppersurfer.tk:6969/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://9.rarbg.to:2710/announce
  • udp://shadowshq.yi.org:6969/announce
  • udp://tracker.zer0day.to:1337/announce
GDRIVE-CACHE 📁 GD (hit) | ID: 17YP_rATbv... 📄 torrent 🕐 13 Jan 2026, 08:38:17 pm IST ⏰ 07 Feb 2026, 08:38:15 pm IST ✅ Valid for 10d 9h 🔄 Refresh Cache