004 - The WHERE Clause Part 1 - Learn SQL From No Programming Experience

In this video we cover what a WHERE clause is, a new programming concept (numbers vs non-numbers), and the Greater Than, Less Than, and Not ( ! ) Operators for numbers and non-numbers. ----=== 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:22 Title 00:30 Download and Run tblPerson / Download Comments 01:07 SELECT Statement 01:26 Comparing WHERE to Filter in a Spreadsheet App 02:18 Asking SQL for Data 03:04 Numbers and Non Numbers (Programming Concept) 03:52 Strings are Like a Character’s Voice in a Story 04:52 Think of WHERE as a Yes or No Question. 05:52 Comparisons (Less Than, Greater Than) with Numbers and Strings/Text 07:30 Comparing Two Columns 07:50 The Not Operator ( ! ) 08:59 Summary 09:30 Practice Problems Video Link in Description 10:17 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