SQL Basics Tutorial For Beginners | Where Statement | 3/4

Learn how to use the Where Statement to filter your data down. In the next video we will be going over the Group by and Order by Statements.

____________________________________________

LINKS:

SQL Server Management Studio:

SQL Server:

Github Scripts:

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

Websites:

____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[armawlavizada]

I love how bite size these videos are. Not overwhelming at all. Thanks man.. you really are putting my anxiety at ease!!

[AlexTheAnalyst]

Timestamps:
Where Statement - 0:15
Equals - 0:31
Does not Equal - 0:40
Greater/Less Than - 0:57
AND - 1:45
OR - 2:14
Like - 2:50
NULL/NOT NULL - 5:17
IN - 6:30

[sarahweatherbee]

These tutorial videos are so clear. You have a talent for teaching – thank you, Alex The Analyst!

[aprilgodfrey]

These tutorials are amazing! I just started by DBMS course, and I have zero SQL experience. Keep educating!

[artofzenph]

I just started my SQL journey with your videos Alex. You're an inspiration to me to change my career to being a DA soon. Hope this works out 😖🙏

[ephraimlett]

I thought I would not be able to find a mentor in this industry but I was proved wrong. You man are blessed and a blessing. Sincerest thanks from myself and my family for the ability for me to do a career change.

[lucasivanmuller]

Great video! One thing to note, the IN statement isn't equivalent to Name = 'Jim' AND Name = 'Kevin'. It's equivalent to the OR (Name = 'Jim' OR Name = 'Kevin').

Nice job.

[damienium]

I was recommended your channel by a data analyst on tiktok. These videos are incredible easy to follow and, as somebody that is working on changing career paths, they give me hope. Thank you so much for making this playlist!

[wildbouquet]

Learning more from these tutorials than I have in 3 separate courses😂👌🏻 Thank you Alex!!!

[Marco]

And this is why I'm doing this boot camp first and then doing the Coursea Google Data Analytics cert.

[wfphhii]

Forgive me for being pedantic, but I think you made a small mistake at 6:54

When trying it out at my end i found 'OR' to return both JIm and Michael's entries.

WHERE FirstName = 'Jim' AND FirstName = 'Michael' -> returns nothing.

[kevalpatel]

Dear Alex,

I followed your video from last week. Learning from you. It’s been really helpful till now. But I have something to tell you. I know its bit funny, but in this video 6:56 min, you are using wrong command. 😀
I tried to execute with AND Command but it suppose to be OR command(while explaining IN command)

Bdw your videos are really helpful. Keep doing it. 😊👍🏻

[danw]

Took me a few minutes to figure out that you were highlighting/selecting only the select & from statement and not including where. Knowing this selection option before running a query would have been very helpful in not getting an error every time I tried to run the query. Might I suggest your "Bootcamp" include in the beginning, an understanding of the structure and how SQL and the SQL interface works vs. jumping into commands and queries.

[jeremyanderson]

Very helpful, thank you! Just glanced ahead at your intermediate and advanced playlists, that looks incredibly helpful.

[shnftph]

I just realized that the names are from the cast of the office! Great easter egg, Alex 😂

[Tuuuuusssjjjjjjnrnfnnfnfn]

Now i just love playing with SQL!!❤
Alex u r great❤

[waynerobins]

Starting my bootcamp journey today. So far really enjoying the videos, simple and easy to follow - thanks Alex!

[ClickAsh-scoj]

Great video, i have wasted my time looking for a tutorial for long but this one is so clear to understand and the bite size videos helps to refresh and digest the topics easily!! Thanks Alex

[sheyvitalismbunkur]

Hello Alex. You are a great teacher. Your simplified the tutorials

[savaramyasasvi]

Finally🎉 I found the right channel for data analytics.
Thanks Alex for your valuable information and time