How to Filter In SQL: A Simple SQL WHERE Clause Tutorial and SQL Queries for Beginners
In this video, we talk through how to filter in SQL. We do this using the SQL WHERE clause and learning how to construct conditions for filtering. This is a tutorial intended for beginners and as a refresher for those seasoned SQL users.
If you’d like to continue learning SQL beyond this video, a link to our Data Analysis Using SQL playlist is here: • Data Analysis Using SQL: SQL Tutorials for...
We are continuing to build that playlist, so please subscribe to the channel so that you can be informed of future SQL query videos.
This tutorial uses the Sakila database. A tutorial for loading the database is here: • How To Install the Sakila Database Using a...
The ER Diagram for the database is here: https://www.jooq.org/sakila
Finally, to cite our sources, we are using the book Learning SQL as our primary reference. This is a great book that introduces a variety of SQL querying topics and that provides exercises and solutions for practice which can be purchased on Amazon here: https://amzn.to/3DNY1Gd (I may receive a commission for a purchase at no additional cost to you).
Chapters:
00:00 - Introduction
00:48 - Sakila ER Diagram
01:08 - Basic SELECT Queries
02:10 - WHERE Clause - Introduction and General Form
03:10 - WHERE Clause with More than one Condition (AND, OR)
05:46 - Using Parentheses to Explicitly Indicate Order of Execution
06:51 - Using NOT in WHERE Condition
07:57 - Challenge Problem
On this page of the site you can watch the video online How to Filter In SQL: A Simple SQL WHERE Clause Tutorial and SQL Queries for Beginners with a duration of hours minute second in good quality, which was uploaded by the user Analytic Moxie 24 November 2021, share the link with friends and acquaintances, this video has already been watched 4 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
