Udemy

Free SQL Server Setup Course: Run Your First T-SQL Query

Before you write a database query, you need somewhere to send it. A query editor can open perfectly while the database service is stopped or the connection points to the wrong instance. Learning to tell those situations apart saves time whenever you start a database project. It also makes your first successful query more useful: you know what ran it and where the data came from.

Free learning access

Listed as Free on Udemy when checked on 5 November 2026. No coupon or subscription trial is required for the listed lessons. Enrollment needs a Udemy account; availability can change.

About this course

Before you write a database query, you need somewhere to send it. A query editor can open perfectly while the database service is stopped or the connection points to the wrong instance. Learning to tell those situations apart saves time whenever you start a database project. It also makes your first successful query more useful: you know what ran it and where the data came from.

Gennaro Borrelli’s introductory course walks through a local SQL Server Express setup on Windows and ends with a small T-SQL validation exercise. The course uses SQL Server 2025. It assumes basic computer literacy and internet access for downloads, with no prior database or programming experience. Set aside time for the installation and for checking the results yourself.

Official course SQL for Beginners: Setup & T-SQL First Steps (Free)
Created by Gennaro Borrelli
Platform Udemy
Language English
Level Beginner
Listed duration 75 minutes; 15 lectures across 6 sections
Completion terms Not included with a new free enrollment

What you’ll learn

The first sections introduce the database engine and the Express edition. The installation lessons cover obtaining the installer from Microsoft, choosing the Basic setup, and checking the running instance. Next, the course uses SQL Server Management Studio and shows Visual Studio Code as an optional editor. The final video uses T-SQL to create a test database and tables, add sample rows and retrieve results.

Skills you’ll gain

  • SQL Server setup
  • Instance verification
  • Service inspection
  • SSMS connections
  • Sample data entry
  • Basic SELECT queries

Separate the engine from the editor

Think of the engine as the part that stores tables and runs queries. SQL Server Management Studio, often called SSMS, is the client you use to connect and issue those queries. If you install the editor first, opening it does not prove that the engine is installed. Keep a short note of the instance name shown during setup, then use it when connecting from the editor.

When a connection fails, start with the simplest checks. Confirm that you are on the machine where you installed the engine, that you chose the intended instance, and that the service is running. Read the actual connection error before changing any settings. Work in a personal or otherwise approved local practice environment; a connection problem in an employer’s database calls for that team’s procedures.

Build a small check you can explain

The validation lesson checks several things at once: the engine accepts commands, the database and tables exist, and the query returns the rows you expect. For extra practice, use a fictional reading list with a title and a status for each book. Write down the three rows you intend to insert. Run a SELECT against the practice table and compare the result with your notes.

If the editor shows rows you do not recognize, check the selected database and table before rerunning the setup. Then add a fourth fictional book and predict how the result will change. This simple exercise gives you a repeatable way to check that a working connection is also pointing at the place where you meant to work. Keep the test data separate from real information. Give the practice database a distinctive name, and write that name at the top of your notes. On a later session, reconnect and try to retrieve the same rows without reinstalling anything. If you can repeat that check, you have a reliable place to practice the next query.

Prepare your own Windows practice environment

Check Microsoft’s current requirements before downloading SQL Server Express and SSMS. The course demonstrates Windows and a specific SQL Server release, so the screens in an existing installation can differ. If you prefer Visual Studio Code, check Microsoft’s current instructions for its MSSQL extension. You can complete the main validation exercise with SSMS without setting up a second editor.

This is the setup lesson in a series. Its job is to give you a working local environment and a few statements you can verify. Save the sample query and your instance notes before you move on to relational projects or more involved reporting. Those notes will help you reconnect and repeat the exercise when you return.

Enroll Now ↗

Related courses for your next step

Compare course focus, level and study time
Compare the published course outlines. A lower level is a preparation option, not a required prerequisite.
Course Level Focus Study time
This course — Free SQL Server Setup Course: Run Your First T-SQL Query Beginner SQL Server setup · Instance verification · Service inspection 75 minutes (Udemy listing)
SQL Queries and Data Management: Free Course Beginner SQL · Data queries · Aggregation 58m of video; practice time is additional
SQL Querying and Reporting: Free Course Beginner SQL foundations · Query reasoning · SQL Server Reporting Services 18h 31m of video; practice time is additional

Frequently asked questions

Do I need to know SQL first?

No. The course starts with setup and uses simple guided T-SQL statements to check the installation.

Do I need Visual Studio Code?

No. The course demonstrates SSMS and presents Visual Studio Code as another editor option.

Does this include the entire beginner series?

No. This listing is the first course and focuses on local setup and initial queries.

Share this course

Questions & discussion

Share a useful question or correction. Comments appear after moderation. Please avoid personal or sensitive information.

Add to the discussion

Your email address will not be published. Required fields are marked *