From the course: Database Foundations: Database Management
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Views and database maintenance
From the course: Database Foundations: Database Management
Views and database maintenance
- [Instructor] When you create a view object, the views definition binds it to the names of your data tables and columns. Depending on your RDBMS platform this can have consequences for changes that you might want to make to your database's design down the road. For instance, special care will need to be taken if you want to rename a column after you've created views that include it. Let's take a look at the two trees database in the PostgresSQL instance where we previously created a view called sales.order details. First, I want to select a couple of columns from this view. So I'm going to right click on this database and choose new query, then we can do a select statement. We'll select the order ID, order date and company columns from that view. Now this view is piecing together data from two different data tables here. The company names are coming from these sales.customer's table and the order ID and dates are coming from the sales.orders table. But since we are querying a view…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.