More Information
Special Product Yes
Course feature 24x7 Support, Real-time code analysis and feedback, 100% Money Back Guarantee
Funding
This course is IMDA CITREP+ Funded for Delivery. Singaporeans can also use their SkillsFuture credit for this course.
Category Type Singapore Citizen   Permanent Residents(* with effect from 1 August 2017)
    Training Course and Certification Certification Only Training Course and Certification Certification Only
Organisation-Sponsored Non SMEs Up to 70% of the nett payable course and certification fees, capped at $3,000 per trainee Up to 70% of the nett payable certification fees, capped at $500 per trainee Up to 70% of the nett payable course and certification fees, capped at $3,000 per trainee Up to 70% of the nett payable certification fees, capped at $500 per trainee
SMEs Up to 90% of the nett payable course and certification fees, capped at $3,000 per trainee Up to 90% of the nett payable course and certification fees, capped at $3,000 per trainee
Professionals (40 years old and above) Up to 70% of the nett payable course and certification fees, capped at $3,000 per trainee
Self-Sponsored Professionals Up to 70% of the nett payable course and certification fees, capped at $3,000 per trainee Up to 70% of the nett payable certification fees, capped at $500 per trainee Up to 70% of the nett payable course and certification fees, capped at $3,000 per trainee Up to 70% of the nett payable certification fees, capped at $500 per trainee
Professionals (40 years old and above) Up to 90% of the nett payable course and certification fees, capped at $3,000 per trainee
Students and/or Full Time National Service (NSF) Up to 100% of the nett payable course and certification fees, capped at $2,500 per trainee Up to 100% of the nett payable certification fees, capped at $500 per trainee Not eligible
1) Professionals category includes displaced workers.2) This has been harmonised with SkillsFuture initiatives.*  CITREP+ funding does not support GST, VAT, registration fees, membership fees, rebates, renewal of certification, incentives, discounts or any training grant offered by any course providers or any other organisation in relation to the endorsed courses/certifications.
 
** For more details on CITREP+ funding support for students/NSF, please refer to CITREP+ Claim Application Guide.
 
  • 24x7 Support

  • Real-time code analysis and feedback

  • 100% Money Back Guarantee

BigQuery is Google Cloud's fully managed, petabyte-scale, and cost-effective analytics data warehouse that lets you run analytics over vast amounts of data in near real time. With BigQuery, there's no infrastructure to set up or manage, letting you focus on finding meaningful insights using standard SQL and taking advantage of flexible pricing models across on-demand and flat-rate options.

Train powerful models on structured data with Cloud Machine Learning Engine and TensorFlow integrat.

This course teaches participants the following skills:

  • Load, clean, and transform data at scale with Google Cloud Dataprep

  • Explore and Visualize data using Google Data Studio.

  • Train classification and forecasting ML models using SQL with BQML

  • Practice with pre-built ML APIs for image and text understanding

  • Troubleshoot, optimize, and write high-performance queries

  • Derive insights from data using the analysis and visualization tools on Google Cloud Platform

This course is IMDA CITREP+ Funded for Delivery. Singaporeans can also use their SkillsFuture credit for this course.
Category Type Singapore Citizen   Permanent Residents(* with effect from 1 August 2017)
    Training Course and Certification Certification Only Training Course and Certification Certification Only
Organisation-Sponsored Non SMEs Up to 70% of the nett payable course and certification fees, capped at $3,000 per trainee Up to 70% of the nett payable certification fees, capped at $500 per trainee Up to 70% of the nett payable course and certification fees, capped at $3,000 per trainee Up to 70% of the nett payable certification fees, capped at $500 per trainee
SMEs Up to 90% of the nett payable course and certification fees, capped at $3,000 per trainee Up to 90% of the nett payable course and certification fees, capped at $3,000 per trainee
Professionals (40 years old and above) Up to 70% of the nett payable course and certification fees, capped at $3,000 per trainee
Self-Sponsored Professionals Up to 70% of the nett payable course and certification fees, capped at $3,000 per trainee Up to 70% of the nett payable certification fees, capped at $500 per trainee Up to 70% of the nett payable course and certification fees, capped at $3,000 per trainee Up to 70% of the nett payable certification fees, capped at $500 per trainee
Professionals (40 years old and above) Up to 90% of the nett payable course and certification fees, capped at $3,000 per trainee
Students and/or Full Time National Service (NSF) Up to 100% of the nett payable course and certification fees, capped at $2,500 per trainee Up to 100% of the nett payable certification fees, capped at $500 per trainee Not eligible
1) Professionals category includes displaced workers.2) This has been harmonised with SkillsFuture initiatives.*  CITREP+ funding does not support GST, VAT, registration fees, membership fees, rebates, renewal of certification, incentives, discounts or any training grant offered by any course providers or any other organisation in relation to the endorsed courses/certifications.
 
** For more details on CITREP+ funding support for students/NSF, please refer to CITREP+ Claim Application Guide.
 

To get the most out of this course, participants should have:

Basic proficiency with ANSI SQL

You'll have:

  • Experience in Database

  • Familiarity with SQL 

  • Google Cloud Platform

Course Outline

M1: Data Warehouse Solutions on GCP

M2: BigQuery for Data Warehousing

M3: Migrating to BigQuery

M4: ETL Tools and Positioning

M5: Streaming Analytics

M6: Migrating Spark and Hadoop to GCP

M7: BigQuery Extended Capabilities