Levelup

Google Cloud Platform Big Data

Big Data on GCP certification course is designed by Industry Experts. Our unique Learning combines live GCP online/offline training classes and interactive labs, gives you job-ready skills.

10 Modules | 50+ Lessons | 20+ Labs | 40+ Projects | Mock Exams | CV Review| On-job Support

5/5

4.5

1,243 ratings

LevelUp Career Certificates

243 Already Enrolled

What Is Google Cloud Platform (GCP)?

Google Cloud is a suite of Cloud Computing services offered by Google that provides
various services like compute, storage, networking, and many more that run on the same infrastructure that Google uses.

Benefits Of Big Data on GCP ?

High productivity is gained through fast and easy access to innovation.
· Minimal disruption when users adopt new functionality.
· Google offers the best pricing plans for stable customers.
· Excellent flexibility and availability of full control over technologies and data.
· Customers are benefited by the process-based and security investments.

Why to get Google Cloud Certified?

The demand for individuals with GCP certification is exponentially rising.
·87 percent of Google Cloud certified users feel confident in cloud skills
· The highest paying certification of 2019 was Professional Cloud Architect
· 30% of Google Cloud certified users took on leadership roles at work

Have a Doubt?

Request a Call back

What you'll learn from this course

  • Learn Full In Out of Google Cloud BigQuery with proper HANDS-ON examples
    from scratch.

  • Get an Overview of Google Cloud Platform and a brief introduction to the set of
    services it provides.

  • Start with Bigquery core concepts like understanding its Architecture, Dataset, Table,
    View, Materialized View, Schedule queries, Limitations & Quotas.

  • ADVANCE Big query topics like Query Execution plan, Efficient schema design,
    Optimization techniques, Partitioning, Clustering, etc.

  • Build Big data pipelines using various Google Cloud Platform services - Dataflow,
    Pub/Sub, BigQuery, Cloud storage, Beam, Data Studio, Cloud Composer/Airflow.

  • Learn Best practices to follow in Real-Time Projects for Performance and Cost
    saving for every component of Big query.

    .

  • Bigquery Pricing models for Storage, Querying, API requests, DMLs and free
    operations.

    .

  • Data-sets and Queries used in lectures are available in resources tab. This will save
    your typing efforts.

    .

You will be able to master these 11 critical core skills…

Google Cloud Service Providers Overview

Google BigQuery

Query Execution Plan

Efficient schema design

Optimization techniques

Partitioning

Apache Beam

Pub/Sub

Data Studio

Cloud Composer or Airflow

Data Studio

There are 17 Modules in this Professional Certificate

Module

1

  • Compute Services in GCP
  • Storage Services in GCP
  •  Big data Services in GCP

Module

2

  • Conventional Datawarehouse Problems
  • What is BigQuery
  • BigQuery Out-of-the Box Features
  • Architecture of BigQuery

Module

3

  • Setup a GCP account
  • Create a Project
  • BigQuery UI Tour
  • Region Vs Multi-region
  • Create a Dataset
  • Create a Table

Module

4

  • Running query with various Query Settings
  • Caching features & limitations
  • Querying Wildcard Tables
  •  Wildcard Table Limitations
  • Schedule, Save, Share a Query
  •  Schema Auto detection
  • Design an efficient schema for BigQuery
  •  Running query with various Query Settings
  • Caching features & limitations
  • Querying Wildcard Tables
  •  Wildcard Table Limitations
  • Schedule, Save, Share a Query
  • Schema Auto detection

Module

5

  • Copying Datasets
  • Transfer Service for scheduling Copy Jobs
  • Native operations on Table for Schema change
  • Manual operations on Table

Module

6

  • How BigQuery creates Execution Plan of a Query
  • Understanding Execution Plan in UI

Module​

7

  • What is Partitioning & its benefits
  •  Ingestion time Partitioned Tables
  • Date column Partitioned Tables
  • Integer based Partitioned Tables
  • ALTER, COPY operations on Partitioned Tables
  •  DML operations on Partitioned Tables
  • Best Practices for Partitioning

Module​

8

  • What is Clustering
  • When to use Clustering OR Partitioning OR Both
  • Create Clustered Table
  •  Dos & Don'ts for Clustering

Module​

9

  • Introduction and Create Cloud Storage Bucket
  • Create & Query Permanent Table on Cloud Storage bucket
  • External data source Limitations

Module​

10

  • Introduction to Views its Advantages
  • Create Views in BigQuery
  • Restrict rows at User level in Views
  • Limitations of Views

Module​

11

  • What are Materialized Views
  •  Create a Materialized View
  •  ALTER Materialized View
  • Design an optimized query for Materialized View
  • Auto & Manual Refreshes of Materialized

Module​

12

  • Introduction
  •  Cloud SDK Setup
  • BQ Basic commands
  • BQ-Querying Commands
  • BQ-Dataset creation command
  • BQ-Create all types of Tables
  •  BQ-Load data into Table

Module​

13

  • Setup
  • Python code to create dataset
  • Python code to create table
  • Python code to query tables

Module​

14

  • Pipelines (Apache Beam)
  • Case Study Requirements
  • GCP approach to case study
  •  Apache Beam Pipeline creation
  •  Write Transformations in Beam
  • Write to BigQuery
  •  Create View for Daily data
  •  Python 3 code
  • Run the Beam Pipeline
  •  Create Reports in Cloud DataStudio
  • Create monthly reports in DataStudio
  • Write Airflow DAG to schedule
  • Create Cloud Composer environment and run DAG

Module​

15

  • Introduction
  • Google Pub/Sub Architecture
  • Publish messages to Pub/Sub
  •  Beam pipeline for Streaming data

Module​

16

  • Storage Pricing
  •  Query Pricing
  •  API, DML pricing
  •  Free operations in BigQuery
  •  GCP Calculator

Module​

17

  • Methods to restrict data scan
  • Ways to reduce CPU time
  • Which SQL anti-patterns to avoid

What is a Professional Certificate?

Build the Skills to Get Job Ready

Whether you’re looking to start a new career, or change your current one, Professional Certificates on Coursera help you become job ready. Learn at your own pace, whenever and wherever it’s most convenient for you. Enroll today and explore a new career path with a 7 day free trial. You can pause your learning or end your subscription at any time.

Earn a Career Credential

When you complete all of the courses in the program, you’ll earn a Certificate to share with your professional network as well as unlock access to career support resources to help you kickstart your new career. Many Professional Certificates have hiring partners that recognize the Professional Certificate credential and others can help prepare you for a certification exam. You can find more information on individual Professional Certificate pages where it applies.

Satheesh Pabbathi

CEO of LevelUp - Teaching 5,000+ Students

4.3

Instructor ratings

1,250 Reviews

10,000 + Students

Sateesh Pabbathi is a solutions architect, consultant and software developer who has an interest in all things related to DevOps, Big Data, Cloud & API. He is recognized as Azure Certified Trainer and is an AWS Certified Solutions Architect Professional & AWS Certified , DevOps Professional. He loves to teach people how to use AWS, prepare for AWS certifications, and most importantly for the real world.

Sateesh Pabbathi is a solutions architect, consultant and software developer who has an interest in all things related to DevOps, Big Data, Cloud & API. He is recognized as Azure Certified Trainer and is an AWS Certified Solutions Architect Professional & AWS Certified , DevOps Professional. He loves to teach people how to use AWS, prepare for AWS certifications, and most importantly for the real world.

Get this Professional Certificate, plus unlimited access to 70+ courses, Projects, Specializations, and Professional Certificates

Frequently Asked Questions.

Every professional prefers Google Cloud Platform certification to achieve a better job and promotion in their job. The GCP certification has allowed youth to secure the job of their dreams in established companies with higher career opportunities. Google Cloud certification gives job applicants more advantages and preference than others. Therefore, GCP certification online is the best that any techie professional or student should seek.

If in any case, you miss a session then you can go through a recorded version of Live session which will be available on your learning portal.

All you need is good internet connection with (headset preferably) and leave the rest on us.

6 Months On- Job Support means if you have any queries or concerns with any of your real- time projects at your workplace, we will help you with the answers for the same however you need to implement it on your own.

Yes. LevelUp provides more than 500 practice exams in. You can find the exams in www.mockcertification.com Website.

Yes. You can access to the real time projects at www.learnwithprojects.com . Every Month 2 Real time projects are added.

LevelUp Provides more than 1200 interview questions in www.crackcloudinterviews.com website.

What our student say about us . . .

Reach us Now