{"id":29377,"date":"2026-06-19T10:01:20","date_gmt":"2026-06-19T10:01:20","guid":{"rendered":"https:\/\/www.cloudthat.com\/training\/?post_type=stm-courses&p=29377"},"modified":"2026-06-19T11:31:47","modified_gmt":"2026-06-19T11:31:47","slug":"bigquery-for-data-analysts-2","status":"publish","type":"stm-courses","link":"https:\/\/www.cloudthat.com\/training\/google-cloud-certification\/bigquery-for-data-analysts","title":{"rendered":"BigQuery for Data Analysts"},"content":{"rendered":"

BigQuery for data analysts course is designed for data analysts looking to leverage <\/span>BigQuery<\/span>\u00a0for high-performance data analysis. Through a mix of videos, hands-on labs, and demos, you will learn to navigate the\u00a0<\/span>BigQuery<\/span>\u00a0ecosystem, write optimized SQL for large-scale datasets, and\u00a0<\/span>utilize<\/span>\u00a0advanced features like\u00a0<\/span>Dataform<\/span>\u00a0and\u00a0<\/span>BigQuery<\/span> Studio to derive actionable business insights.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

BigQuery for data analysts course is designed for data analysts looking to leverage BigQuery\u00a0for high-performance data analysis. Through a mix of videos, hands-on labs, and demos, you will learn to navigate the\u00a0BigQuery\u00a0ecosystem, write optimized SQL for large-scale datasets, and\u00a0utilize\u00a0advanced features like\u00a0Dataform\u00a0and\u00a0BigQuery Studio to derive actionable business insights.<\/p>\n","protected":false},"author":6436,"featured_media":28795,"template":"","meta":{"footnotes":""},"stm_lms_course_taxonomy":[58],"metadata":{"stm_lms_product_id":["29378"],"_edit_lock":["1781868719:12"],"_edit_last":["12"],"permalink_customizer":["google-cloud-certification\/bigquery-for-data-analysts"],"permalink_customizer_regenerate_status":["1"],"popular_course":["0"],"_popular_course":["field_64253688bc2e5"],"course_banner_image":[""],"_course_banner_image":["field_63c69a6b81cf1"],"mobile_banner_image":[""],"_mobile_banner_image":["field_63cf93896d207"],"banner_link":[""],"_banner_link":["field_63c69a9681cf2"],"banner_image":[""],"_banner_image":["field_621873548f922"],"banner_description":["Master the art of data analysis at scale. Learn to ingest, transform, and query massive datasets using Google Cloud\u2019s serverless enterprise data warehouse. "],"_banner_description":["field_612c733ed3564"],"overview_section_heading":["Course Overview of BigQuery for Data Analysts "],"_overview_section_heading":["field_64538867ffdd0"],"after_completing_course_heading":["After completing BigQuery for Data Analysts"],"_after_completing_course_heading":["field_645c78ade3f50"],"after_completing_course":["6"],"_after_completing_course":["field_6103aae828228"],"key_features_heading":["Key Features of BigQuery for Data Analysts"],"_key_features_heading":["field_645388ceffdd1"],"key_features":["5"],"_key_features":["field_6103aaff28229"],"who_should_attend_heading":["Who should Attend BigQuery for Data Analysts?"],"_who_should_attend_heading":["field_645388faffdd2"],"who_should_attend":["1"],"_who_should_attend":["field_6103ab0d2822a"],"prerequisites_heading":["Prerequisites of BigQuery for Data Analysts "],"_prerequisites_heading":["field_64538a51ffdd3"],"prerequisites_text":["Completion of \"Introduction to Data Analytics on Google Cloud\" or equivalent experience. "],"_prerequisites_text":["field_612c7498c4b84"],"question_sets_details_heading":[""],"_question_sets_details_heading":["field_65d303841f38d"],"question_sets_details_description":[""],"_question_sets_details_description":["field_65d303841f38e"],"question_sets_details_button_text":[""],"_question_sets_details_button_text":["field_65d303841f38f"],"question_sets_details_question_sets":[""],"_question_sets_details_question_sets":["field_65d303841f390"],"question_sets_details":[""],"_question_sets_details":["field_65d303841f38c"],"category_features_heading":[""],"_category_features_heading":["field_644b8ff35049c"],"category_features_features":[""],"_category_features_features":["field_644b90025049d"],"category_features_cta_text":[""],"_category_features_cta_text":["field_644b90285049f"],"category_features_cta_link":[""],"_category_features_cta_link":["field_644b902d504a0"],"category_features":[""],"_category_features":["field_644b8fe15049b"],"course_features_0_heading":["Why choose CloudThat as your training partner for BigQuery for Data Analysts?"],"_course_features_0_heading":["field_644a0fae0e67e"],"course_features_0_features_list":["8"],"_course_features_0_features_list":["field_644a0fb70e67f"],"course_features_0_background_color":["a:1:{i:0;s:4:\"blue\";}"],"_course_features_0_background_color":["field_644a0fde0e681"],"course_features_1_heading":["Learning Objectives of BigQuery for Data Analysts "],"_course_features_1_heading":["field_644a0fae0e67e"],"course_features_1_features_list":["6"],"_course_features_1_features_list":["field_644a0fb70e67f"],"course_features_1_background_color":["a:1:{i:0;s:5:\"white\";}"],"_course_features_1_background_color":["field_644a0fde0e681"],"course_features":["2"],"_course_features":["field_644a0fa10e67d"],"certification_heading":["Certification Details of BigQuery for Data Analysts "],"_certification_heading":["field_64538bffffdd5"],"certification":["1"],"_certification":["field_6103ab1a2822b"],"about_trainer":[""],"_about_trainer":["field_6103ab6c2822f"],"course_fee_heading":[""],"_course_fee_heading":["field_64538c1cffdd6"],"course_fee_list":[""],"_course_fee_list":["field_6103abb728234"],"brochure_pdf":[""],"_brochure_pdf":["field_61232e258f89b"],"trainer":[""],"_trainer":["field_6124990e13784"],"course_outline_heading":["Course Outline for BigQuery for Data Analysts "],"_course_outline_heading":["field_64538a8effdd4"],"course_section":["8"],"_course_section":["field_612f4f27b0276"],"note_section":[""],"_note_section":["field_616d3ed46bbd2"],"popular_sort":[""],"_popular_sort":["field_6172496402af3"],"related_courses":["a:3:{i:0;s:4:\"8287\";i:1;s:5:\"28709\";i:2;s:5:\"28404\";}"],"_related_courses":["field_61c453ca6b2dd"],"reviews_heading":[""],"_reviews_heading":["field_64538c39ffdd7"],"review_rating":[""],"_review_rating":["field_62a813a92bee6"],"total_review_count":["1946"],"_total_review_count":["field_62b002d8d2de5"],"average_review_count":["4.8"],"_average_review_count":["field_62b00367d2de6"],"faq_heading":["FAQs for BigQuery for Data Analysts "],"_faq_heading":["field_64538c59ffdd8"],"educational_schema":[""],"_educational_schema":["field_652fbbf6f589a"],"curriculum":[""],"featured":[""],"views":["17"],"level":["intermediate"],"current_students":["0"],"duration_info":["2 Days"],"video_duration":[""],"status":[""],"status_dates":[""],"not_single_sale":[""],"price":["115900"],"sale_price":[""],"sale_price_dates":[""],"enterprise_price":[""],"not_membership":[""],"affiliate_course":[""],"affiliate_course_text":[""],"affiliate_course_link":[""],"expiration_course":[""],"end_time":[""],"drip_content":[""],"prerequisites":[""],"prerequisite_passing_level":[""],"announcement":[""],"faq":["[{\"question\":\"What is the primary focus of this course? \",\"answer\":\"It focuses on using BigQuery for data ingestion, transformation, analysis, and visualization.\"},{\"question\":\"Does this course cover AI?\",\"answer\":\"Yes, it includes labs on using Gemini and Duet AI assistance within BigQuery Studio. \"},{\"question\":\"What is Dataform?\",\"answer\":\"Dataform is a tool covered in Module 06 for developing scalable data transformation pipelines.\"},{\"question\":\"Are there labs?\",\"answer\":\"Yes, the course includes 10 hands-on labs, including Connected Sheets and Looker Studio exercises. \"},{\"question\":\"How long is the instructor-led version?\",\"answer\":\"The ILT version is delivered over 2 days.\"},{\"question\":\"Can I use my own data during labs?\",\"answer\":\"Labs are conducted in a provided sandbox environment with pre-loaded datasets. \"},{\"question\":\"What visualization tools are taught?\",\"answer\":\"Looker Studio and Connected Sheets (Google Sheets integration). \"},{\"question\":\"Will I learn how to manage data pipelines? \",\"answer\":\"Yes, specifically using Dataform to create repositories and execute workflows.\"},{\"question\":\"What is BigQuery Studio?\",\"answer\":\"A new unified interface for analytics, which is explored in Module 07. \"},{\"question\":\"Is this course for data engineers?\",\"answer\":\"While useful for engineers, it is specifically tailored to the workflow of a Data Analyst. \"}]"],"course_files_pack":[""],"course_certificate":[""],"type":[""],"video_type":[""],"presto_player_idx":[""],"lesson_video":[""],"lesson_video_poster":[""],"lesson_video_width":[""],"lesson_shortcode":[""],"lesson_embed_ctx":[""],"lesson_youtube_url":[""],"lesson_stream_url":[""],"lesson_vimeo_url":[""],"lesson_ext_link_url":[""],"duration":[""],"preview":[""],"lesson_excerpt":[""],"lesson_files_pack":[""],"questions":[""],"quiz_style":[""],"duration_measure":[""],"correct_answer":[""],"passing_grade":[""],"re_take_cut":[""],"random_questions":[""],"answers":[""],"question_explanation":[""],"question_view_type":[""],"review_course":[""],"review_user":[""],"review_mark":[""],"order":[""],"absolute":[""],"sticky":[""],"sticky_threshold":[""],"sticky_threshold_color":[""],"stm_agenda":[""],"stm_host":[""],"stm_select_approved_denied":[""],"stm_multiselect_approved":[""],"stm_multiselect_denied":[""],"stm_date":[""],"stm_time":[""],"stm_timezone":[""],"stm_duration":[""],"stm_password":[""],"stm_waiting_room":[""],"stm_join_before_host":[""],"stm_host_join_start":[""],"stm_start_after_participants":[""],"stm_mute_participants":[""],"stm_enforce_login":[""],"stm_alternative_hosts":[""],"author_id":[""],"emails":[""],"wpdocs-meta-bdt":["14900"],"wpdocs-meta-gbp":["1199"],"wpdocs-meta-rand":["26527"],"wpdocs-meta-aed":["5868"],"wpdocs-meta-usd":["1599"],"offline_price":[""],"offline-bdt":[""],"offline-gbp":[""],"offline-rand":[""],"offline-aed":[""],"offline-usd":[""],"_yoast_wpseo_primary_stm_lms_course_taxonomy":["58"],"_yoast_wpseo_content_score":["60"],"_yoast_wpseo_estimated-reading-time-minutes":["1"],"after_completing_course_0_desciption":["Communicate the value and architecture of the BigQuery enterprise data warehouse."],"_after_completing_course_0_desciption":["field_6103ad2f9f5b2"],"after_completing_course_1_desciption":["Write complex SQL queries to analyze and transform petabyte-scale datasets."],"_after_completing_course_1_desciption":["field_6103ad2f9f5b2"],"after_completing_course_2_desciption":["Ingest data from various sources, including external and cloud-native databases."],"_after_completing_course_2_desciption":["field_6103ad2f9f5b2"],"after_completing_course_3_desciption":["Automate and version-control data pipelines using Dataform."],"_after_completing_course_3_desciption":["field_6103ad2f9f5b2"],"after_completing_course_4_desciption":["Utilize generative AI assistants to accelerate SQL development and data exploration. "],"_after_completing_course_4_desciption":["field_6103ad2f9f5b2"],"after_completing_course_5_desciption":["Build interactive dashboards and reports using Google\u2019s visualization tools. "],"_after_completing_course_5_desciption":["field_6103ad2f9f5b2"],"key_features_0_lists":["Comprehensive<\/span>\u00a0Learning Path:<\/span><\/span>\u00a0Includes 9 modules, 44 videos, 10 hands-on labs, and 3 live-action demos.<\/span><\/span>"],"_key_features_0_lists":["field_6103ad559f5b3"],"key_features_1_lists":["SQL<\/span>-First Approach:<\/span><\/span>\u00a0Deep dive into cleaning, transforming, and\u00a0<\/span>analyzing<\/span>\u00a0data using standard SQL.<\/span><\/span>\u00a0<\/span>"],"_key_features_1_lists":["field_6103ad559f5b3"],"key_features_2_lists":["\u00a0<\/span><\/span>Modern<\/span>\u00a0Data Engineering:<\/span><\/span>\u00a0Integration with\u00a0<\/span><\/span>Dataform<\/span><\/span>\u00a0for developing scalable data transformation pipelines.<\/span><\/span>"],"_key_features_2_lists":["field_6103ad559f5b3"],"key_features_3_lists":["Next<\/span>-Gen AI Assistance:<\/span><\/span>\u00a0Hands-on experience with\u00a0<\/span><\/span>Gemini<\/span><\/span>\u00a0and\u00a0<\/span><\/span>Duet AI<\/span><\/span>\u00a0(<\/span>BigQuery<\/span>\u00a0Studio) for SQL explanation and generation.<\/span><\/span>\u00a0<\/span>"],"_key_features_3_lists":["field_6103ad559f5b3"],"key_features_4_lists":["Visualization<\/span>\u00a0Ecosystem:<\/span><\/span>\u00a0Learn to bridge the gap between raw data and insights using\u00a0<\/span><\/span>Connected Sheets<\/span><\/span>\u00a0and\u00a0<\/span><\/span>Looker Studio<\/span><\/span>.<\/span><\/span>"],"_key_features_4_lists":["field_6103ad559f5b3"],"who_should_attend_0_attend_lists":["Data analysts who need to use BigQuery for business intelligence and data exploration. "],"_who_should_attend_0_attend_lists":["field_6103adfb3f3e4"],"course_features_0_features_list_0_list":["Specialized GCP Focus<\/span><\/span>:\u202f<\/span>CloudThat<\/span>\u00a0specializes in cloud technologies, offering focused and specialized training programs. We are Authorized Trainers for the Google Cloud Platform. This specialization ensures in-depth coverage of GCP services, use cases, best practices, and hands-on experience tailored specifically for GCP.<\/span><\/span>\u00a0<\/span>"],"_course_features_0_features_list_0_list":["field_644a0fc80e680"],"course_features_0_features_list_1_list":["Industry-Recognized Trainers<\/span><\/span>:\u202f<\/span>CloudThat<\/span>\u00a0has a strong pool of industry-recognized trainers certified by GCP. These trainers bring real-world experience and practical insights into the training sessions, comprehensively understanding how GCP is applied in different industries and scenarios.<\/span><\/span>\u00a0<\/span>"],"_course_features_0_features_list_1_list":["field_644a0fc80e680"],"course_features_0_features_list_2_list":["Hands-On Learning Approach<\/span><\/span>:\u202f<\/span>CloudThat<\/span>\u00a0emphasizes a hands-on learning approach. Learners can access practical labs, real-world projects, and case studies that simulate actual GCP environments. This approach allows learners to apply theoretical knowledge in practical scenarios, enhancing their understanding and skill set.<\/span><\/span>\u00a0<\/span>"],"_course_features_0_features_list_2_list":["field_644a0fc80e680"],"course_features_0_features_list_3_list":["Customized Learning Paths<\/span><\/span>:\u202f<\/span>CloudThat<\/span>\u00a0understands that learners have\u00a0<\/span>different levels<\/span>\u00a0of\u00a0<\/span>expertise<\/span>\u00a0and varied learning\u00a0<\/span>objectives<\/span>. We offer customized learning paths, catering to beginners, intermediate learners, and professionals seeking advanced GCP skills.<\/span><\/span>\u00a0<\/span>"],"_course_features_0_features_list_3_list":["field_644a0fc80e680"],"course_features_0_features_list_4_list":["Interactive Learning Experience<\/span><\/span>:\u202f<\/span>CloudThat's<\/span>\u00a0training programs are designed to be interactive and engaging. We\u00a0<\/span>utilize<\/span>\u00a0various teaching methodologies like live sessions, group discussions, quizzes, and mentorship to keep learners engaged and motivated throughout the course.<\/span><\/span>\u00a0<\/span>"],"_course_features_0_features_list_4_list":["field_644a0fc80e680"],"course_features_0_features_list_5_list":["Placement Assistance and Career Support<\/span><\/span>:\u202f<\/span>CloudThat<\/span>\u00a0often provides placement\u00a0<\/span>assistance<\/span>\u00a0and career support services. This includes resume building, interview preparation, and\u00a0<\/span>connecting learners with job opportunities through our network of industry partners and companies looking for GCP-certified professionals.<\/span><\/span>\u00a0<\/span>"],"_course_features_0_features_list_5_list":["field_644a0fc80e680"],"course_features_0_features_list_6_list":["Continuous Learning and Updates<\/span><\/span>:\u202f<\/span>CloudThat<\/span>\u00a0ensures that our course content is regularly updated to reflect the latest trends, updates, and best practices within the GCP ecosystem. This commitment to keeping the content current enables learners to stay ahead in their GCP knowledge.<\/span><\/span>\u00a0<\/span>"],"_course_features_0_features_list_6_list":["field_644a0fc80e680"],"course_features_0_features_list_7_list":["Positive Reviews and Testimonials<\/span><\/span>:\u202fReviews and testimonials from past learners can strongly\u00a0<\/span>indicate<\/span>\u00a0the quality of training provided. You can Check feedback and reviews about our GCP courses that can provide potential learners with insights into the effectiveness and value of the training.<\/span><\/span>\u00a0<\/span>"],"_course_features_0_features_list_7_list":["field_644a0fc80e680"],"course_features_1_features_list_0_list":["Architecture & Value:<\/span><\/span>\u00a0Discuss\u00a0<\/span>BigQuery's<\/span>\u00a0data analytics features and storage-compute separation.<\/span><\/span>"],"_course_features_1_features_list_0_list":["field_644a0fc80e680"],"course_features_1_features_list_1_list":["Data<\/span>\u00a0Manipulation:<\/span><\/span>\u00a0Clean, transform, and query datasets using standard SQL functions.<\/span><\/span>\u00a0<\/span>"],"_course_features_1_features_list_1_list":["field_644a0fc80e680"],"course_features_1_features_list_2_list":["Ingestion<\/span>\u00a0Strategies:<\/span><\/span>\u00a0Manage data ingestion and external data source connections.<\/span><\/span>"],"_course_features_1_features_list_2_list":["field_644a0fc80e680"],"course_features_1_features_list_3_list":["Pipeline<\/span>\u00a0Orchestration:<\/span><\/span>\u00a0Create repositories, workspaces, and SQL workflows in\u00a0<\/span>Dataform<\/span>.<\/span><\/span>"],"_course_features_1_features_list_3_list":["field_644a0fc80e680"],"course_features_1_features_list_4_list":["Unified<\/span>\u00a0Analytics:<\/span><\/span>\u00a0Use\u00a0<\/span>BigQuery<\/span>\u00a0Studio for asset management and embedded AI\u00a0<\/span>assistance<\/span>.<\/span><\/span>"],"_course_features_1_features_list_4_list":["field_644a0fc80e680"],"course_features_1_features_list_5_list":["Insights<\/span>\u00a0Visualization:<\/span><\/span>\u00a0Apply visualization principles to data via Looker Studio.<\/span><\/span>"],"_course_features_1_features_list_5_list":["field_644a0fc80e680"],"certification_0_short_description":[""],"_certification_0_short_description":["field_6103ab2f2822c"],"certification_0_list_content":["CloudThat Course Completion Certificate will be awarded to all learners who complete the training. "],"_certification_0_list_content":["field_6103ab4a2822d"],"certification_0_image":["28701"],"_certification_0_image":["field_6103ab5b2822e"],"course_section_0_module_title":["Introduction to BigQuery "],"_course_section_0_module_title":["field_612f5535940c3"],"course_section_0_module_description":[""],"_course_section_0_module_description":["field_612f564c921af"],"course_section_0_section_0_title":["Lecture Content "],"_course_section_0_section_0_title":["field_612f5233b0278"],"course_section_0_section_0_lesson_list_0_lession_title":["BigQuery serverless architecture and decoupled storage vs. compute engine design "],"_course_section_0_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_1_lession_title":["Purpose, core business value, and cloud enterprise scalability advantages"],"_course_section_0_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_2_lession_title":["Navigating the storage tier, computing model, and key administrative features "],"_course_section_0_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list":["3"],"_course_section_0_section_0_lesson_list":["field_612f530a0ac40"],"course_section_0_section_1_title":["Learning Objectives "],"_course_section_0_section_1_title":["field_612f5233b0278"],"course_section_0_section_1_lesson_list_0_lession_title":["Articulate the purpose, value proposition, and decoupled architecture of BigQuery"],"_course_section_0_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_1_lession_title":["Explain how serverless execution provides multi-petabyte analysis capabilities"],"_course_section_0_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list":["2"],"_course_section_0_section_1_lesson_list":["field_612f530a0ac40"],"course_section_0_section":["2"],"_course_section_0_section":["field_612f51e6b0277"],"course_section_1_module_title":["Querying and Analyzing Data"],"_course_section_1_module_title":["field_612f5535940c3"],"course_section_1_module_description":[""],"_course_section_1_module_description":["field_612f564c921af"],"course_section_1_section_0_title":["Lecture Content "],"_course_section_1_section_0_title":["field_612f5233b0278"],"course_section_1_section_0_lesson_list_0_lession_title":["Writing highly performant GoogleSQL syntax for querying large datasets "],"_course_section_1_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_1_lession_title":["Managing common data patterns: filtering, aggregating, and sorting complex schemas"],"_course_section_1_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_2_lession_title":["Cost estimation strategies, structural query dry runs, and billing awareness"],"_course_section_1_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list":["3"],"_course_section_1_section_0_lesson_list":["field_612f530a0ac40"],"course_section_1_section_1_title":["Learning Objectives "],"_course_section_1_section_1_title":["field_612f5233b0278"],"course_section_1_section_1_lesson_list_0_lession_title":["Construct standard SQL queries to extract insights from massive, multi-million row tables"],"_course_section_1_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_1_lession_title":["Evaluate query resource consumption and estimate analysis costs prior to execution"],"_course_section_1_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list":["2"],"_course_section_1_section_1_lesson_list":["field_612f530a0ac40"],"course_section_1_section_2_title":["Lab Content "],"_course_section_1_section_2_title":["field_612f5233b0278"],"course_section_1_section_2_lesson_list_0_lession_title":["Querying and Filtering Large-Scale Datasets in BigQuery"],"_course_section_1_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_2_lesson_list":["1"],"_course_section_1_section_2_lesson_list":["field_612f530a0ac40"],"course_section_1_section":["3"],"_course_section_1_section":["field_612f51e6b0277"],"course_section_2_module_title":["Cleaning and Transforming Data"],"_course_section_2_module_title":["field_612f5535940c3"],"course_section_2_module_description":[""],"_course_section_2_module_description":["field_612f564c921af"],"course_section_2_section_0_title":["Lecture Content "],"_course_section_2_section_0_title":["field_612f5233b0278"],"course_section_2_section_0_lesson_list_0_lession_title":["Advanced SQL techniques: Analytic functions, Window functions, and conditional handling"],"_course_section_2_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_1_lession_title":["De-duplicating data records, parsing structural anomalies, and handling null exceptions"],"_course_section_2_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_2_lession_title":["Flattening nested structures, arrays, and complex semi-structured JSON records "],"_course_section_2_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list":["3"],"_course_section_2_section_0_lesson_list":["field_612f530a0ac40"],"course_section_2_section_1_title":["Learning Objectives "],"_course_section_2_section_1_title":["field_612f5233b0278"],"course_section_2_section_1_lesson_list_0_lession_title":["Apply advanced SQL windowing and analytic functions to clean messy source data"],"_course_section_2_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list_1_lession_title":["Manipulate complex structural schemas, arrays, and nested JSON fields natively in SQL"],"_course_section_2_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list":["2"],"_course_section_2_section_1_lesson_list":["field_612f530a0ac40"],"course_section_2_section_2_title":["Lab Content "],"_course_section_2_section_2_title":["field_612f5233b0278"],"course_section_2_section_2_lesson_list_0_lession_title":["Data Cleansing and Schema Transformations Using Advanced SQL"],"_course_section_2_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_2_lesson_list":["1"],"_course_section_2_section_2_lesson_list":["field_612f530a0ac40"],"course_section_2_section":["3"],"_course_section_2_section":["field_612f51e6b0277"],"course_section_3_module_title":["Ingesting Data into BigQuery"],"_course_section_3_module_title":["field_612f5535940c3"],"course_section_3_module_description":[""],"_course_section_3_module_description":["field_612f564c921af"],"course_section_3_section_0_title":["Lecture Content "],"_course_section_3_section_0_title":["field_612f5233b0278"],"course_section_3_section_0_lesson_list_0_lession_title":[" Ingestion modalities: Batch loading, streaming inserts, and schema auto-detection"],"_course_section_3_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_1_lession_title":["Setting up external data sources and federated querying (Cloud Storage, Bigtable, Cloud SQL)"],"_course_section_3_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_2_lession_title":["Standard file format ingestions: Parquet, Avro, CSV, and JSON schema configurations"],"_course_section_3_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list":["3"],"_course_section_3_section_0_lesson_list":["field_612f530a0ac40"],"course_section_3_section_1_title":["Learning Objectives "],"_course_section_3_section_1_title":["field_612f5233b0278"],"course_section_3_section_1_lesson_list_0_lession_title":["Provision new datasets and load files from external data storage repositories"],"_course_section_3_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_1_lession_title":["Execute federated queries against external sources without moving data into BigQuery "],"_course_section_3_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list":["2"],"_course_section_3_section_1_lesson_list":["field_612f530a0ac40"],"course_section_3_section_2_title":["Lab Content "],"_course_section_3_section_2_title":["field_612f5233b0278"],"course_section_3_section_2_lesson_list_0_lession_title":["Loading Data and Querying External Federated Storage Systems"],"_course_section_3_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_2_lesson_list":["1"],"_course_section_3_section_2_lesson_list":["field_612f530a0ac40"],"course_section_3_section":["3"],"_course_section_3_section":["field_612f51e6b0277"],"course_section_4_module_title":["Visualizing Data"],"_course_section_4_module_title":["field_612f5535940c3"],"course_section_4_module_description":[""],"_course_section_4_module_description":["field_612f564c921af"],"course_section_4_section_0_title":["Lecture Content "],"_course_section_4_section_0_title":["field_612f5233b0278"],"course_section_4_section_0_lesson_list_0_lession_title":["Bridging the gap between spreadsheet modeling and big data using Connected Sheets"],"_course_section_4_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_1_lession_title":["Connecting BigQuery to Looker Studio for enterprise dashboard engineering"],"_course_section_4_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_2_lession_title":["Best practices for caching query data, performance optimization, and asset sharing"],"_course_section_4_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list":["3"],"_course_section_4_section_0_lesson_list":["field_612f530a0ac40"],"course_section_4_section_1_title":["Learning Objectives "],"_course_section_4_section_1_title":["field_612f5233b0278"],"course_section_4_section_1_lesson_list_0_lession_title":[" Analyze millions of rows of data using familiar spreadsheet formulas via Connected Sheets"],"_course_section_4_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_1_lesson_list_1_lession_title":["Architect real-time, interactive data visualizations and executive dashboards in Looker Studio"],"_course_section_4_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_4_section_1_lesson_list":["2"],"_course_section_4_section_1_lesson_list":["field_612f530a0ac40"],"course_section_4_section_2_title":["Lab Content "],"_course_section_4_section_2_title":["field_612f5233b0278"],"course_section_4_section_2_lesson_list_0_lession_title":["Creating Interactive Enterprise Reports with Connected Sheets and Looker Studio "],"_course_section_4_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_2_lesson_list":["1"],"_course_section_4_section_2_lesson_list":["field_612f530a0ac40"],"course_section_4_section":["3"],"_course_section_4_section":["field_612f51e6b0277"],"course_section_5_module_title":["Dataform Pipelines"],"_course_section_5_module_title":["field_612f5535940c3"],"course_section_5_module_description":[""],"_course_section_5_module_description":["field_612f564c921af"],"course_section_5_section_0_title":["Lecture Content "],"_course_section_5_section_0_title":["field_612f5233b0278"],"course_section_5_section_0_lesson_list_0_lession_title":["Introduction to Dataform for scalable, version-controlled SQL workflow orchestration "],"_course_section_5_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list_1_lession_title":["Managing Dataform repositories, initializing continuous release environments, and workspaces"],"_course_section_5_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list_2_lession_title":["Defining dataset definitions, dependency graphs, assertions, and testing scripts via SQLX "],"_course_section_5_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list":["3"],"_course_section_5_section_0_lesson_list":["field_612f530a0ac40"],"course_section_5_section_1_title":["Learning Objectives "],"_course_section_5_section_1_title":["field_612f5233b0278"],"course_section_5_section_1_lesson_list_0_lession_title":["Modularize and build production-ready data transformation pipelines within Dataform"],"_course_section_5_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_5_section_1_lesson_list_1_lession_title":["Implement Git-based version control, repository branches, and data testing assertions"],"_course_section_5_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_5_section_1_lesson_list":["2"],"_course_section_5_section_1_lesson_list":["field_612f530a0ac40"],"course_section_5_section_2_title":["Lab Content "],"_course_section_5_section_2_title":["field_612f5233b0278"],"course_section_5_section_2_lesson_list_0_lession_title":["Organizing and Executing Scalable SQL Workflows in Dataform"],"_course_section_5_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_5_section_2_lesson_list":["1"],"_course_section_5_section_2_lesson_list":["field_612f530a0ac40"],"course_section_5_section":["3"],"_course_section_5_section":["field_612f51e6b0277"],"course_section_6_module_title":["BigQuery Studio"],"_course_section_6_module_title":["field_612f5535940c3"],"course_section_6_module_description":[""],"_course_section_6_module_description":["field_612f564c921af"],"course_section_6_section_0_title":["Lecture Content "],"_course_section_6_section_0_title":["field_612f5233b0278"],"course_section_6_section_0_lesson_list_0_lession_title":["Navigating the unified analytics workspace for data scientists, engineers, and analysts"],"_course_section_6_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list_1_lession_title":["Accelerating development cycles using built-in generative AI (Gemini \/ Duet AI code assistance) "],"_course_section_6_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list_2_lession_title":["Architecting real-time streaming pipelines using BigQuery continuous queries"],"_course_section_6_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list":["3"],"_course_section_6_section_0_lesson_list":["field_612f530a0ac40"],"course_section_6_section_1_title":["Learning Objectives "],"_course_section_6_section_1_title":["field_612f5233b0278"],"course_section_6_section_1_lesson_list_0_lession_title":["Use BigQuery Studio as a centralized collaborative interface for data and AI workloads "],"_course_section_6_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_6_section_1_lesson_list_1_lession_title":["Leverage Gemini generative AI tools to explain, build, and optimize complex queries"],"_course_section_6_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_6_section_1_lesson_list_2_lession_title":["Formulate continuous streaming queries to analyze continuous, real-time event logs "],"_course_section_6_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_6_section_1_lesson_list":["3"],"_course_section_6_section_1_lesson_list":["field_612f530a0ac40"],"course_section_6_section_2_title":["Lab Content "],"_course_section_6_section_2_title":["field_612f5233b0278"],"course_section_6_section_2_lesson_list_0_lession_title":["Leveraging Gemini Assistance and Continuous Queries in BigQuery Studio "],"_course_section_6_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_6_section_2_lesson_list":["1"],"_course_section_6_section_2_lesson_list":["field_612f530a0ac40"],"course_section_6_section":["3"],"_course_section_6_section":["field_612f51e6b0277"],"course_section_7_module_title":["Summary"],"_course_section_7_module_title":["field_612f5535940c3"],"course_section_7_module_description":[""],"_course_section_7_module_description":["field_612f564c921af"],"course_section_7_section_0_title":["Lecture Content "],"_course_section_7_section_0_title":["field_612f5233b0278"],"course_section_7_section_0_lesson_list_0_lession_title":["Comprehensive retrospective review of key data analysis and data engineering topics"],"_course_section_7_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list_1_lession_title":["BigQuery design patterns for production architectures, enterprise partitioning, and clustering"],"_course_section_7_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list_2_lession_title":["Google Cloud-recommended analytics governance, safety, and operational best practices"],"_course_section_7_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list":["3"],"_course_section_7_section_0_lesson_list":["field_612f530a0ac40"],"course_section_7_section_1_title":["Learning Objectives "],"_course_section_7_section_1_title":["field_612f5233b0278"],"course_section_7_section_1_lesson_list_0_lession_title":["Synthesize core capabilities of BigQuery, Dataform, and visualization tools to build scalable, end-to-end data analytics solutions"],"_course_section_7_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_7_section_1_lesson_list":["1"],"_course_section_7_section_1_lesson_list":["field_612f530a0ac40"],"course_section_7_section":["2"],"_course_section_7_section":["field_612f51e6b0277"],"_thumbnail_id":["28795"],"_wp_old_date":["2026-06-08"]},"acf":[],"_links":{"self":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/29377"}],"collection":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses"}],"about":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/types\/stm-courses"}],"author":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/users\/6436"}],"version-history":[{"count":7,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/29377\/revisions"}],"predecessor-version":[{"id":29620,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/29377\/revisions\/29620"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media\/28795"}],"wp:attachment":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media?parent=29377"}],"wp:term":[{"taxonomy":"stm_lms_course_taxonomy","embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm_lms_course_taxonomy?post=29377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}