In this video we’ll walk you though how to use the LIKE clause. We’ll show you how to you can perform
Many times in a relational database the information you want to show in your query is in more than one table. This
When working with NULL, you’ll often find yourself wanting to replace these “missing” values, with something else. Just use ISNULL to do
If you want to find duplicate rows in SQL, you can go two routes. The first is to use the GROUP BY
If you have ever have wanted to start learning SQL but didn’t know where to start because you were frustrated, then let
Hey, welcome back to another SQL Minute. Today we’re going to learn how to code like a boss by delving into formatting
In the 70-761 exam covers the SQL Server 2016. Since this exam covers the data query, most of the topics that are
This is the first in a series of articles on how to Get Started with Power BI. For those of you unaware,
A reader recently asked about a error converting data type error they received. Since this is a common issue, especially when numeric
In this video we’ll walk you though how to use the CHOOSE function with SELECT. You’ll see how the function works and
Over the years there I’ve seen students makes these common SQL mistakes. They are really easy to avoid, and once you know
In this video we’ll walk you through how to include a single quote in a SQL query; we’ll show how to escape
In this video we’ll walk you though how to use the IN operator with a Subquery; we’ll show you why you would
In this video we’ll walk you though how to use the SQL IN operator; we’ll show you why you would want to
In this video we’ll walk you though how to use the SQL BETWEEN operator; we’ll show you why you would want to
The running total in SQL can be calculated in several ways. This article will cover two methods: the Joins and the Window functions.
Studying and preparing for the 70-761 can be intimidating. There are many topics you need to cover, but with so little time.
In this puzzle, we are going to learn how to join dirty data using the SQL Server. There are many instances that
We are going to learn how to create a bar chart using SQL server in this puzzle. It can sometimes be fun
Select Top Rows In this video we’ll walk you though how to select top rows within a query. We’ll show you
When working with SQL dates, sometimes you need to calculate the end of the month. Months are tricky! Some are 28 days,
You can do this! Pass exam 70-461. It may seem intimidating, but you can pass Exam 70-461 Querying SQL Server. All it
In this article find out how to find duplicate values in a table or view using SQL. We’ll go step by step
You can learn to write SQL. It isn’t hard. Yes, there are many details to mind, but none of it is impossible.