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
En esta página del sitio puede ver el video en línea How to Filter In SQL: A Simple SQL WHERE Clause Tutorial and SQL Queries for Beginners de Duración hora minuto segunda en buena calidad , que subió el usuario Analytic Moxie 24 noviembre 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 4 veces y le gustó 0 a los espectadores. Disfruta viendo!
