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.
Free 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.
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.
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 department that works with Microsoft SQL Server, we also offer this course in-company. In consultation, we work with examples from your own practice.
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
Day 2: Advanced SQL
After the SQL Intermediate course:
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:
Have you no experience with SQL yet? Then the SQL Basics course is a better place to start.
The course is also suitable for those who have completed the basic SQL course and want to work with multiple tables at once in Microsoft SQL Server.
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.
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.
None in particular.
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.
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.
2 training days. Confirmed dates first, then in order of date.
No suitable start date? Send us a date request, and we'll look at the options together.
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.
“Interesting and practical course. The trainer responded quickly to the feedback given, which made it feel even more like a tailor-made course!”
“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.”
“Very well organised course with room for your own input.”
“This course gives you an even better picture of what you can do with SQL and how to apply what you have learned. Recommended.”
"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."
“Well-structured course. Good course material and reference work. The trainer has a sound knowledge of SQL and conveys it well.”
“Good set-up, sound structure, recommended.”
“A clear training course with plenty of useful tips.”
“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.”
"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."
“Good, clear training course, really for building reports for beginners.”
“Excellent course if you want to learn SQL thoroughly and in a structured way. With plenty of practical exercises. The content of the course was excellent: clearly organised, good course material including practice assignments, a good balance between theory and practical exercises. The trainer's knowledge is good, as is the way he explains and conveys the material. He places a strong emphasis on building knowledge in a structured and solid way, rather than on quick results. He responded well to questions.”
“It was a demanding course, covering an enormous amount in two days. It was a thoroughly enjoyable course!”
“The course lives up to its content and teaches you the basic SQL skills in a short space of time.”
“A solid basic course that gives you a very good start in discovering SQL.”
“A useful and practical course for anyone who wants to master the SQL fundamentals.”
“The course material is clear and of a good standard. The exercises are clear with sufficient and progressive depth, and the trainer is calm and competent.”
“Good trainer, plenty of course material. I achieved my initial objectives.”
“Good course to bet the basics of SQL!”
“Good, clear SQL basics course. Learned enough methods that I can apply straight away and that lay the foundation to take it further (on my own).”
“This training course is ideal for people who are going to work with SQL databases. A lot is explained and the pace is never too slow. All kinds of queries are covered, as well as the combined use of different types. Highly recommended!”
“If you have no experience with sql and would like to learn the basics, this course is a good start! Now I know a bit about what sql involves.”
“Valuable course with highly capable trainers, at a pleasant location.”
“Enjoyable course that will be very useful if you want to get started with SQL.”
“The SQL course provides insight into creating queries from databases. During the lessons you learn how a query is constructed. Each lesson starts with the theory, which you then put into practice with a hands-on assignment. This is both enjoyable and instructive.”
“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.”
"This trainer is a highly knowledgeable person who conveys the course material to the participants in a calm, considered and thorough manner."
“Gaining a broad basic knowledge of SQL helps me in practice to create simple queries and to read and adapt more extensive ones. That was exactly what I was looking for. What certainly also makes the difference is that the small scale means everything is tailored to the participants.”
“Theory and practice (doing the exercises yourself) in the right balance. Very good course. Professional trainer. The pace of the course is just right.”
“This is an excellent programme for learning the basics of SQL!”
“A good overview of what SQL can do.”
“If you have an affinity with IT but no experience with SQL yet, this course is perfect for learning it.”
“Everything was arranged perfectly, I learnt a great deal!”
“A good course for learning the basic principles of SQL. Plenty of practical exercises, so you get to grips with SQL quickly. It was led by a good trainer who took the time to explain things. Teaches with enthusiasm. A sociable and friendly person. Learnit Training is a professional organisation, customer-focused and with good, fast service.”
“Challenging, particularly because it could be adjusted on the spot to the level of the participants.”
“You get value for money. And you leave with the knowledge to write your own SQL statements.”
“Effective training course from an experienced trainer with more than enough knowledge. The trainer was able to switch quickly between people and also focused on those who needed it without forgetting the others.”
“Good course to bet the basics of SQL!”
“Enjoyable and highly applicable course; you really get something out of it and you can put it into practice straight away. Highly recommended.”
“Very good course for learning how to build basic queries. Clear book with good examples and a good structure. The trainer is highly knowledgeable. His way of explaining things held our attention. Clarifying explanations.”
“Good course. Very clear and applicable. You learn every facet of SQL.”
“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!”
“This training course is ideal for people who are going to work with SQL databases. A lot is explained and the pace is never too slow. All kinds of queries are covered, as well as the combined use of different types. Highly recommended!”
“A good course that you can put to plenty of use in practice.”
“A good course for learning the basics of SQL and then applying it directly in practice.”
“I expected a basic course that covered writing queries from scratch from A to Z. The course did exactly that. A perfect match.”
“Very enjoyable course. The trainer knows a great deal about this subject, but also has a lot of general knowledge, which makes it possible to give clear examples from practice. Every question is answered with genuine interest by the trainer.”
“Good course with clear explanations at a calm pace. Also manageable without prior knowledge.”
“This course gives you an even better picture of what you can do with SQL and how to apply what you have learned. Recommended.”
“A pleasant, interactive course that gives you plenty of hand-outs to put into practice at work.”
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.
This date already has enough participants. Free cancellation up to four weeks before the start, so you can secure a place now.