SQL Intermediate course
In this follow-up SQL course you deepen your knowledge of SQL and T-SQL in Microsoft SQL Server, covering joins, subqueries, transactions and programmable objects.
NRTO quality markFree cancellation up to four weeks before the start, so feel free to book now.
In brief. SQL Advanced is a 2-day classroom course. You can take it in Amsterdam, Rotterdam, Utrecht and The Hague, among other places, or online, in a group of no more than 8 participants. The price is € 1150,- excl. VAT per participant, including course materials, lunch on location and a certificate of participation. For a team or department we also run this course in-company.
- Get started with T-SQL right away
- Advanced queries with joins and subqueries
- Practical exercises in MS SQL Server
- Book and reference material included
- New career opportunities in data and IT
Your trainer: Pascal 753 evaluations in total, averaging 8.3. View the trainers
Want to take your SQL knowledge to the next level? In the SQL Advanced course you work in Microsoft SQL Server with T-SQL, advanced queries, joins, subqueries and programmable objects. Practical, with plenty of exercises under the guidance of an experienced trainer.
Description
In the SQL Advanced course you build on your basic SQL knowledge and go deeper into the possibilities of Microsoft SQL Server and Transact-SQL (T-SQL). You first refresh the basic concepts and then extend your knowledge with advanced ways of sorting, filtering and calculating data.
You then move on to advanced techniques. You work with joins, subqueries, table expressions and combining queries. You also learn how to modify data, manage transactions and use window functions. In addition, you are introduced to procedural programming, logical tests and programmable objects such as procedures and triggers.
Under the guidance of an experienced database trainer, you alternate theory with demos, practical examples and plenty of exercises in Microsoft SQL Server. That way you quickly get to grips with the advanced functions of (T-)SQL and can apply them directly in your own work.
For teams and organisations. For a team of data analysts or developers we also run this course in-company. In consultation with you, we work with examples that match your own data.
Topics
During this course you work in Microsoft SQL Server with the advanced possibilities of (T-)SQL. You first brush up on the basics and then build up your knowledge step by step with topics for advanced users.
Day 1: Refreshing basic SQL concepts
- Retrieving data with SELECT FROM, TOP and DISTINCT
- Sorting with ORDER BY
- Filtering with WHERE, comparison operators and BETWEEN
- Advanced filters: AND, OR, IN, NOT
- Using wildcards with LIKE
- Calculated fields and concatenation
- Editing data with functions such as ROUND, LTRIM, RTRIM and DATEPART
- Summarising with COUNT, SUM, AVG, MAX and MIN
- Grouping with GROUP BY and HAVING
Day 2: Advanced SQL
- Linking multiple tables with joins (INNER, LEFT OUTER, RIGHT OUTER, composite and non-equi)
- Working with subqueries, including running aggregates
- Table expressions: derived tables, aliases, variables and WITH
- Combining queries with UNION, INTERSECT and EXCEPT
- Window functions: OVER, PARTITION, LAG, LEAD and pivoting
- Modifying data with INSERT, UPDATE, DELETE, MERGE and OUTPUT, plus export to Excel
- Transactions and concurrent use: BEGIN, ROLLBACK, COMMIT, READ UNCOMMITTED and READ COMMITTED
- The difference between procedural and object-oriented programming
- Programmable objects and logical tests: variables, batches, IF, ELSE, WHILE, cursors, procedures and triggers
Result
After the SQL Intermediate course:
- you will have refreshed the basic concepts of SQL.
- you will know additional commands for querying, sorting and filtering data.
- you will be able to perform simple and more complex calculations in SQL.
- you know how to combine queries and use subqueries.
- you will be able to apply data modifications, transactions and other advanced SQL techniques.
- you will know the difference between procedural and object-oriented programming.
- you can carry out logical tests using T-SQL.
- you know what programmable objects are and how to apply them in Microsoft SQL Server.
- you will work confidently with Microsoft SQL Server and T-SQL.
- you increase your career opportunities in IT, for example as a data analyst, BI consultant, database developer or programmer.
Target audience
Do you already work with SQL and want to take things further? This follow-up course is designed for SQL users who have mastered the basics and want to deepen their knowledge with Microsoft SQL Server and T-SQL.
You will probably recognise yourself in one of these roles:
- functional administrator
- database manager
- data analyst
- BI consultant
- information manager
- system administrator
- database developer
- programmer
Have you no experience with SQL yet? Then the SQL Basics course is a better place to start.
The course is also suitable for data analysts who want to master SQL at an advanced level, with subqueries, joins and programmable objects.
Teaching method
During this course you work in small groups under the guidance of an experienced database trainer. We alternate theory with demos, examples from your own day-to-day practice and plenty of exercises in Microsoft SQL Server. That way you quickly get a proper feel for the advanced features of (T-)SQL.
Before the course you receive a book with exercises and practice cases, which you can also use afterwards as a reference work. Please note that both the software and the course materials are in English.
Prior knowledge
You have a command of the basics of SQL: you can write simple queries independently using SELECT, WHERE and ORDER BY. Have you taken the SQL Basics course or do you already work with it in practice? Then you are in the right place. Experience with MS SQL Server is useful, but not required.
Comments
None in particular.
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.
In-company
Would you like to organise this training for a whole group or several groups? This can be cost-effective. For example, we can tailor the content entirely to your organisation, and training a whole group is also cheaper.
Are you looking at large numbers of participants or a complete academy? That involves a great deal. Consider planning and communication, for example, or identifying and agreeing the objectives and content of the training. Or differences in level, feedback mechanisms and safeguarding. Fortunately, Learnit has extensive experience in this field (more than 25 years) and we are happy to help you through this process.
All start dates
2 training days. Confirmed dates first, then in order of date.
- Thu 26 & Fri 27 November 2026Certain to go ahead Rotterdam · 10:00–17:00Free cancellation until 29 October Enrol
- Wed 4 & Thu 5 November 2026 Amsterdam · 10:00–17:00 Enrol
- Thu 26 & Fri 27 November 2026 Online · 10:00–17:00Free cancellation until 29 October Enrol
- Thu 17 & Fri 18 December 2026 Utrecht · 10:00–17:00Free cancellation until 19 November Enrol
- Mon 4 & Tue 5 January 2027 Eindhoven · 10:00–17:00Free cancellation until 7 December Enrol
- Thu 11 & Fri 12 February 2027 Amsterdam · 10:00–17:00Free cancellation until 14 January Enrol
- Mon 15 & Tue 16 March 2027 Arnhem · 10:00–17:00Free cancellation until 15 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
- Tue 25 & Wed 26 May 2027 The Hague · 10:00–17:00Free cancellation until 27 April Enrol
- Thu 5 & Fri 6 August 2027 The Hague · 10:00–17:00Free cancellation until 8 July Enrol
No suitable start date? Send us a date request, and we'll look at the options together.
This course by city
- SQL Advanced in Amsterdam2 dates
- SQL Advanced in Utrecht1 date
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
The trainers for this course
Ratings from participants after completing their course, across all courses by this trainer.
What others say about this course
SQL Advanced course: average 8.3 from 9 reviews
“Good set-up, sound structure, recommended.”
“Interesting and practical course. The trainer responded quickly to the feedback given, which made it feel even more like a tailor-made course!”
"This course contains a welcome refresher of the basic SQL knowledge, but is also a good follow-up with many useful techniques. The pace is comfortable. I was able to take away a great deal that I can apply in my work."
“A clear training course with plenty of useful tips.”
“Very well organised course with room for your own input.”
“For me, this course was on the one hand a good repetition of the SQL Basics course I also attended, and on the other hand it covered additional topics I did not yet know. Thanks to the content of the course I now have, as the trainer nicely put it, a number of new tools in my toolbox that I can use if I need them in my work.”
“This course gives you an even better picture of what you can do with SQL and how to apply what you have learned. Recommended.”
“Well-structured course. Good course material and reference work. The trainer has a sound knowledge of SQL and conveys it well.”
"If the preparations are sound and tailored to the client's organisation (type/kind), this can be an excellent course for most of the essential SQL statements."
“The SQL Advanced course was very good and applicable in practice. This course is a good addition if you already know a bit more about T-SQL. It teaches you a number of approaches that you would normally do differently. The first day is also good for refreshing your knowledge.”
“I was very satisfied with the set-up and delivery of this course. A good balance was struck between participants working at different paces. The explanations were clear, with a good balance between doing exercises together and getting to work on exercises yourself.”
“Very easy to follow, especially for people who want to get started with SQL. Suitable for both IT and non-IT people. Definitely recommended!”
“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.”
“A good course for learning the basics of SQL and then applying it directly in practice.”
“You get value for money. And you leave with the knowledge to write your own SQL statements.”
“Without much programming experience, I learned a great deal about SQL in these two days. When you look at the sort of query you can write by the end of the second day, you really see the progress you have made over those two days. The trainer had time for everyone and took plenty of it.”
"This course contains a welcome refresher of the basic SQL knowledge, but is also a good follow-up with many useful techniques. The pace is comfortable. I was able to take away a great deal that I can apply in my work."
“Challenging, particularly because it could be adjusted on the spot to the level of the participants.”
“Enjoyable and interesting course in which you get straight to work applying the material through related assignments that are discussed as a group afterwards.”
"This trainer is a highly knowledgeable person who conveys the course material to the participants in a calm, considered and thorough manner."
“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.”
“For beginners and advanced users alike this is an instructive course, taught in an interactive way. That is very pleasant, because you can apply it immediately while doing the exercises given during the course. There is always the opportunity to ask questions and the guidance is good too. So all in all a very good experience with the SQL Basics course from Learnit Training!”
“A good basic course to get you started with SQL”
“Clear explanations and good exercises gave a good picture of what SQL can do.”
“The trainer sets a good pace for beginners, keeps your attention and is extremely clear in the way he communicates. As a result you remember everything better and stay motivated!”
"The course exceeded my expectations, highly recommended. The trainer had a great deal of knowledge."
“Definitely recommended if you work with SQL. I learned useful things in this training course that I was not previously aware of.”
“An excellent course to start with as a complete beginner. You first get to know the software package and then get straight to work on small assignments. As a result, I am now able to create small databases and reports.”
“The course is interactive. Within two days you have a clear picture of the possibilities of SQL”
“SQL Basics Oracle is a course I can recommend with complete confidence. Its practical applicability is very high!”
“It met my expectations. At the very least I can now read an SQL script. Creating simple ones myself also goes well.”
“A good course for taking the first step towards becoming an SQL expert.”
"Colleagues were impressed by how much I already knew after a 2-day course."
“SQL Basics is an enjoyable course that I can recommend. Knowledgeable trainer, good lunch, learned a lot in 2 days! Now to apply it in practice...”
“A very practical course in which you learn to work with SQL straight away. No long, dry sessions, but simply getting started right after a short introduction. Combine that with a trainer who knows what he is talking about and you are typing out your first queries in no time.”
“Very satisfied with the content, received a good explanation of the differences between SQLSERVER 2008 and 2012. The trainer was well able to relate to our problems/questions. He knows what he is talking about and is good at pointing out the differences and the pros and cons.”
"Recommended! An enjoyable, informal way to broaden your knowledge."
“Interesting and practical course. The trainer responded quickly to the feedback given, which made it feel even more like a tailor-made course!”
“Practically applicable within my own organisation.”
“Good set-up, sound structure, recommended.”
“Very practical training course. Clear explanations and plenty of relevant exercises.”
“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.”
"A fine course if you are really getting to know this subject matter. There is clear and well-structured course material with plenty of exercises to learn SQL."
"A good basic course. Topics are explained step by step, after which participants practise for themselves with a number of short exercises. Because the trainer walks around and looks on, you get immediate feedback."
“Good trainer, plenty of course material. I achieved my initial objectives.”
“Enjoyable and interesting course. Clear explanations, examples and exercises. It was also good that the assignments were phrased the way a colleague would put them to you, so you have to work out for yourself how to tackle them. Learned a lot of functions in a short space of time.”
"Learnit is a professional organisation with a personal approach. The SQL course was well matched to our starting level, and the trainer guided us through the material skilfully and with great enjoyment. Excellent!"
“Very good, the trainer had a lot of knowledge. Good examples. Room for questions.”
“This course teaches you the basics of SQL in a straightforward way. The exercises tie in well with the course material.”
“SQL is a language. The course teaches you how to read and understand this language and how to tell a simple story with it. The location (Amsterdam, Muziekgebouw aan het IJ) was great – excellent venue, with all the necessary facilities, hospitality, a bit of a homely feel. Learnit Training met my expectations – approachable, good dialogue, no unnecessary waiting, good information, clear.”
Training formats
Classroom
2 days€ 1150,-- Pleasant venue with a good trainer
- Small groups
- Inspiring and motivating
In-company
Bespoke trainingOn request- 100% for your group
- Bespoke training
- At your place or ours
Workshop
Up to 4 hours for groupsOn request- Suitable for events
- Interactive and inspiring
- Large groups too
Private training
At our place or yoursOn request- 100% just for you
- Achieve a lot in little time
- Whenever you want
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.
How long does the SQL Advanced course take and where can I find the current price?
What prior knowledge do you need for the SQL Advanced course?
Which SQL topics and T-SQL techniques does the SQL Advanced course cover?
Who is the SQL Advanced course suitable for?
Which course material and which software are used during the SQL Intermediate course?
What is the delivery format of the SQL Advanced course and in what group size do you follow it?
When should you choose the classroom-based SQL Advanced course instead of self-study through online tutorials?
How does the SQL Advanced course compare with a broader data analysis programme such as Power BI or Python?
What will I learn in the SQL Advanced course that I would not pick up in a basic SQL course or through a free online tutorial?
After the SQL Advanced course, can I start working with data analysis in my job straight away, or do I need further training?
Is the SQL Intermediate course also useful if I mainly work with other databases, such as MySQL, PostgreSQL or Oracle?
How does the SQL Advanced course fit into a learning path towards a role as a data analyst or BI consultant?
Confirmed to go ahead: Thu 26 & Fri 27 November 2026 in Rotterdam, can also be attended online
This date already has enough participants. Free cancellation up to four weeks before the start, so you can secure a place now.