From the course: Relational Databases Essential Training
Join today to access over 23,400 courses taught by industry experts.
Write database select queries
From the course: Relational Databases Essential Training
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…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.