T-SQL Basics

A Blog for the Junior DBA

About this blogsite

If you’re new to the DBA world and have no idea where to start, then you have landed in the right place.

This blogsite is dedicated to the new (junior) DBA that has no clue what they are doing or how to do it. Here, we break it all down into simple steps and explain the terminology in a way that almost anyone can understand and relate to. If you feel like you don’t quite understand something, or something is not clicking with you, feel free to email me at aubreywlove@tsqlbasics.com and I will try to help you through the confusion.

The best way to navigate this site is start with the first article in the "Featured Tutorials" below and walk through them one at a time in the order they are posted. Once you have completed these first 6 Tutorials, click on the "All Post" item in the menu and continue working through the rest of the tutorials.
I will try my best to make sure that they are listed in the order that you need to learn them.

If you are a "hard copy" type of person, not to worry, I have a paperback version of this blog that will be available on Amazon soon. So check back often for the link to purchase the book.
Bonus: the book will also have a question and answer section. This will give you an oppertunity to practice what you have learned using real world problems and scenarios.

Thank you for viewing my blog and I hope you have learned something.

Note: This site is a work in progress and not all articles are posted yet. Please check back often for new updates and articles.

Thank You.

Installing SQL Server

Using SQL Server 2019 Developer

In this article, we discuss how to install SQL Server 2019 Developer edition on your local computer. The developer edition is a free version that has all the capabailities of a full (paid for version) with some size limitations. However, for our training sessions that follow, the limitations will not be a detering factor.

Installing SQL Server Management Studio

(SSMS) ver.18

In this tutorial, we discuss how to install SQL Server Management Studio (SSMS) on your local computer. This is a desired tool although not a neccessary one. You can run SQL Server directly through the Windows command prompt or PowerShell, more on that later in this series.

Understanding Relational Database Mangaement System (RDBMS)

This tutorial will introduce you the basic concepts of what a Relational Database Management System (RDBMS) is and how it could benefit you. We will also cover Set Theory, the cornerstone of RDBMS.

Creating Tables (Option 1)


In this tutorial, we discuss how to create tables using the SSMS built-in GUI.
While this option is not commonly used in the real world, it's a great way to start learning about table creation from a visual point of view.
You really need to read this tutorial so that you can become familiar with the process should you ever need it.

Creating Tables (Option 2)

Using T-SQL

In this SQL tutorial, we will look at the most common and simplest task of a new DBA; creating your first database table. We will look at some do’s and don’ts while creating a simple table as well as adding constraints and schemas. We will also explain the steps that are required in the create table operation, what each step does and some pitfalls to avoid.

Understanding Data Types

This tutorial defines the basic and most commonly used data types that all junior DBA's should know.

Want to start your own blog or maybe
dip your toes into the world of writting?

Click on the following links.

HubSpot Website Design Services

Follow me on MSSQLTIPS.com