Google BigQuery CPB200 Certification and Training

Google BigQuery CPB200 Certification and Training by certified and experienced professionals from Irine Digital Factory.



  • Introducing Google BigQuery
  • BigQuery Functional Overview
  • BigQuery Fundamentals
  • Ingesting, Transforming, and Storing Data
  • Pricing and Quotas
  • Clauses and Functions
  • Nested and Repeated Fields
  • Query Performance
  • Troubleshooting Errors
  • Access Control
  • Exporting Data
  • Interfacing with External Tools
  • Working with Google Analytics Premium Data
  • Data Visualization

On-Site Classroom Training

  • Course Duration: 40 Hours
  • Course Cost: Rs. 50,000/ Day + Taxes
  • Infrastructure Required: Apple Compatible Projector, Wifi Connectivity
  • Attendees allowed: 20

Off-Site Virtual Training via Adobe Connect or Cisco WebEx

  • Duration: 40 Hours
  • Cost: Rs. 45,000/ Day + Taxes
  • Infrastructure Required: Wifi Connectivity
  • Attendees allowed: 20
  • Complete access to self-paced high quality video tutorials prepared by experienced and certified experts for 6 months.
  • Access to enterprise-class learning management system (LMS)
  • A certificate of course completion by Irine Digital Factory.
  • In-depth performance reporting for individuals and teams
  • 24x7 online support
  • Access to course forum for 6 months to discuss and share knowledge with peers and like minded professionals.
  • Enterprise discount for all the relevant events, workshops and webinars organised by Irine Digital Factory
  • What are course objectives?
    • 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 take Google BigQuery for Data Analysts CPB200 Corporate Training Program?
    • This course is most suitable for data analysts and data scientists.
  • What are the course pre-requisites before attending Google BigQuery for Data Analysts CPB200 Corporate Training Program?
    • 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
  • Adobe Certified Expert – Photoshop | InDesign | Digital Publishing Suite
  • CEO | Irine Digital Factory Pvt. Ltd
  • National Adjunct Faculty | Visual Communication & Digital Marketing | NIIT Ltd. & (Retainer, implemented over 3000 hours of virtual training on graphic designing, visual communication, digital marketing, customer relationship management to working professionals pan India)
  • Content Developer | NIIT Ltd. (Authored 6 books on digital marketing, 1 on Customer Relationship Management)
  • Art Director | India Today (Headed Art Direction and digital production of 17 magazines)
  • User Group Manager | Adobe InDesign | Illustrator User Groups – Delhi (Community driven program for over 2500 creative professionals pan Delhi NCR)
  • Senior Executive – Siemens Communication, Media & Technology (technical head of the digital publishing, developing highly engaging and intuitive apps for magazines)
  • Corporate Trainer & Workflow Consultant on Branding, Visual Communication, Graphic Designing, Digital Marketing & Digital Publishing
  • Professional Certified Marketer | Digital Marketing – American Marketing Association
  • Social Marketing Certified – HootSuite
  • Google Analytics Certified
  • Google AdWords Fundamentals Certified
  • Google AdWords Search Certified
  • Google AdWords Display Certified
  • Google AdWords Mobile Certified
  • Google AdWords Video Certified
  • Google AdWords Shopping Certified
  • Google Mobile Sites Certified
  • Google Digital Sales Certified
  • Content Marketing Certified – HubSpot
  • Email Marketing Certified – HubSpot
  • Inbound Sales Certified – HubSpot
  • Content Marketing Certified – HubSpot
  • Digital Marketing: Customer Engagement, Social Media, Planning, & Analytics – Columbia Business School
  • Bing Ads Accredited Professional – Microsoft
  • Post Graduate Diploma in Digital Marketing (Pursuing) – Digital Marketing institute

Contact Us

Fields marked with * are required

Share with: