Udemy - BigQuery for Big data engineers - Master Big Query Internals

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size2.1 GB
  • Uploaded Bytutsnode
  • Downloads123
  • Last checkedDec. 11th '20
  • Date uploadedDec. 08th '20
  • Seeders 15
  • Leechers24
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

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)

  • 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