Creating materialized views

- [Instructor] Now let's see how easily we can create … a materialized view. … I'm going to refresh the contents of the public schemas … so we have up to date information here. … And we will notice we have a materialized view section … but when I click on that there is nothing below that node … to display so let's create a materialized view. … We do that by entering the … command create materialize view. … And I'm going to call it mv_staff … and it's going to create the view as. … And now I specify a select statement. … So I'm going to select from the staff table … I'll select the last name, the department and the job title … for each employee and I want to include in this … materialized view a column from the company regions table … and we'll just pull in company regions. … And this will be from the staff table which I'll alias … with an s and I'm going to inner join … on the company regions table and I will alias that as cr. … And we are going to do the join on s or staff … region ID and we want that to be …