What is SQL?
What is SQL? What is the difference between SQL the language and SQL the server?
Writing SQL
Writing a SELECT statement
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
Columns and Records
In this post, we discuss what columns and records are in a SQL table including an explanation of objects and entities.
Sort Records using ORDER BY
How to use the ORDER BY statement to sort records in a T-SQL statement in both ascending and descending order.
Filtering Records by NULL Values
How to use the WHERE statement to filter records when a value IS NULL or IS NOT NULL in a T-SQL statement.
Filtering Records by Numbers
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.
Filtering Records by Dates and Times
How to use the WHERE statement to filter records when the value is either a Date or a Time in a T-SQL statement.
Filtering Records by Character Data
How to use the WHERE statement to filter records when the value is a character data type in a T-SQL statement.
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.
Using Aggregate Functions
How to use the COUNT, MAX, AVG, and SUM Aggregate Functions in a T-SQL statement.