From the course: Advanced SQL for Query Tuning and Performance Optimization

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Challenge: Creating a materialized view

Challenge: Creating a materialized view - SQL Tutorial

From the course: Advanced SQL for Query Tuning and Performance Optimization

Start my 1-month free trial Buy for my team

Challenge: Creating a materialized view

“

(upbeat music) - [Instructor] In this challenge, we're going to create a materialized view. Let's imagine that we are working with a table called sensor_metrics, which has a sensor_id, a measure_date, temperature, humidity, and pressure. We want to create a materialized view on the sensor_metric table. Now, the materialized view should contain only rows where the sensor ID is greater than 90000. And the name of the materialized view should be mv_sensor_metric. What statement would you use to create that materialized view?

Contents