Hello and welcome to Creating Database Structures: Working with Views. This course will introduce you to something new: views in SQL. What are they? When do you use them? How do you change them? That's what we'll discuss in this course.
This section will focus on creating views. Let's dive right in!
We work for a website that helps people compare doctors in various cities and makes it possible to schedule doctor appointments. There are three tables: doctor, patient, and visit.
To start, we need to select information related to a specific visit – i.e., doctor data, patient data, and visit data.
It's quite a long query to write, but today's your lucky day! We've prepared the query for you in the template code. Take a look at it and then run it.
