006 - The WHERE Clause (Dates) Part 3 - Learn SQL From No Programming Experience

In this video, we will be working with a new type of data; Dates. Dates are a very unique piece of data, so we will quickly covering our previously learned comparison operators and looking at how SQL will work with us... and against us... when using Dates. ----=== Important links for this video ===---- DataSet - http://elricsims.com/youtube_downloads/LearnSQL/tblOrders_with_data.sql Practice Exercise - https://youtu.be/qUJC5YZoU0Y DATEPART documentation - https://docs.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql?view=sql-server-ver15 ----=== Table of Contents ===---- 00:00 Introduction 00:31 Title 00:39 Download and Run tblOrders (New Table) 00:39 Summary 01:31 The Comparators We will be Using (IN, LIKE, BETWEEN, Greater Than, Less Than) 02:02 New Type of Data (DateTime2) 02:45 Dates and String Format Using ( = , Less Than, Greater Than) 03:40 Using BETWEEN with Dates 04:43 Using IN with Dates 04:49 Using LIKE with Dates (Strict Format) 06:35 Approaching Date Comparisons Differently (Instead of actual Dates) 07:08 DATEPART() Function. 07:20 Programming Concept - Native SQL Functions 07:36 DATEPART() Arguments 08:40 Using DATEPART to find Orders Created in August of 2020 09:30 Summary 09:34 Get Ready for GROUP BY ! 10:32 Practice Problems in the Description 10:54 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