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
На этой странице сайта вы можете посмотреть видео онлайн How to Filter In SQL: A Simple SQL WHERE Clause Tutorial and SQL Queries for Beginners длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Analytic Moxie 24 Ноябрь 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 4 раз и оно понравилось 0 зрителям. Приятного просмотра!
