From the course: SQL for Testers
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Database tests - SQL Tutorial
From the course: SQL for Testers
Challenge: Database tests
(electronic music) - [Instructor] This course is coming to an end and as I wrap up, I want to give you the chance to pull everything together in a final challenge. This challenge will push you to put into practice many of the things that you've been learning about testing databases and testing with databases. In order to push you a little, I've actually created a new database for this challenge. To use that database, we'll need to disconnect from the e-commerce one that we have and then we can add a database. So we'll go here. In the exercise files for this, you should find a database called challenge.db. Open that database and connect to it. So right click on it and connect to it. You can see the tables that it has here. This instead of an e-commerce system is modeling a school system. Very basic, obviously. But we've got a classes table, which defines what classes are available, the names of the classes that are available. Then we have a users table which defines some information…
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.