003 - The SELECT Statement - Learn SQL From No Programming Experience
In this video, we will be looking at the similarities between writing a sentence and a SELECT statement. The SELECT FROM WHERE statement is one of the most important queries you will learn. It is the base for almost every query you will write, so it is very important that you master this query. ----=== Important links for this video ===---- DataSet - http://elricsims.com/youtube_downloads/LearnSQL/tblPerson_with_data.sql Practice Exercise - https://youtu.be/vD5Jx8VWDYM ----=== Table of Contents ===---- 00:00 Introduction 00:23 Title 00:30 Download and Run tblPerson 01:14 Script Table as SELECT 01:58 Learn to Comment Code 03:26 The SELECT Statement 03:35 How SELECT Relates to a Sentence (List\Series) 05:26 Column Order \ Format 06:32 SELECT * (Select Star) 08:08 Summary 08:32 End Title ---=== Support Me ===--- Patreon: https://www.patreon.com/elricsims Ko-Fi: https://ko-fi.com/elricsims ---=== SQL Plugins (I get paid commission these) ===--- SQL Complete Affiliate Link: https://secure.2checkout.com/order/cart.php?PRODS=5023603&QTY=1&AFFILIATE=114121&__c=1
Download
0 formatsNo download links available.