Transact-SQL Basics course - MS SQL Server

In this practical course you learn to work with Transact-SQL and Microsoft SQL Server: from simple queries to joins, groupings and editing your data.

8.6 from 4 reviews 4,6 on Google NRTO quality mark

Free cancellation up to four weeks before the start, so feel free to book now.

For a team or department? Arrange your own group, at your premises or ours. In-company for your team
  • Writing your own queries in T-SQL and SQL Server
  • Filtering, sorting, grouping and combining data
  • Plenty of practice in Management Studio
  • Small group, experienced database trainer
  • Course book included, also as a reference work

You work with data in Microsoft SQL Server and want to be able to write your own queries. In this course you will learn the building blocks of T-SQL: from simple SELECT statements to joins, groupings and subqueries.

Description

Microsoft SQL Server is one of the most widely used database systems for database management, development and business intelligence. Transact-SQL is the SQL variant that Microsoft has added to it, with extra options for logical blocks and programming constructs.

You start with the basics: how a relational database works, what primary and foreign keys are, and how to retrieve data with SELECT. You then build up step by step to filtering, sorting, calculating and combining data from several tables.

The course is practice-oriented. You work extensively in Microsoft SQL Server Management Studio and practise with realistic datasets. Theory and practice alternate continuously, so you apply what you have learned straight away.

For teams and organisations. If you want to give a BI team, data department or group of application administrators the same T-SQL foundation, we also run the course in-company. In consultation, we work with examples from your own practice, so that the queries match the work the team already does.

Topics

Day 1: SQL basics and simple queries

  • Basic principles: databases, data types, primary key and foreign key
  • Introduction to Microsoft SQL Server and Management Studio
  • Retrieving data with SELECT, FROM, TOP and DISTINCT
  • Sorting with ORDER BY
  • Filtering with WHERE, comparison operators and BETWEEN
  • Advanced filtering with AND, OR, IN and NOT
  • Working with wildcards (LIKE)
  • Calculations and concatenation

Day 2: Advanced queries and T-SQL

  • Functions: ROUND, LTRIM, RTRIM, DATEPART
  • Summarising with COUNT, SUM, AVG, MAX and MIN
  • Grouping with GROUP BY and HAVING
  • Subqueries with IN
  • Combining tables with INNER JOIN, LEFT OUTER JOIN and RIGHT OUTER JOIN
  • Table aliases and advanced joins
  • Combining queries with UNION
  • Adding, modifying and deleting data (INSERT, UPDATE, DELETE)
  • Managing tables with CREATE, ALTER and DROP
  • The added value of T-SQL over standard SQL

Result

After this course you understand how Microsoft SQL Server works and you know the difference between SQL and T-SQL. You independently write queries to retrieve, filter, sort and combine data from several tables. You apply functions and groupings to summarise data, and you can add, change and delete records. This allows you to get more value out of the data in your organisation.

Target audience

This course is intended for beginning users of Microsoft SQL Server who want to get started with T-SQL. Think of beginning database administrators and database managers, BI professionals, data analysts, report builders and software developers who want to be able to write their own queries.

The course is also suitable for functional application administrators, key users, controllers and financial analysts who want to retrieve data directly from a SQL Server database instead of waiting for an export or report. If you currently work mainly with data in Excel and want to make the step to a database, the course is also a good fit.

Teaching method

You work in a small group under the guidance of an experienced database trainer. Theory alternates with demos and plenty of practical exercises in Microsoft SQL Server Management Studio. You are welcome to bring in examples from your own working practice. Before the course you will receive a course book with exercises, which you can also use afterwards as a reference work. The software and the course material are in English.

Prior knowledge

No specific prior knowledge is required. An affinity with data and logical thinking is useful, however.

Comments

Would you prefer a platform-independent SQL basics course? Then take our SQL Basics course.
Looking for a basic SQL course aimed specifically at Oracle? Then register for the SQL Basics Oracle course.

Practical information

Number of days
2 days
Course times
from 10 am to 5 pm
Teaching hours
12 hours
Education level
Suitable for all levels
Preparation time
None
Included
Course materials and lunch on site
Certificate
At the end of the course you will receive a certificate of attendance
Cancel
Free up to four weeks before the start (cancellation terms)

Language

The course is given in Dutch as standard. The trainer speaks English. English-language course materials can be used. If at least 3 participants register, the course can also be given entirely in English.

All start dates

2 training days. In order of date.

  • Tue 22 & Wed 23 December 2026 Amsterdam · 10:00–17:00Free cancellation until 24 November Enrol
  • Tue 22 & Wed 23 December 2026 Online · 10:00–17:00Free cancellation until 24 November Enrol
  • Tue 5 & Wed 6 January 2027 Utrecht · 10:00–17:00Free cancellation until 8 December Enrol
  • Wed 27 & Thu 28 January 2027 Utrecht · 10:00–17:00Free cancellation until 30 December Enrol
  • Wed 17 & Thu 18 February 2027 Amsterdam · 10:00–17:00Free cancellation until 20 January Enrol
  • Tue 16 & Wed 17 March 2027 Arnhem · 10:00–17:00Free cancellation until 16 February Enrol
  • Tue 30 & Wed 31 March 2027 Groningen · 10:00–17:00Free cancellation until 2 March Enrol
  • Tue 30 & Wed 31 March 2027 Zwolle · 10:00–17:00Free cancellation until 2 March Enrol
  • Wed 14 & Thu 15 April 2027 The Hague · 10:00–17:00Free cancellation until 17 March Enrol
  • Wed 28 & Thu 29 April 2027 Eindhoven · 10:00–17:00Free cancellation until 31 March Enrol
  • Tue 1 & Wed 2 June 2027 Arnhem · 10:00–17:00Free cancellation until 4 May Enrol
  • Tue 31 Aug & Wed 1 Sep 2027 Rotterdam · 10:00–17:00Free cancellation until 3 August Enrol
  • Tue 14 & Wed 15 September 2027 Rotterdam · 10:00–17:00Free cancellation until 17 August Enrol

No suitable start date? Send us a date request, and we'll look at the options together.

This course for your team?

Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.

  • Your date and location
  • Tailored content
  • Multiple groups or an academy are also possible
  • More than 25 years' experience
Request a quote No obligation, an adviser will be in touch shortly How in-company works

What others say about this course

8.6
Transact-SQL Basics course - MS SQL Server: average of 8.6 from 4 reviews

“This course teaches you in 2 days what SQL is, how you can use it and what the well-known mistakes are. The trainer is highly professional and has a great deal of knowledge of the subject.”

D. Gebroers
Alfa Accountants en Adviseurs
9.6

“This basic course met my expectations. The trainer was knowledgeable and relaxed, with plenty of individual attention where needed.”

A. Arkeraats
ANWB
8.2

“I found the combination of short explanations and exercises very pleasant. The trainer has an agreeable way of conveying knowledge and weaves practical experience into the course material.”

R. Mouwen
ATEA-Groep
8.0

“SQL Basics was an excellent course and immediately applicable in practice. The trainer is friendly, patient and open. He certainly knows his subject and enjoys being challenged by his participants.”

M. Sybesma
GGZ Rivierduinen,
8.4

"Colleagues were impressed by how much I already knew after a 2-day course."

Participant
SQL Basics

“Enjoyable basic course, perfect location (Amsterdam, Muziekgebouw aan 't IJ).”

S. Buster
De Nederlandsche Bank
SQL Basics
7.4

Training formats

Classroom

2 days€ 1100,-
  • Pleasant venue with a good trainer
  • Small groups
  • Inspiring and motivating
Choose a date

Online

2 days€ 930,-
  • Online with a trainer
  • Personal
  • Practical and interactive
Choose a date

In-company

Bespoke trainingOn request
  • 100% for your group
  • Bespoke training
  • At your place or ours
View in-company

Workshop

Up to 4 hours for groupsOn request
  • Suitable for events
  • Interactive and inspiring
  • Large groups too
Request a quote

Private training

At our place or yoursOn request
  • 100% just for you
  • Achieve a lot in little time
  • Whenever you want
Request a quote

Frequently asked questions

Can I cancel free of charge?

Yes. Up to four weeks before the first day of the course you can cancel free of charge, without giving a reason. You then receive a credit note or, if you have already paid, a refund. If you cancel later, you pay part of the course fee: 25% between four and two weeks before the start, 75% in the two weeks before it and 100% in the final week. Moving to another start date is free of charge up to two weeks before the start, after that 50%. Sending a colleague in your place is always possible. Read the cancellation terms.

What is Transact-SQL and how does it differ from standard SQL?

Transact-SQL (T-SQL) is Microsoft's SQL variant for SQL Server. It contains all the standard SQL commands such as SELECT, INSERT and JOIN, and adds extra capabilities for logical blocks, variables, error handling and procedural programming. This allows you to run more complex logic directly in the database with T-SQL.

Do I need prior knowledge to take this course?

No, you do not need any specific prior knowledge of SQL or databases. An affinity with data and logical thinking is useful, however, as you will be working with queries and relationships between tables.

Who is this T-SQL course intended for?

The course is intended for beginning users of Microsoft SQL Server. Think of data analysts, BI professionals, junior database managers and administrators, report builders and software developers who want to be able to write their own queries.

Which software is used during the course?

You work with Microsoft SQL Server and SQL Server Management Studio (SSMS). The software and the course material are in English; the explanations are in Dutch.

What exactly will I learn during the?

Day one focuses on the basics: SELECT statements, filtering, sorting and simple calculations. Day two goes deeper into functions, grouping, subqueries, joins between tables, UNION and data manipulation with INSERT, UPDATE and DELETE. You also manage tables with CREATE, ALTER and DROP.

Do I receive a certificate on completion?

Yes, on completion you will receive the Learnit certificate of participation. This demonstrates that you have completed the Transact-SQL Basics course.

Is this course also suitable as a stepping stone to advanced SQL?

Yes. After this basic course you will have mastered the building blocks you need for follow-up courses on advanced T-SQL, database development or business intelligence with SQL Server.

Can I also take this course in-company?

Yes, in addition to the scheduled courses you can also follow this course in-company, on location or online. We then tailor the content and examples to the working practice within your organisation. Request a quotation for the options.

Do you work with your own data during the course or with practice databases?

During the course you practise with prepared exercise databases, so that all participants start from the same point. You can raise questions about your own situation or dataset, so that the trainer can show you how you would build a comparable query in your own practice.

What is the difference between an INNER JOIN and an OUTER JOIN?

An INNER JOIN returns only those rows for which a match exists in both tables. A LEFT OUTER JOIN returns all rows from the left-hand table, even if there is no match in the right-hand table. A RIGHT OUTER JOIN does the same, but from the right-hand table. Both joins are covered extensively during the course.

Is there any support after the course if I run into a problem?

During the course you receive a course book with exercises that you can then use as a reference work. For more in-depth questions you can take a follow-up course or request a bespoke programme.

How much does the Transact-SQL Basics course cost?

You can find the current price at the top right of this course page, along with the schedule, location and delivery format. For in-company or bespoke courses we are happy to provide a quotation on request.

Next start: Tue 22 & Wed 23 December 2026 in Amsterdam, also available online

Free cancellation up to four weeks before the start, so you can secure a place now.

€ 1100,-excl. VAT · next start Tue 22 Dec
Choose a date