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.
Related courses for your next step
- Compare another approachSQL Queries and Data Management
Focus: SQL · Data queries
Beginner
- Compare another approachSQL Querying and Reporting
Focus: SQL foundations · Query reasoning
Beginner
Compare course focus, level and study time
| 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.
Questions & discussion
Share a useful question or correction. Comments appear after moderation. Please avoid personal or sensitive information.