From the course: Relational Databases Essential Training

Unlock the full course today

Join today to access over 24,100 courses taught by industry experts.

Write database select queries

Write database select queries

From the course: Relational Databases Essential Training

Start my 1-month free trial Buy for my team

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…

Contents