SQL BETWEEN Operator in SQL WHERE Clause

SQL WHERE Clause BETWEEN Operator

What is the BETWEEN operator? The BETWEEN operator is a logical operator that allows you to search for data between two values. In previous lessons to find all rows in Production.Product where the ListPrice was between 100 and 200, we wrote the query: SELECT * FROM Production.Product WHERE ListPrice >= 100 AND ListPrice

SQL WHERE Clause IN Operator

SQL WHERE Clause IN Operator

What is the IN operator? The IN operator is a logical operator that can be used in the WHERE clause to filter based on a list of values. For example, using only the information learned in the previous lessons, if we wanted to return all rows in the Person.Person table where the FirstName is either […]

data visualization

Why You Need Data Visualization

A critical component of a successful business intelligence strategy involves the use and embrace of data visualization. As we shift our primary reporting tool from Excel to a true business intelligence solution, this will become less of a “want to have” and more of a “need to have”. What is Data Visualization? Data visualization is […]

SQL WHERE with NULL

Using the SQL WHERE Clause – Part 4

How I do use the SQL WHERE clause for NULL values? NULL is something you might see in the database quite a bit. NULL means there is no value. This is not a blank value – like a blank space – but truly nothing. This is a subtle but important difference. Those with some programming […]

SQL WHERE clause with dates

Using the SQL WHERE Clause – Part 3

How do I use the SQL WHERE clause with dates? Using the WHERE clause with dates is very similar to filtering text. Date values must be enclosed with the single apostrophe. To find all rows that have an OrderDate equal to July 15, 2005 in the Sales.SalesOrderHeader table, we use the query: SELECT * FROM […]

learn SQL

Why You Should Learn SQL

Everyone should learn SQL. While that seems like an incredibly bold statement, learning SQL can be one of the greatest career decisions you make. Between the potential salary, no longer relying on others to give you information, and being able to ask ANY question about your business, learning SQL enables you to do so much […]

SQL WHERE Clause with numbers

Using the SQL WHERE Clause – Part 2

How do I use the SQL WHERE clause with numbers? In the last section we talked about how to use the SQL WHERE clause to filter rows of data based on text criteria. Now, we will look at how to filter rows of data based on numbers. Remember, we are using the AdventureWorks sample database […]

SQL WHERE Clause with text

Using the SQL WHERE Clause – Part 1

How do I use the SQL WHERE clause with text? The SQL WHERE clause allows you to filter rows based on a criteria you define. This lesson will focus specifically on filtering rows based on text values. Were we to find all rows in the Person.Person table where the FirstName contains the word “Michael”, we […]

SQL SELECT DISTINCT

SQL SELECT DISTINCT Statements

What is SELECT DISTINCT and how do I use it? The previous lessons have discussed the basics of the SQL SELECT statement. There is an option that can be added to the SELECT statement to return a distinct list. For example, if I wanted to find the distinct list of all values in the Color […]

BI project fail cliff

Common Reasons BI Projects Fail

In our efforts to help organizations develop successful business intelligence and analytics strategies, we have identified some of the most common reasons BI projects fail. Regardless of the size and scale of your organization, these common BI project issues could cause your analytics solution to fall short of its full potential. Like the picture above, […]