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
Nesta página do site você pode assistir ao vídeo on-line How to Filter In SQL: A Simple SQL WHERE Clause Tutorial and SQL Queries for Beginners duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Analytic Moxie 24 Novembro 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 4 vezes e gostou 0 espectadores. Boa visualização!
