From Excel to SQL - Getting Data (SELECT and FROM)
One of the hardest parts about getting started with SQL is knowing where to write SQL and how to actually look at some data! We cover:
A website that you can use to run SQL that comes with sample data
How to write some SQL to generate some data
How to find the list of tables (and their columns) in the database
The dbfiddle website can be accessed for free and without an account at:
https://dbfiddle.uk/
Make sure to use the SQL Server dialect and the AdventureWorks sample database to be able to follow along with these examples!
---------------------------------------------------
This is part of the From Excel to SQL playlist, available at:
• From Excel to SQL
Check out the previous video at:
• From Excel to SQL - Introduction and setti...
...and the next video at:
• From Excel to SQL - Filtering Data (WHERE)
The written version of this content is also available at:
https://billwallis.github.io/sql-lear...
---------------------------------------------------
CHAPTERS
00:00 Intro
01:02 dbfiddle
02:34 Opening files with Excel
04:51 SELECT and FROM
09:52 SELECT *
11:41 Column order in SELECT
12:36 SELECT is like English
14:06 Alias/rename columns
15:35 (Optional) SELECT without FROM
16:46 (Optional) Information schema
20:43 Wrap up