From the course: Database Foundations: Database Management
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Create a view
From the course: Database Foundations: Database Management
Challenge: Create a view
(upbeat music) - [Instructor] Views are an important object used in the management of your database, but they're really just queries that are saved to the system. If you can write a query, then it's a fairly straightforward process to convert it into a view. So any exercises that test your ability to create a view is really a query exercise in disguise with one added step. With that said, I do want to challenge you to create a couple of useful views for the Two Trees database that'll make exploring the data that it contains a little bit easier. The first one should be an aggregate view that displays the number of orders placed by each company. The second view needs to display a calculation that will multiply the quantity of a product ordered by its price for each order line. This challenge should take about 10 minutes or less to complete. In the next movie, I'll show you the steps that I take to create both of these views in the database. Good luck.
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.