SQL for Beginners: SQL & T-SQL Fundamentals (Free)

Course Introduction

Welcome to SQL for Beginners: SQL & T-SQL Fundamentals (Free).

This course introduces the key concepts of SQL through short, focused lectures, followed by simple, guided workshops where you begin typing and executing basic T-SQL statements yourself.

It is Part 2 of a 5-course beginner series and follows the setup course. You should already have a working SQL Server environment ready to use.

The focus of this course is clarity and first execution. You will not be learning SQL in depth or working on complex database problems. Instead, you will be introduced to how SQL works at a fundamental level and run controlled examples inside SQL Server to observe how it behaves.

You will learn what SQL is, how it is used to interact with relational databases, and how it differs from database-specific implementations such as T-SQL (at a high level). You will also see where SQL is used and why it is a standard language for working with data.

In the workshop sections, you will run practical T-SQL examples to validate and observe behaviour directly. These include:

• Checking your SQL Server version
• Returning output using PRINT
• Working with simple expressions
• Using the + operator with numbers and text
• Writing and using comments in T-SQL

These are small, controlled examples, designed to help you become comfortable writing and executing code, not to develop full SQL capability at this stage. The workshops in this course are intentionally repetitive, helping beginners build familiarity and reinforce key steps through repeated practice.

What This Course Is

• A clear introduction to SQL concepts
• A first step in writing and executing T-SQL statements
• A guided, practical entry point before moving into database development

What This Course Is Not

• Not a full SQL course
• Not focused on database design or data modelling
• Not focused on writing complex queries
• Not covering joins, relationships, or advanced SQL features

Outcome

By the end of this course, you will:

• Have a basic understanding of what SQL is and how it is used, introduced through structured slides

• Be able to execute simple T-SQL statements in SQL Server, using guided scripts with questions and small challenges

• Be comfortable working inside the SQL Server environment, using your preferred IDE (SSMS or Visual Studio Code)

• Be ready to move on to creating databases and working with data in the next course

Position in the Series

This course builds directly on the setup course and introduces concepts that are developed further in later courses, where you will begin working with:

• Creating databases and tables
• Inserting and modifying data
• Writing SELECT queries to retrieve data