Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

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

Name: SQL for Beginners: SQL & T-SQL Fundamentals (Free)
Rating: 4.8 (5 reviews)

Understand key SQL concepts and execute your first T-SQL statements in SQL Server 2025 | Part 2 of 4

New

Created byGennaro Borrelli

Last updated 4/2026

English

What you'll learn

Be introduced to what SQL is and how it is used to interact with relational databases
Recognise the structure of simple SQL statements through guided examples
Execute simple T-SQL statements in SQL Server and observe their output
Work with basic expressions and operators using numbers and text
Use PRINT and comments to display output and annotate SQL scripts
Understand at a high level how SQL Server uses T-SQL to execute statements

Course content

6 sections • 24 lectures • 1h 8m total length

Course Series Purpose0:49
Explains the purpose of the SQL beginner series, how it is structured, and the approach used to build understanding through practical execution.
This Course: SQL & T-SQL Fundamentals0:26
Introduces this course, its focus on SQL fundamentals, and how it prepares you for the next stages of the series through initial concepts and practical examples.
Who This Course Is For1:06
Outlines the intended audience for this course and helps you determine if the content is suitable for your current level and goals.
Course Series Overview (Courses 1 - 5) (Article)1:26
Provides an overview of the full course series, including the structure, sequence, and topics covered across each stage.
Course Requirements1:30
Describes the software, tools, and basic setup required to follow along with the course and complete the exercises.
Course Series Curriculum & Scope0:36
Explains what is covered across the full series, how topics are structured, and which areas are intentionally excluded to maintain focus.
How to Get Help and Support0:44
Explains how to get help during the course, including how to use the Q&A section and how to provide clear information when asking questions.

SQL Overview14:04
Provides an overview of SQL, explaining what it is and how it is used to work with data in relational databases.
What Does SQL Look Like?5:51
Demonstrates example SQL statements to show how queries and commands are written. Focuses on the structure and readability of SQL rather than detailed execution.
Why Learn SQL?1:53
Explains the value of learning SQL, including how it supports data-related roles and why it remains a widely used and in-demand skill across industries.
Who Uses SQL?3:24
Explains the types of roles and industries where SQL is commonly used, and why it is a valuable skill across a wide range of technical and data-focused positions.

SQL & T-SQL Fundamentals Overview0:48
Introduces SQL, what it is, and how it is used to interact with relational databases. Covers its role as a standard language and how it fits within database systems.
Checking SQL Server Version (@@VERSION)3:08
Use @@VERSION to confirm your SQL Server instance and verify your environment before running further commands.
Using PRINT to Return Output5:52
Use PRINT to send simple messages to the output window and understand where results appear in SQL Server.
Using the + Operator with Numbers and Text14:30
See how the + operator behaves with numbers and with text, and how results differ based on the data type used.
Writing Comments in T-SQL9:39
Write single-line and multi-line comments to document scripts and temporarily disable code during development.

Exercises and Challenges Overview0:25
Introduces the exercises and challenges section and explains how to approach the tasks, use the downloadable files, and reinforce your understanding through practice.
Exercises and Challenges (Download)0:05
Download the exercises file and complete each task independently.
These exercises are based on the material covered in this course and are designed to reinforce your understanding through repetition and execution.
Answers and Solutions (Download)0:05
Download the answers and solutions file to validate your work.
Use this to compare your approach, review correct outputs, and identify any gaps in your understanding before continuing.

About the Instructor0:55
Provides background information about the instructor and the approach taken in designing and delivering this course.
Course Terms and Copyright0:11
Outlines the terms of use and copyright information for this course and its materials.
SQL Workshop Scripts (Download)0:07
Download the SQL scripts used across the workshop lectures in this course.
The scripts are grouped into a single file for simplicity. Each section is clearly labelled so you can follow along with the relevant lecture or revisit specific examples as needed.

Requirements

A computer capable of running SQL Server Express
SQL Server installed and running (from the setup course if following along)
Basic computer literacy (installing software and navigating folders)
No prior SQL or programming experience required

Description

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

Who this course is for:

Absolute beginners with no prior SQL experience
Learners who want a clear and practical introduction to SQL concepts
Students who have completed the setup course and want to begin using SQL Server
Anyone looking for a simple, structured starting point before learning database development and querying

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

What you'll learn

Explore related topics

Course content

Welcome & How to Use This Course7 lectures • 7min

SQL & T-SQL Fundamentals4 lectures • 25min

Working with T-SQL5 lectures • 34min

Exercises & Challenges3 lectures • 1min

Summary & Next Steps2 lectures • 1min

Reference Material3 lectures • 1min

Requirements

Description

Who this course is for: