Global Admissions Logo

$ USD

Search Programs

Optimizing Performance of LookML Queries

United States

The Non-degree in Optimizing Performance of LookML Queries at Google is a program for international students taught in English.

📖 Introduction

Google is a multinational technology company, founded in 1998 by Larry Page and Sergey Brin while they were PhD students at Stanford University. Initially focused on developing a powerful search engine, Google has since expanded its reach into various fields including advertising, cloud computing, artificial intelligence, and hardware. As a public company and a subsidiary of Alphabet Inc., Google is distinguished for its innovative products and services such as Google Search, Google Maps, YouTube, and Android. It is renowned for its mission to organize the world’s information and make it universally accessible and useful.

📚 About the Program

This is a Google Cloud Self-Paced Lab. In this lab, you'll learn the best methods to optimize query performance in Looker. Looker is a modern data platform in Google Cloud that you can use to analyze and visualize your data interactively. You can use Looker to do in-depth data analysis, integrate insights across different data sources, build actionable data-driven workflows, and create custom data applications. Big, complex queries can be costly, and running them repeatedly strains your database, thereby reducing performance. Ideally, you want to avoid re-running massive queries if nothing has changed, and instead, append new data to existing results to reduce repetitive requests. Although there are many ways to optimize performance of LookML queries, this lab focuses on the most commonly used methods to optimize query performance in Looker: persistent derived tables, aggregate awareness, and performantly joining views.

This is a Google Cloud Self-Paced Lab. In this lab, you'll learn the best methods to optimize query performance in Looker. Looker is a modern data platform in Google Cloud that you can use to analyze and visualize your data interactively. You can use Looker to do in-depth data analysis, integrate insights across different data sources, build actionable data-driven workflows, and create custom data applications. Big, complex queries can be costly, and running them repeatedly strains your database, thereby reducing performance. Ideally, you want to avoid re-running massive queries if nothing has changed, and instead, append new data to existing results to reduce repetitive requests. Although there are many ways to optimize performance of LookML queries, this lab focuses on the most commonly used methods to optimize query performance in Looker: persistent derived tables, aggregate awareness, and performantly joining views.

🏫 About the University

Google, established in 1998 by Larry Page and Sergey Brin, began as a research project aimed at improving internet search functionality. Today, it is one of the largest technology companies in the world, offering a wide range of digital products and services that have transformed industries like advertising, mobile operating systems, and cloud computing. Google is recognized for its commitment to innovation, user-focused design, and its impact on everyday life through products like Gmail, Google Chrome, and the Google Assistant. Known for its open, collaborative work culture, Google continues to lead the way in artificial intelligence, data science, and digital transformation.

💰 Fees

Application Fee

$0 USD

$0 USD

Tuition Fee

$49 USD

$49 USD

per year

✅ Entry Requirements

All students from all countries are eligible to apply to this program.

📬 Admissions Process


1

Step 1

Choose programs

2

Step 2

Apply online

3

Step 3

Enroll

📝 Reviews

Write a review

Application Fee

$0 USD

Service Fee

$0 USD

Tuition

49

Why Apply on Global Admissions?

Similar Programs to Non-degree

Similar Programs to Non-degree

Blog