Problem You want to remove duplicates in SQL. You know it is easy to find duplicates using GROUP BY, but how do

Read More
Find and Remove Duplicates in SQL

Problem You need to find duplicates and then identify the records by their primary keys. Background Here’s an example of how to

Read More
How to Find Duplicates using a Windows Function?

In this article I’ll show you how to use STRING_SPLIT() to join two tables.  I call this the impossible join. I’ve come

Read More
How to do an Impossible Join with String Split

In this video we’ll walk you though how to use the LIKE clause.   We’ll show you how to you can perform

Read More
How do I use the Like Clause in SQL Server?

Many times in a relational database the information you want to show in your query is in more than one table.  This

Read More
How do I combine results from several SQL tables (hint: there are three ways)

When working with NULL, you’ll often find yourself wanting to replace these “missing” values, with something else. Just use ISNULL to do

Read More
Replace Missing Values in your Queries using ISNULL

If you want to find duplicate rows in SQL, you can go two routes. The first is to use the GROUP BY

Read More
How To Find Duplicates in SQL using Window Functions

If you have ever have wanted to start learning SQL but didn’t know where to start because you were frustrated, then let

Read More
Three Tips To Learn SQL Easily

Hey, welcome back to another SQL Minute. Today we’re going to learn how to code like a boss by delving into formatting

Read More
Automatically Format Your SQL

In the 70-761 exam covers the SQL Server 2016. Since this exam covers the data query, most of the topics that are

Read More
70-761 Exam: Newly Added Topics

This is the first in a series of articles on how to Get Started with Power BI.  For those of you unaware,

Read More
Get Started with Power BI

A reader recently asked about a error converting data type error they received.  Since this is a common issue, especially when numeric

Read More
How do I handle a “Error converting data type” error?

In this video we’ll walk you though how to use the CHOOSE function with SELECT. You’ll see how the function works and

Read More
How to use the Choose Function with Select

Over the years there I’ve seen students makes these common SQL mistakes.  They are really easy to avoid, and once you know

Read More
Avoid the 5 Most Common SQL Mistakes Beginners Make

In this video we’ll walk you through how to include a single quote in a SQL query; we’ll show how to escape

Read More
How to include a single quote in a SQL query

In this video we’ll walk you though how to use the IN operator with a Subquery; we’ll show you why you would

Read More
How to use the IN Operator with a SubQuery

In this video we’ll walk you though how to use the SQL IN operator; we’ll show you why you would want to

Read More
How to use the SQL IN Operator with an Expression List

In this video we’ll walk you though how to use the SQL BETWEEN operator; we’ll show you why you would want to

Read More
How to use the SQL BETWEEN operator

The running total in SQL can be calculated in several ways. This article will cover two methods:  the Joins and the Window functions.

Read More
Use SQL to Calculate a Running Total

Studying and preparing for the 70-761 can be intimidating. There are many topics you need to cover, but with so little time.

Read More
How to Create a 70-761 Study Plan Today!

In this puzzle, we are going to learn how to join dirty data using the SQL Server. There are many instances that

Read More
Learn how to Work Joins and Messy Data

We are going to learn how to create a bar chart using SQL server in this puzzle. It can sometimes be fun

Read More
How to Create A Bar Chart Using SQL Server

Select Top Rows In this video we’ll walk you though how to select top rows within a query.   We’ll show you

Read More
Select the Top Row from your result.

When working with SQL dates, sometimes you need to calculate the end of the month.  Months are tricky!  Some are 28 days,

Read More
Calculate the Last Day of the Month using SQL

You can do this!  Pass exam 70-461. It may seem intimidating, but you can pass Exam 70-461 Querying SQL Server.  All it

Read More
9 Best Tips for 70-461 Certification