How To Use SQL Archives

This archive contains slew of posts on how to use SQL to solve problem.  If you have a question about a particular issue, or technique, you may find a solution here.

For instance, here is one of our more “fun” article on how to use SQL to create a bar chart:  How to Create A Bar Chart Using SQL Server

If you’re studying for the 70-761 Querying Microsoft SQL Server certification, these two articles are a must read:

All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters.  You can get started using these free tools using my guide Getting Started Using SQL Server


5 Typical SQL Syntax Mistakes

For a beginner, learning any kind of programming language can be challenging and can cause you to make mistakes quite often. However, this is how we learn. Learning SQL syntax programming involves the same concept. After a while, you will start to see common patterns in those mistakes, and you will learn more as we […]

Continue reading

70-761 Certification and Study Guide

70-461 Exam Preparation

Recently Microsoft released “Exam 70-761: Querying Data with Transact-SQL – Microsoft.”  To help you study for this certification, I put together my 70-761 study guide. This guide is an update from the prior, which covered the 70-461 certification. The study guide includes every topic you should study to pass the 70-761.  The guide is also […]

Continue reading

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

Combine data in SQL

Many times in a relational database the information you want to show in your query is in more than one table.  This begs the question “How do you combine results from more than one table?” All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can […]

Continue reading