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.
Free cancellation up to four weeks before the start, so feel free to book now.
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.
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.
Day 1: SQL basics and simple queries
Day 2: Advanced queries and T-SQL
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.
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.
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.
No specific prior knowledge is required. An affinity with data and logical thinking is useful, however.
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.
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.
2 training days. 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.
“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.”
“This basic course met my expectations. The trainer was knowledgeable and relaxed, with plenty of individual attention where needed.”
“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.”
“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.”
"Colleagues were impressed by how much I already knew after a 2-day course."
“Enjoyable basic course, perfect location (Amsterdam, Muziekgebouw aan 't IJ).”
"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."
“Useful course for learning SQL quickly.”
“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.”
“Absolutely excellent, a pleasant and knowledgeable trainer. Good pace, plenty of variation between content and exercises. The course comes highly recommended!”
“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!”
“I am positive. I now feel less like I am getting lost in queries made by others. Creating queries is not a requirement for my role, but making the occasional small adjustment to generate output is.”
“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.”
“The content was good. We had requested a course to learn the new functions / changes in SQL Server 2012. So we largely determined the content ourselves. The trainer picked this up well and clearly explained per topic what had changed / was new and how to deal with it, and gave examples for each topic.”
“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.”
“A good course if you have no knowledge of SQL yet. You can put what you have learned to use straight away.”
“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!”
“Good set-up, sound structure, recommended.”
“Excellent course in which the complete basics are explained; the trainer can also discuss matters that fall outside the scope of the course.”
“This is an excellent programme for learning the basics of SQL!”
"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, practice-oriented programme, recommended for the increasingly popular field of Big Data.”
“This is an excellent programme for learning the basics of SQL!”
“The trainer has a great deal of knowledge of the subject matter. He showed examples he had made himself, which were very interesting. He explained these examples in full. I learnt a lot from this and felt motivated.”
“it is a very good foundation, so you can get started with SQL straight afterwards.”
"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."
“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.”
“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.”
"The course is delivered topic by topic. A number of exercises are discussed, after which you get to work yourself and talk it through. The method appealed to me because it was so clearly structured."
“Good course to bet the basics of SQL!”
“Practical training course that lays a good foundation for further use and understanding of SQL.”
“It was a demanding course, covering an enormous amount in two days. It was a thoroughly enjoyable course!”
“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!”
"The trainer was very good and the course material was clear. The pace of the course was manageable and the exercises offered exactly the right amount of challenge."
“Learnit gave good thought to how the SQL Basics course on site should be set up. This was for a small group with different backgrounds and levels of basic knowledge. This was no problem at all for the course or the trainer. The structure is pleasant and the course moves along nicely. There is room to go into more depth, and a big advantage is that you do a lot yourself and discuss it afterwards.”
“Very good training course. A lot is covered in two days, but still at a comfortable pace. Good alternation between theory and doing exercises yourself. Excellent trainer, has a great deal of knowledge of the subject and is able to convey this clearly and in a pleasant way.”
“This course has a clear structure and build-up. Alongside the theory there is plenty of room to practise and to put real-life situations to the trainer. A calm, qualified and clear trainer. He knew what he was talking about and how the course fits together. All in all a good way to make a start with SQL.”
“Enjoyable and interesting course in which you get straight to work applying the material through related assignments that are discussed as a group afterwards.”
“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.”
“A good balance between listening and practising. After this course you have a solid basis to get started on your own.”
“Got refreshed with my sql skils”
“An SQL course that anyone without any programming experience can follow, through a piece of theory followed by exercises. In small groups, which allows for personal interaction with the trainer.”
"It was all explained clearly and enthusiastically. The trainer came across as an expert. We received plenty of attention, but then again we were a small group. It met expectations. I achieved my learning objectives. The location was lovely too (Amsterdam, Muziekgebouw aan 't IJ)."
“Excellent course. You really come away with the basics! The trainer was very enthusiastic and delivered the course in an enjoyable way.”
“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.”
“Very good course. Excellent trainer”
“I expected a basic course that covered writing queries from scratch from A to Z. The course did exactly that. A perfect match.”
“Very good training course. A lot is covered in two days, but still at a comfortable pace. Good alternation between theory and doing exercises yourself. Excellent trainer, has a great deal of knowledge of the subject and is able to convey this clearly and in a pleasant way.”
"Fine, short yet complete basic course."
“I expected a basic course that covered writing queries from scratch from A to Z. The course did exactly that. A perfect match.”
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.
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.
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.
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.
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.
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.
Yes, on completion you will receive the Learnit certificate of participation. This demonstrates that you have completed the Transact-SQL Basics course.
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.
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.
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.
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.
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.
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.
Free cancellation up to four weeks before the start, so you can secure a place now.