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: - https://www.youtube.com/playlist?list=PLEiRgvTilK5rhnVPQ_Tj3Q-CI0rGn_uiD Check out the previous video at: - https://youtu.be/ICJ7Mq3h7Ps ...and the next video at: - https://youtu.be/g_5OxUYPx7E The written version of this content is also available at: - https://billwallis.github.io/sql-learning-materials/from-excel-to-sql/main-concepts/select-and-from/ --------------------------------------------------- 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