Practical SQL for Beginners Using Adventureworks Database Part 2 | DISTINCT and WHERE Command

SQL is one of the fastest-growing programming languages. It is widely used by Data Analyst, Data Scientist, Database Administrators, Backend Developers, etc..

As an aspiring Business Intelligence analyst and Data Analyst, you are often faced with data from different databases as against the conventional Excel files you learnt building visualization with.

You will need to demonstrate a very good knowledge of SQL as business questions will be answered not just through the drag and drops Power BI environment but by demonstrating an understanding which addresses where the data required to answer this question resides in the database, how to retrieve it, what format must it be to be fit for the analysis, etc..

This is why you need to learn Structured Query Language. Business questions beget Queries.

The SELECT Command is the most used of all SQL command, the next to this is the WHERE Command.
To answer business questions, you will have to write more than a SELECT statement. The WHERE command will help you to filter through the results of your query and apply your desire conditions.
In this video, the below query was written to understand how the ‘WHERE’ and ‘DISTINCT’ command works.

select * from HumanResources.Employee
where MaritalStatus = 'M'
and Gender = 'F'

select * from HumanResources.Employee
where VacationHours 'insert less than symbol' 30

[hassannittofornah]

I stumbled upon your SQL tutorials on YouTube, and I'm so glad I did! Your teaching style is exceptional, and you break down the topics into digestible chunks. You've helped me immensely in advancing my SQL skills. Kudos to you!

[victorbassey]

Awesome lectures in all the videos, please will appreciate any video done to explain Joins-Self with the HumanResources Schema (.Employee) OR Person.person Table?