From the course: Relational Databases Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create a database view
From the course: Relational Databases Essential Training
Create a database view
- [Instructor] Sequel select statements provide a very powerful way to interact with the data that's stored in a relational database, but they can get a little bit long when you're joining multiple tables together or have complex filtrating requirements specified in a where clause. Luckily relational database management systems allow you to save a query as something called a view. This query here at the top of the screen is the one that we finished the last movie with, and it pulls the product's name and price from the products table and matches it to the supplier name and phone number from the supplier's table. These are the results that returned from this query. Now let's suppose this detailed look at the product information is something that you need to access regularly. Rather than type out the select query every time, you can save it as a virtual table object in the database. To do that, place your cursor at the…
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.