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.