T-SQL Fundamentals 3 – Aggregate Functions and the GROUP BY Clause

In the previous post, I covered how to filter the results of a SELECT statement using the WHERE clause. Now I will go over one of the most basic ways that you can use T-SQL to derive information from a data set – aggregate functions and the GROUP BY clause. The Northwind sample database willContinue reading “T-SQL Fundamentals 3 – Aggregate Functions and the GROUP BY Clause”

T-SQL Fundamentals 2 – The WHERE Clause

In the previous post, I introduced the SELECT statement and demonstrated how to use it to pull data from the database. Now that we are comfortable with the basic usage, let’s build on our knowledge by adding a WHERE clause. If you are unfamiliar with boolean algebra, it is strongly recommended that you read thisContinue reading “T-SQL Fundamentals 2 – The WHERE Clause”

T-SQL Fundamentals 1 – The Select Statement

In the previous post, we installed SSMS and discussed some of the things that SQL can do. Let’s jump straight into writing our first query. Right-click on the Northwind database in the Object Explorer and click on New Query. This will open a blank query window for you to type your code into. The SELECTContinue reading “T-SQL Fundamentals 1 – The Select Statement”

Getting Started With SQL Server

What Is SQL Server? One of the things that was confusing for me when I was first starting to work with databases was what the difference was between SQL Server, MySQL, T-SQL, PostgreSQL, PL/SQL, SQL, Oracle Database, and more. What language should I start with first? What is the difference between them? What will helpContinue reading “Getting Started With SQL Server”