Write database select queries

- [Instructor] The primary method of returning information … from a relational database … is with a sequel select statement. … The select statement is extremely flexible, … and it'll allow you to ask questions about the data, … and the DBMS will return answers … in the form of a data table. … In order to take a look at writing select statements, … we need to have some data saved into the tables. … On the screen, I have a script that I've written out … that'll populate a few records … into each of the two data tables … that we've been working with. … You can find a copy of this script … in the course exercise files. … Then you'll just copy the text out of that, … come over here and right-click on the Kineteco database … and say new query, and then paste the text in. … At the top, this script is first going to delete … any records that might be in the products … or the suppliers table, just to give us a fresh start. … Then it'll insert three records into the suppliers table, … and a whole bunch of records into the products table. …