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”

Introduction to Boolean Algebra 1

Boolean algebra is a way of describing logic in a mathematical way. In boolean algebra you work with two states – true and false – rather than numbers. 1 is used to denote true and 0 is used to denote false. The three most basic operations in boolean algebra are and, or, and not. TheseContinue reading “Introduction to Boolean Algebra 1”

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”

CrackMe – Baby Ransom

This cracking challenge was posted by Shad3 on crackmes.one. This basic challenge is to write a program that is capable of decrypting a file that has been encrypted by the covid-19.bin executable. The first thing that I did after unpacking the zip file was check what files were included in this program. There is justContinue reading “CrackMe – Baby Ransom”