课程: SQL for Testers

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Challenge: Database tests

Challenge: Database tests - SQL教程

课程: 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…

内容