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
Duplicate Rows in SQL – Find 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