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.

Setting up a site for testing

Setting up a site for testing - SQL Tutorial

From the course: SQL for Testers

Start my 1-month free trial

Setting up a site for testing

- [Instructor] Now that we have the basics of SQL under our belt, let's take a look at how to use these SQL queries as a tester. I firmly believe that you will learn best if you can actually execute queries on your own and have a hands-on experience throughout this course. So in order to do this, you're going to need to set up some databases locally, but I don't want this to just be about querying databases, as testers, we need to look at things in a holistic way. So database by itself, well, that's interesting, but whenever we look at a database in our application, it's part of an entire ecosystem, right? So the database, it provides data that's ultimately used by a client or a user interface in some way. So in order to replicate this, I put together a simple website that's got a few database tables for various parts of the data and a simple user interface on top of that that uses some of that data from the databases.…

Contents