Switch to the Dutch version/Switch to the English version
  1. Home
  2. SQL Advanced
  3. In-company

SQL Advanced in-company

A two-day course just for your group. You choose the date and the place, and the trainer tailors the content to your practice beforehand.

8.3 from 9 reviews 4,6 on Google NRTO quality mark

Previously attended by employees of CBS Academy, Gemeente Rotterdam, Advanced Programs, Optimizers and others.

  • Tailored: matched to the level and goals of your team
  • Trainers from the field, who do the work themselves
  • At your premises, at ours or online, on a date that suits you
  • In Dutch or English, in the language of your choice
Pascal

Your trainer: Pascal 753 evaluations in total, averaging 8.3. View the trainers

What the course covers

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.

Read the full programme of SQL Advanced

How an in-company course works

  1. RequestYou tell us which course it concerns, how many people and roughly when. You receive a quotation with a fixed price for the group.
  2. AlignmentWe discuss what the group can already do and what should be different afterwards. The trainer adapts the examples and exercises accordingly.
  3. The courseOn the day and at the place you chose, with course materials for every participant.
  4. AfterwardsEvery participant receives a certificate of attendance.

Practical information

Duration
Two-day course
Group
Only your own people
Location
At your office, at one of our locations or online
Date
You choose
Language
Dutch or English
Included
Course materials and a certificate of attendance
Price
Fixed price per group, in a tailored quote (scheduled course: € 1150,- excl. VAT per participant)

The trainers of this course

Ratings from participants after completing their course, across all courses by this trainer.

Pascal

ICT and communication trainer 8,3 from 753 reviews

What participants say about SQL Advanced

8.3
SQL Advanced course: average 8.3 from 9 reviews

“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.”

S. de Zeeuw - CBS Academy10.0

“Well-structured course. Good course material and reference work. The trainer has a sound knowledge of SQL and conveys it well.”

E. Haan9.8

“Good set-up, sound structure, recommended.”

P. Geomini - Gemeente Rotterdam9.0

“Very well organised course with room for your own input.”

Jordy de Groot
Advanced Programs8.3

“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.”

C. Kessenich - Optimizers8.2

“This course gives you an even better picture of what you can do with SQL and how to apply what you have learned. Recommended.”

Jurgen Koopmans
Roba Metals BV8.1

Frequently asked questions about SQL Advanced in-company

Where does the in-company SQL Advanced course take place?

Wherever suits you: at your office, at one of our training locations or online. You also choose the date.

Can the content be tailored to our organisation?

Yes. Before the course we discuss with you what the group can already do, where things go wrong in practice and what should be different afterwards. The trainer uses examples and exercises from your own work.

How large can the group be?

That depends on the course. For a skills course we prefer to work with a small group, so that everyone can really practise. If more people are involved, we schedule several groups or set up a fixed programme.

What does SQL Advanced in-company cost?

You receive a fixed price for the whole group, in a tailored quotation. For a group this is cheaper than booking everyone individually. For comparison: a place on the scheduled course costs € 1150,- excl. VAT per participant.

Can the course be delivered in English?

Yes. For in-company courses we deliver the training in the language of your choice, Dutch or English. Mention it in your request.

Do participants receive a certificate?

Yes, every participant receives a certificate of attendance afterwards.

How do I request a quote?

Via the quote form: state the course, the number of participants and roughly where and when you would like it. An adviser will then contact you.

How long does the SQL Advanced course take and where can I find the current price?
The SQL Advanced course lasts two consecutive days. The course is taught in a classroom setting by an experienced database trainer. You receive a book with exercises and practical cases that you can also use as a reference work. During the course you work with Microsoft SQL Server; the software and course materials are in English. The current price can be found on the course page at learnit.nl.
What prior knowledge do you need for the SQL Advanced course?
For the SQL Advanced course you need a basic knowledge of SQL. You already work with SELECT, WHERE and simple queries, or you have taken the SQL Basics course. Experience with Microsoft SQL Server is useful, but not essential. The course is intended for data analysts, functional administrators, BI consultants, database managers and developers who want to deepen their SQL knowledge with T-SQL.
Which SQL topics and T-SQL techniques does the SQL Advanced course cover?
The SQL Advanced course covers advanced (T-)SQL techniques in Microsoft SQL Server. On day 1 you refresh the basics: SELECT, WHERE, ORDER BY, GROUP BY and functions such as ROUND and DATEPART. On day 2 you get to work with joins, subqueries, table expressions, UNION, window functions (OVER, PARTITION, LAG, LEAD), pivoting, data modification, transactions and programmable objects such as procedures and triggers.
Who is the SQL Advanced course suitable for?
The SQL Advanced course is intended for SQL users who have mastered the basics and want to work with Microsoft SQL Server and T-SQL. Think of functional administrators, database managers, data analysts, BI consultants, information managers, system administrators, database developers and programmers. You deepen your knowledge with advanced techniques such as joins, subqueries, window functions and programmable objects.
Which course material and which software are used during the SQL Intermediate course?
During the SQL Advanced course you work with Microsoft SQL Server. Before the course you receive an English-language course book with exercises and practice cases, which you can then also use as a reference guide. Both the software and the course material are in English; the course itself is simply delivered in Dutch by an experienced database trainer.
What is the delivery format of the SQL Advanced course and in what group size do you follow it?
You take the SQL Advanced course in a classroom setting, led by an experienced database trainer. You work in a small group, which leaves room for individual attention and questions from your own practice. The course combines theory with demos, examples and plenty of practical exercises in Microsoft SQL Server. That way you quickly get to grips with the advanced (T-)SQL functions.
When should you choose the classroom-based SQL Advanced course instead of self-study through online tutorials?
Self-study works fine for individual SQL commands, but it stalls as soon as you have to combine T-SQL techniques such as window functions, subqueries and MERGE in real-life situations. Classroom learning works better if you: - want quick results: you cover both a refresher of the basics and advanced T-SQL - have questions about your own data or queries: the trainer looks at them with you - want to practise in Microsoft SQL Server without first setting up your own environment - want to understand the difference between procedural and object-oriented programming, not just apply it You receive an English-language workbook that also serves as a reference. For anyone who already uses SQL professionally and wants to develop in a specific direction, this is usually more efficient than combining months of separate YouTube videos.
How does the SQL Advanced course compare with a broader data analysis programme such as Power BI or Python?
SQL Advanced focuses specifically on querying and editing relational databases with (T-)SQL in Microsoft SQL Server. You learn to write advanced queries, apply joins, build subqueries, modify data and carry out logical tests. A Power BI course focuses on visualising and reporting data, often based on existing datasets. A Python course for data analysis teaches you scripting, statistics and machine learning. In practice, SQL is often the first step: you extract the right data from the source before visualising it in Power BI or analysing it further in Python. Choose SQL Advanced if you work with databases and want to transform the data yourself. For visualisation or advanced analysis you will also need a separate tool.

SQL Advanced for your team?

Request a quote without obligation and an adviser will be in touch shortly. With one or two colleagues? SQL Advanced is scheduled 13 times over the coming year, in Amsterdam, Rotterdam, The Hague, Utrecht, Eindhoven, Arnhem, Groningen, Zwolle.

Request a quote View the scheduled dates
Private groupfixed price, tailored quotation
Request a quote