From the course: SQL for Testers
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Getting started with SQL queries - SQL Tutorial
From the course: SQL for Testers
Getting started with SQL queries
- [Instructor] In the last video I had you type in and execute a query. You might not have understood exactly what this query is all doing, but now we're going to dive into this and understand what's actually going on. So the query we have here is pretty simple. We just wrote select star from fake car data. Now, let's just walk through this one step at a time. So first we have this select statement, which well, it selects data, and then we have the star here. So the asterisk or star is a wild card character. It essentially means give back data from all the columns in this table. So we could change this to be a column name, and then we'd only get data from that column. So for example, we could put last_name as the name of this column. We get back a table with only that one column, only the last name column in it. I'll just change this back to star for now, consider. So we'll send that query off and you can see that the response we get back only has the rows where the vehicle make is…
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.