1. Aprende
    2. /
  2. Cursos
    3. /
  3. Introduction to BigQuery
  • 1

    BigQuery Architecture and Structure

    Gratuito

    In this chapter, you will learn about the unique features of BigQuery, how it runs large analytical queries, and how it compares to other data warehouses and databases.

  • 2

    Writing queries and data types

    This chapter will cover the fundamentals of how to write queries in BigQuery while also providing a review of SQL concepts. You will also learn how to ingest bulk data into BigQuery and the different data types within BigQuery.

  • 3

    Querying data in BigQuery

    Learn how to query data using common table expressions, aggregations, and window functions.

  • 4

    Data management and optimization

    Understand all join types in BigQuery, mange data with data manipulation, and optimize your queries.

Initializing

Ejercicio

Using multiple CTEs

Using multiple CTEs can greatly improve the performance and legibility of code. In this example, you will split a query into two CTEs to make it easier to read and more performant.

Instrucciones 1/2

undefined XP
    1
    2
  • Create a new CTE named orders that will extract the order_id column along with the product_id and price from the nested order_items column, all from the ecommerce.ecomm_orders table.
  • Filter for price greater than 100.