Writing SQL

Columns and Records

In this post, we discuss what columns and records are in a SQL table including an explanation of objects and entities.

What is a Function?

What is a SQL Function and how to use a function in a T-SQL statement? We use the GetDate() and LEFT() functions as examples.


In this post, we discuss how to use the GROUP BY and HAVING clause in a T-SQL statement and how to use them with aggregate functions.

Tables and Relationships

Understanding the difference between Parent Tables and Child Tables and the difference between Primary Keys vs Foreign Keys.

Selecting From Multiple Tables

How to write T-SQL SELECT statements using multiple tables and what are the differences between using Inner Joins, Left Outer Joins, Right Outer Joins, and Full Outer Joins.