From the course: SQL for Testers
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Solution: Database tests - SQL Tutorial
From the course: SQL for Testers
Solution: Database tests
(upbeat music) - [Instructor] So in the last video, I challenged you to try out your skills on a new database. We've got this database modeling school and I gave you a bunch of challenges to do. Hopefully you were able to figure them out on your own, but in this video, I'm going to walk you through the solutions that I've done. The first thing was to draw out the schema for this database. Well, here is a picture that shows what I did for that. The interesting thing about this is to see that everything goes through this enrollments table. This enrollments table is linked to all the other tables. And so this table is going to be pretty key to any queries that we need to do. The next challenge was to find the names of the students that are enrolled in the math class. So, in order to do this, we're first going to need to know the code for the math class. So, let's just select everything from the classes table to see what we…
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.