SQL for Data Analytics · SELECT Statements
SELECT Statements
In these videos I write my queries in a program called MySQL Workbench, and sometimes I tell you to open it up and try something. You don't need Workbench for this unit. There's a query box right under each video, and you can use that.
SELECT Statements8 min
A note on this video
In the video I put USE northwind; at the top of the script. On this site every box already knows which database it's using, so you can leave that line out. If you type it anyway, it just gets ignored.
Run queries here while you watch. When I tell you in the video to open Workbench and try something, use this box. This is for your own practice. It isn't recorded or part of your unit submission.
⌘/Ctrl + Enter
This is for your own practice. It isn't recorded or part of your unit submission. Pick a table from the list and select a couple of its columns.
Select the product name and price from the products table.
⌘/Ctrl + Enter