Query Filtering & Operator Precedence in SQL (Oracle SQL Certification) (Lesson 9)

This video is from the course "Complete Oracle SQL Certification Course"

➡️ Learn MORE:
=========================================
➡️ Job Ready Programmer Socials:
=========================================
➡️ Who this course is for:
- Anyone willing to get into the software development career
- Anyone willing to Master SQL and get a job as a well-paid Oracle SQL Developer
- Anyone willing to work hard in mastering the SQL language
- Anyone who is interested in passing the Oracle 1Z0-071 exam!

➡️ About the course:
- Get ready to acquire some seriously marketable programming skills!
- You can't consider yourself a complete end-to-end developer until you can code in SQL.
- Today, data has become the hottest topic in technology and a company's biggest asset is their data.
- All databases require the language SQL to store and retrieve data. Salaries for junior-level SQL Developers are upwards of $70,000 - $90,000 dollars a year!
- The great thing is, for this course, you do not need any prior experience in programming whatsoever.
- SQL is a different animal and we're going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you've completed the course (in 2 months), you can call yourself an Oracle SQL Master! Oracle is the most popular relational database in the world!
- This course will prepare you to be job-ready in just 1 month of study and practice.
- All exercises and solutions are in the lectures.
- In several lectures, I ask students to pause the video and complete the assignment before resuming to watch my solution.
- MAKE SURE YOU WORK OUT THE PROBLEMS ON YOUR OWN BEFORE MOVING ON TO MY SOLUTION!!
=========================================
#oracle #sql #dataanalysis #jobreadyprogrammer #databasedeveloper #softwaredeveloper #career #tableau #databases #database #webdeveloper #html #css #javascript #java #javabasics #javatutorial #javaprogramming #aws #admin #jobready #programmer

[niefrank]

Already got the answer in video, Great!

[angelnguyen]

I got the same result set by using this query - this is ok to satisfy your query requirements right?

SELECT * FROM EMP
WHERE COMM IS NULL
AND SAL BETWEEN 1101 AND 4999
AND SAL != 3000;

[niefrank]

What will be the query if the item (comm=0)'s salary is 900? It will still show on the result

[tyylyyp]

on 10:42 the results show the 2 analysts Scott and Ford with salaries equal to 3000$, how come?
if i run the following query i get the correct results:
select * from emp
where (comm is null or comm = 0)
and sal > 1100
and sal < 5000
and sal !=3000;

[djmostephens]

'NOT IN' Worked for me as well, does it mean <>, != and Not In. are the same thing?