Master the SQL SELECT statement part 02: WHERE clause
This video is part of a multi-part series on mastering the SQL SELECT statement. The SELECT statement, the most often used SQL command, is easy to learn yet difficult to master. Follow along with me and level up your database query super powers!
This video covers the WHERE clause of the SELECT statement, specifically
Relational operators like =, and !=
Logical operators such as AND OR and NOT
checking for NULL
Using the set operator IN
Using BETWEEN for range checking
Pattern matching using LIKE
Understanding that WHERE happens before column projections.
The SQL code is available here: https://github.com/mafudge/learn-data...
If you need to setup your own database environment, check out learn-databases! The easy way to get going and follow along with these videos. • Learn Databases Walkthrough
This video is part of the textbook Applied Database Management https://applieddb.com
Here's the entire playlist: • Applied Database Management with SQL
