SQL for Beginners: Setup & T-SQL First Steps (Free)

In this video, I explain what SQL Server is, why it is widely used in industry, and the role it plays within modern applications and business systems.

After watching, you will understand how SQL Server stores, protects, and manages data, and why learning T-SQL develops transferable problem-solving and logical thinking skills beyond a single platform.

In this video, I explain the different SQL Server editions, why we use SQL Server Express in this course, and what a responsible learning environment looks like.

After watching, you will understand why Express is appropriate for local development, what assumptions this course makes about your setup, and why working in a controlled, non-production environment matters.

In this video, I explain the commercial relevance of SQL Server and T-SQL and where these skills commonly appear in real-world environments.

After watching, you will understand why learning SQL Server is a practical choice and how these capabilities apply across different technical roles.

In this video, I explain the system requirements and download choices you should understand before installing SQL Server Express.

After watching, you will know what prerequisites exist, why the official Microsoft source must be used, and what decisions you will make before beginning installation.

In this video, I introduce the SQL Server installation process and explain the installation path used in this course.

After watching, you will understand which installation option we follow, why the Basic installation is selected, and what details must be noted once setup completes.

In this video, I explain how we confirm that SQL Server is running correctly after installation.

After watching, you will understand which services must be present, which service is required for connectivity, and how to verify that your SQL Server instance is ready to be connected to.

In this video, I introduce the tools used to connect to SQL Server and write T-SQL, including the difference between full IDEs and focused SQL editors.

After watching, you will understand how these tools interact with the SQL Server engine and why the choice of tool affects workflow, not database behaviour.

In this video, we download and install SQL Server Management Studio (SSMS) and use it to connect to a SQL Server Express instance.

After watching, you will be able to install SSMS correctly, establish a successful connection to SQL Server, and confirm that your management tool is communicating with the database engine.

In this video, we install Visual Studio Code, configure the Microsoft SQL Server extension, and create a working connection to a local SQL Server Express instance.

After watching, you will be able to connect to SQL Server from Visual Studio Code, execute queries, and use it as an alternative SQL editing tool alongside SQL Server Management Studio.

In this video, I explain the difference between standard SQL and Microsoft’s T-SQL implementation, and how they relate within SQL Server.

After watching, you will understand what SQL provides as a cross-platform standard, what T-SQL adds within SQL Server, and why both concepts matter when working with relational databases.

n this video, we execute a final environment validation script that creates a test database, builds tables, inserts sample data, and runs basic SELECT queries.

After watching, you will be able to confirm that SQL Server is installed correctly, the database engine accepts T-SQL commands, tables can be created and populated, and queries execute successfully without errors.

A brief outline of where to go from here and how this setup supports your next steps in learning SQL and T-SQL.

Information on how to follow future SQL Server and T-SQL content as it’s released.