{"id":28857,"date":"2026-06-07T05:59:07","date_gmt":"2026-06-07T05:59:07","guid":{"rendered":"https:\/\/www.cloudthat.com\/training\/?post_type=stm-courses&p=28857"},"modified":"2026-06-07T06:00:06","modified_gmt":"2026-06-07T06:00:06","slug":"migrating-teradata-users-to-bigquery","status":"publish","type":"stm-courses","link":"https:\/\/www.cloudthat.com\/training\/google-cloud-certification\/migrating-teradata-users-to-bigquery","title":{"rendered":"Migrating Teradata Users to BigQuery"},"content":{"rendered":"

This course enables learners to translate various concepts from Teradata to analogous concepts in\u00a0<\/span>BigQuery<\/span>. It provides a solid foundation for the journey from Teradata to\u00a0<\/span>BigQuery<\/span>\u00a0by comparing architectures, resource configurations, data types, and SQL dialects<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

This course enables learners to translate various concepts from Teradata to analogous concepts in\u00a0BigQuery. It provides a solid foundation for the journey from Teradata to\u00a0BigQuery\u00a0by comparing architectures, resource configurations, data types, and SQL dialects<\/p>\n","protected":false},"author":6436,"featured_media":28761,"template":"","meta":{"footnotes":""},"stm_lms_course_taxonomy":[58],"metadata":{"stm_lms_product_id":["28858"],"_edit_lock":["1780811935:5091"],"_edit_last":["5091"],"permalink_customizer":["google-cloud-certification\/migrating-teradata-users-to-bigquery"],"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":["Learn to translate Teradata concepts to BigQuery, compare high-level architectures, and optimize schemas for Google Cloud\u2019s data warehouse. "],"_banner_description":["field_612c733ed3564"],"overview_section_heading":["Course Overview of Migrating Teradata Users to BigQuery "],"_overview_section_heading":["field_64538867ffdd0"],"after_completing_course_heading":["After completing Migrating Teradata Users to BigQuery, students will be able to:"],"_after_completing_course_heading":["field_645c78ade3f50"],"after_completing_course":["4"],"_after_completing_course":["field_6103aae828228"],"key_features_heading":["Key Features of Migrating Teradata Users to BigQuery "],"_key_features_heading":["field_645388ceffdd1"],"key_features":["5"],"_key_features":["field_6103aaff28229"],"who_should_attend_heading":["Who Should Attend Migrating Teradata Users to BigQuery?"],"_who_should_attend_heading":["field_645388faffdd2"],"who_should_attend":["3"],"_who_should_attend":["field_6103ab0d2822a"],"prerequisites_heading":["Prerequisites of Migrating Teradata Users to BigQuery"],"_prerequisites_heading":["field_64538a51ffdd3"],"prerequisites_text":["

  • Experience using Teradata as a data warehouse for managing data and performing SQL analysis. \r\n
  • Basic experience with BigQuery is recommended but not required. "],"_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 Migrating Teradata Users to BigQuery?"],"_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 Migrating Teradata Users to BigQuery "],"_course_features_1_heading":["field_644a0fae0e67e"],"course_features_1_features_list":["7"],"_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 Migrating Teradata Users to BigQuery "],"_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 Migrating Teradata Users to BigQuery "],"_course_outline_heading":["field_64538a8effdd4"],"course_section":["5"],"_course_section":["field_612f4f27b0276"],"note_section":[""],"_note_section":["field_616d3ed46bbd2"],"popular_sort":[""],"_popular_sort":["field_6172496402af3"],"related_courses":[""],"_related_courses":["field_61c453ca6b2dd"],"reviews_heading":[""],"_reviews_heading":["field_64538c39ffdd7"],"review_rating":[""],"_review_rating":["field_62a813a92bee6"],"total_review_count":["1769"],"_total_review_count":["field_62b002d8d2de5"],"average_review_count":["4.6"],"_average_review_count":["field_62b00367d2de6"],"faq_heading":["FAQs for Migrating Teradata Users to BigQuery "],"_faq_heading":["field_64538c59ffdd8"],"educational_schema":[""],"_educational_schema":["field_652fbbf6f589a"],"curriculum":[""],"featured":[""],"views":["21"],"level":["beginner"],"current_students":["0"],"duration_info":["1 Day"],"video_duration":[""],"status":[""],"status_dates":[""],"not_single_sale":[""],"price":["57950"],"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\":\"Who is this course for?\",\"answer\":\"It is intended for customers migrating from Teradata to BigQuery. \"},{\"question\":\"Does this cover every migration use case?\",\"answer\":\"No, it provides a foundation but is not a replacement for detailed BigQuery technical documentation. \"},{\"question\":\"Are there practical exercises?\",\"answer\":\"Yes, there are 3 hands-on labs included.\u00a0\"},{\"question\":\"What products are covered?\",\"answer\":\"The primary focus is on BigQuery. \"}]"],"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":["57950"],"wpdocs-meta-gbp":["599"],"wpdocs-meta-rand":["13255"],"wpdocs-meta-aed":["2932"],"wpdocs-meta-usd":["799"],"offline_price":[""],"offline-bdt":[""],"offline-gbp":[""],"offline-rand":[""],"offline-aed":[""],"offline-usd":[""],"_yoast_wpseo_primary_stm_lms_course_taxonomy":["58"],"_yoast_wpseo_content_score":["90"],"_yoast_wpseo_estimated-reading-time-minutes":["1"],"after_completing_course_0_desciption":["Compare architecture and provisioning of resources in Teradata and BigQuery. "],"_after_completing_course_0_desciption":["field_6103ad2f9f5b2"],"after_completing_course_1_desciption":["Configure datasets and tables in BigQuery. "],"_after_completing_course_1_desciption":["field_6103ad2f9f5b2"],"after_completing_course_2_desciption":["Map and compare data types and optimize schemas from Teradata to BigQuery. "],"_after_completing_course_2_desciption":["field_6103ad2f9f5b2"],"after_completing_course_3_desciption":["Translate SQL dialects, including SELECT, DML, and DDL statements. "],"_after_completing_course_3_desciption":["field_6103ad2f9f5b2"],"key_features_0_lists":["Architecture<\/span><\/strong>\u00a0Analysis<\/strong>:<\/span><\/span>\u00a0Understand the separation of compute and storage and the concept of\u00a0<\/span>BigQuery<\/span>\u00a0Slots.\u00a0<\/span><\/span>"],"_key_features_0_lists":["field_6103ad559f5b3"],"key_features_1_lists":["Hands<\/span>-On Learning:<\/span><\/span><\/strong>\u00a0Includes 3 dedicated labs for provisioning resources, schema migration, and writing SQL.\u00a0<\/span><\/span>"],"_key_features_1_lists":["field_6103ad559f5b3"],"key_features_2_lists":["Comprehensive<\/span>\u00a0Mapping:<\/span><\/span><\/strong>\u00a0Detailed modules for data types, resource hierarchies, and schema optimization (partitioning and clustering).\u00a0<\/span><\/span>"],"_key_features_2_lists":["field_6103ad559f5b3"],"key_features_3_lists":["SQL<\/span>\u00a0Modernization:<\/span><\/span><\/strong>\u00a0Learn to write user-defined functions (UDFs) and procedures in\u00a0<\/span>BigQuery<\/span>\u00a0SQL.<\/span><\/span>"],"_key_features_3_lists":["field_6103ad559f5b3"],"key_features_4_lists":["Structured<\/span>\u00a0Modules:<\/span><\/span><\/strong>\u00a05 distinct modules covering the end-to-end conceptual migration path.\u00a0<\/span><\/span>"],"_key_features_4_lists":["field_6103ad559f5b3"],"who_should_attend_0_attend_lists":["Teradata Users: Individuals with experience using Teradata as a data warehouse for managing data and performing SQL analysis. "],"_who_should_attend_0_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_1_attend_lists":["Aspiring BigQuery Users: While basic experience with BigQuery is recommended, it is not a strict requirement for enrollment. "],"_who_should_attend_1_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_2_attend_lists":["Customers: The primary group intended for this training. "],"_who_should_attend_2_attend_lists":["field_6103adfb3f3e4"],"course_features_0_features_list_0_list":["Specialized GCP Focus<\/span><\/span><\/strong>:<\/strong>\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><\/strong>:\u202f<\/span><\/strong>CloudThat<\/span>\u00a0has a strong pool of industry-recognized trainers certified by GCP. These trainers bring real-world experience and practical insights into the\u00a0<\/span>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><\/strong>:\u202f<\/span><\/strong>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><\/strong>:<\/strong>\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><\/strong>:<\/strong>\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><\/strong>:<\/strong>\u202f<\/span>CloudThat<\/span>\u00a0often provides placement\u00a0<\/span>assistance<\/span>\u00a0and career support services. This includes resume building, interview preparation, and 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><\/strong>:\u202f<\/span><\/strong>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><\/strong>:<\/strong>\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":["Architectural Comparison<\/span><\/span>: Compare the high-level architecture and provisioning of resources between Teradata and\u00a0<\/span>BigQuery<\/span>.\u00a0<\/span><\/span>\u00a0<\/span>"],"_course_features_1_features_list_0_list":["field_644a0fc80e680"],"course_features_1_features_list_1_list":["BigQuery<\/span>\u00a0Slot Mechanics<\/span><\/span>: Describe the concept of a \"slot\" and its role in\u00a0<\/span>BigQuery<\/span>.<\/span><\/span>"],"_course_features_1_features_list_1_list":["field_644a0fc80e680"],"course_features_1_features_list_2_list":["Resource Management<\/span><\/span>: Understand the resource hierarchy within\u00a0<\/span>BigQuery<\/span>\u00a0and learn how to configure datasets and tables.<\/span><\/span>"],"_course_features_1_features_list_2_list":["field_644a0fc80e680"],"course_features_1_features_list_3_list":["Data Translation<\/span><\/span>: Map and compare Teradata data types to analogous types in\u00a0<\/span>BigQuery<\/span>, including identifying data types unique to\u00a0<\/span>BigQuery<\/span>.\u00a0<\/span><\/span>\u00a0<\/span>"],"_course_features_1_features_list_3_list":["field_644a0fc80e680"],"course_features_1_features_list_4_list":["Schema Optimization<\/span><\/span>: Define schemas in\u00a0<\/span>BigQuery<\/span>\u00a0and implement performance-enhancing features such as partitioning and clustering.\u00a0<\/span><\/span>\u00a0<\/span>"],"_course_features_1_features_list_4_list":["field_644a0fc80e680"],"course_features_1_features_list_5_list":["SQL Dialect Mastery<\/span><\/span>: Understand\u00a0<\/span>BigQuery<\/span>\u00a0SQL query capabilities and learn to translate SELECT, DML, and DDL statements from Teradata.\u00a0<\/span><\/span>\u00a0<\/span>"],"_course_features_1_features_list_5_list":["field_644a0fc80e680"],"course_features_1_features_list_6_list":["Programmable Logic<\/span><\/span>: Write user-defined functions (UDFs) and procedures using\u00a0<\/span>BigQuery<\/span>\u00a0SQL.<\/span><\/span>\u00a0<\/span>"],"_course_features_1_features_list_6_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":["Understanding BigQuery Architecture"],"_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":["Quick architectural reminder of Teradata's shared-nothing MPP architecture (BYNET, Access Module Processors (AMPs), and vprocs)"],"_course_section_0_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_1_lession_title":["High-level overview of BigQuery\u2019s cloud-native, serverless design"],"_course_section_0_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_2_lession_title":["Deep dive into the physical and logical separation of compute (Dremel execution engine) and storage (Colossus distributed filesystem)"],"_course_section_0_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_3_lession_title":["Understanding BigQuery Slots as units of computational capacity (CPU and RAM) "],"_course_section_0_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_4_lession_title":["Workload management strategies: On-demand vs. Capacity management slot allocation (Standard, Enterprise, Enterprise Plus tiers)"],"_course_section_0_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list":["5"],"_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":["Compare resource provisioning, concurrency management, and hardware scaling boundaries between Teradata's fixed-node capacity and BigQuery's elastic serverless pool "],"_course_section_0_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_1_lession_title":["Define the exact structural concept of a \"slot\" and evaluate strategies for allocating slot capacity to project workloads"],"_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":["Creating Datasets and Tables in BigQuery"],"_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":["Mapping corporate resource hierarchies: Teradata (System > Databases > Users\/Tables) to Google Cloud (Organization > Folders > Projects > Datasets > Tables)"],"_course_section_1_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_1_lession_title":["Provisioning dataset containers, configuring geographical locations (multi-region vs. single-region), and setting table expiration timelines"],"_course_section_1_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_2_lession_title":["Implementing access governance: Sharing datasets and resources using Cloud IAM roles, authorized views, and dataset-level permissions"],"_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":["Design a secure, multi-tenant enterprise data resource hierarchy optimized for Google Cloud architectures"],"_course_section_1_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_1_lession_title":["Create and configure target BigQuery datasets while applying strict identity governance rules"],"_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":["Provisioning and Managing Resources 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":["Mapping Data Types from Teradata to BigQuery"],"_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":["Systematic mapping of specific Teradata data types (e.g., BYTEINT, PERIOD, BYTE\/VARBYTE) to BigQuery equivalents"],"_course_section_2_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_1_lession_title":["Handling floating-point, variable-precision numbers, and strict boolean fields across systems"],"_course_section_2_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_2_lession_title":["Exploring data types unique to the BigQuery environment (e.g., GEOGRAPHY, BIGNUMERIC, and native structural JSON attributes)"],"_course_section_2_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_3_lession_title":["Managing structural casting anomalies and parsing semi-structured records cleanly"],"_course_section_2_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list":["4"],"_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":["Correlate structural Teradata schemas into fully compliant BigQuery table data types "],"_course_section_2_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list_1_lession_title":["Identify and utilize unique BigQuery-native data types to simplify layout complexities"],"_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"],"_course_section_2_section":["field_612f51e6b0277"],"course_section_3_module_title":["Schema Optimization and Mapping"],"_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":["Translating Teradata Primary Indexes (UPI and NUPI) into native BigQuery performance tuning mechanisms"],"_course_section_3_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_1_lession_title":["Implementing explicit data partitioning strategies (Time-unit, ingestion time, or integer range partitioning) "],"_course_section_3_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_2_lession_title":["Using multi-field table clustering to systematically sort, filter, and optimize high-volume data blocks "],"_course_section_3_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_3_lession_title":["Best practices for nested and repeated fields (STRUCTs and ARRAYs) to eliminate unnecessary JOIN performance overhead"],"_course_section_3_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list":["4"],"_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":["Define, construct, and implement optimal table layout configurations via partitioning and clustering"],"_course_section_3_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_1_lession_title":["Build highly performant target data structures that dramatically minimize bytes scanned and execution bills"],"_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":["Schema Migration to BigQuery"],"_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":["SQL Translation from Teradata to BigQuery"],"_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":["Translating structural Teradata SQL text dialects (BTEQ scripts, Teradata-specific extensions) into standard GoogleSQL compliance layers"],"_course_section_4_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_1_lession_title":["Mapping DDL (Data Definition Language) and DML (Data Manipulation Language) syntax variances (e.g., handling QUALIFY, SAMPLE, and explicit transaction modes)"],"_course_section_4_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_2_lession_title":["Rewriting complex analytic clauses, macro definitions, and system metrics queries"],"_course_section_4_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_3_lession_title":["Migrating programming modules: Porting Teradata User-Defined Functions (UDFs) and stored procedures into GoogleSQL equivalents"],"_course_section_4_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list":["4"],"_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":["Translate legacy SELECT, DDL, and DML syntax from Teradata code into valid GoogleSQL structures"],"_course_section_4_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_1_lesson_list_1_lession_title":["Rewrite custom business database logic blocks, macros, stored procedures, and programmatic functions safely inside BigQuery"],"_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":["Writing SQL for BigQuery"],"_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"],"_thumbnail_id":["28761"],"_wp_old_date":["2026-05-28"]},"acf":[],"_links":{"self":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/28857"}],"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":4,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/28857\/revisions"}],"predecessor-version":[{"id":28865,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/28857\/revisions\/28865"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media\/28761"}],"wp:attachment":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media?parent=28857"}],"wp:term":[{"taxonomy":"stm_lms_course_taxonomy","embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm_lms_course_taxonomy?post=28857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}