logo-mooc
search-iconsearch-icon
menu-whitemenu-blue
GRATIS
Inicio / Buscador / Programación / Bases de Datos
Google Cloud vía Coursera
GRATIS

Achieving Advanced Insights with BigQuery

  • money

    Cursos gratis (Auditar)

    question-mark
  • earth

    Inglés

  • folder

    NaN

  • certificate

    Guía de Registro en Coursera

    arrow
VER CURSO arrow
Acerca de este curso

  • Introduction
    • Overview of what you will learn in this course
  • Advanced Functions and Clauses
    • Deepen your knowledge of SQL on BigQuery by learning about more advanced functions like statistical approximations, analytical window queries, user-defined functions, and WITH clauses.
  • Schema Design and Nested Data Structures
    • Walkthrough the evolution of how traditional databases handle dataset scale and compare how BigQuery was developed to address scaling limitations. Deep dive into nested and repeated fields which are a key part of denormalized BigQuery data structures.
  • Optimizing for Performance
    • Learn the fundamental pieces of work that impact BigQuery performance and how to optimize your queries for speed.
  • Advanced Insights with Vertex AI Workbench
    • Introducing Vertex AI Workbench -- a key tool in the Data Scientist toolkit -- which enables analysts to collaborate through the use of scalable cloud notebooks.
  • Data Access
    • Securing and sharing your BigQuery datasets is critical for any organization. Learn what Google Cloud and BigQuery tools are available to you to permission control and share your data.
  • Summary
    • Summary of the course ley learning points