Course description

  • What is this course about?

    Google BigQuery for Data Analysts - CPB200 will introduce you to Google BigQuery. Through instructor-led online classrooms, demonstrations, and hands-on labs, you’ll learn to store, transform, analyze, and visualize data using Google BigQuery.

  • What are the Course Objectives?

    By the end of CPB200 training program, you’ll be able to:

    • Understand the purpose of and use cases for Google BigQuery
    • Describe ways in which customers have used Google BigQuery to improve their businesses
    • Understand the architecture of BigQuery and how queries are processed
    • Interact with BigQuery using the web UI and command-line interface
    • Identify the purpose and structure of BigQuery schemas and data types
    • Understand the purpose of and advantages of BigQuery destinations tables and caching
    • Use BigQuery jobs
    • Transform and load data into and export data from BigQuery
    • Store query results in a destination table
    • Create a federated query
    • Export log data to BigQuery and query it
    • Understand the BigQuery pricing structure and evaluate mechanisms for controlling query and storage costs
    • Identify best practices for optimizing query performance
    • Troubleshoot common errors in BigQuery
    • Use various BigQuery functions
    • Use external tools such as spreadsheets to interact with BigQuery
    • Visualize BigQuery data
    • Use access controls to restrict access to BigQuery data
    • Query Google Analytics Premium data exported to BigQuery

  • Who should do this course?

    This course is most suitable for data analysts and data scientists.

Exam & certification

  • How do you become a Google Cloud Certified Professional - Data Engineer?

    The CPB200 course is the final step before you can sit for the Google Cloud Certified Professional - Data Engineer certification. Please refer to the following page for more details

    You can get the certification following the process:
    Step 1: Complete all the required trainings. Please 
    Step 2: Register for exam at:
    Step 3: Google informs the participant if they have passed the examination and receive the certification

    Certification and examination related FAQs are available at

  • What are the prerequisites for this course?

    To attend this course, you need to fulfil the pre-requisites given below.

    • Attended CP100A - Google Cloud Platform Fundamentals OR CPB100 - Google Cloud Platform Big Data & Machine Learning Fundamentals (or equivalent experience)
    • Experience using a SQL-like query language to analyze data

  • What do I need to do to unlock my Simplilearn certificate?

    Online Classroom:
    • You need to attend one complete batch.


    • Who delivers the training?

      All our trainers are Google certified and highly qualified with over 15 years of experience in training and are working in the domain.

    • Is exam fee included in the course fee?

      Yes. The exam fee is included in the course fee.

    • What is the question pattern of GCP Qualified Data Analyst (CPE201) exam?

      The Google Cloud Platform Qualified Data Analyst -CPE201 exam is a combination of multiple-choice, multiple-response, and true/false questions.

    • What is LVC? Is it a classroom training?

      LVC or Live Virtual Classroom training for CPB200 is a live training conducted via online live streaming of a class. LVC is run by Google certified trainer with over 15 years of work experience in the domain and training. The class attended by the global audience can enrich your learning experience.

    • Are these trainings LIVE or do I attend a pre-recorded video?

      All these trainings are live interactive sessions wherein you can raise concerns and discussions at any point during the class. Additionally, we also provide recordings of the sessions attended by you for your future references.

    • What infrastructure do I need to attend this session?

      The system requirements are quite basic:
      OS: Windows any version above XP SP3 & Mac any version above OS X 10.6
      Internet Speed: Preferably above 512 KBPS
      Headset: Any decent headset and microphone which can be used to talk and hear clearly.

    • Who are our Faculties and how are they selected?

      All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience.

      Each of them have gone through a rigorous selection process which includes profile screening, technical evaluation, and training demo before they are certified to train for us.  

      We also ensure that only those trainers with a high alumni rating continue to train for us.

    • What is Global Teaching Assistance?

      Our teaching assistants are here to help you get certified in your first attempt.

      They are a dedicated team of subject matter experts to help you at every step and enrich your learning experience from class onboarding to project mentoring and job assistance.

      They engage with the students proactively to ensure the course path is followed.

      Teaching Assistance is available during business hours.

    • What is covered under the 24/7 Support promise?

      We offer 24/7 support through email, chat, and calls.  

      We also have a dedicated team that provides on demand assistance through our community forum. What’s more, you will have lifetime access to the community forum, even after completion of your course with us.

    • Disclaimer
    • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.