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
In questa pagina del sito puoi guardare il video online How to Filter In SQL: A Simple SQL WHERE Clause Tutorial and SQL Queries for Beginners della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Analytic Moxie 24 novembre 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 4 volte e gli è piaciuto 0 spettatori. Buona visione!
