Learnit Training
Course SQL Continuation
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

The SQL Continuation training will go deeper into the creation of queries in the T-SQL language that is specifically used to access the SQL server.

Yes, I want to know more

"The training SQL provides insight into the creation of queries from databases. During the lessons, you learn how a query is constructed. During the lessons, first the theory is discussed and then a practical assignment is carried out. This is very fun and instructive." - Rating: 9.0

learnit SQL Basics

Course SQL Continuation

For data retrieval, database systems often use the SQL language. One of the most widely used database systems for professional users is MS SQL Server. For this system, additional SQL commands have been created in the form of T(ransact)-SQL. Among other things, T-SQL offers the possibility of extending the query with local variables and procedural programming. The latter includes, for example, logical tests such as IF.. ELSE... or WHILE. are among the commands. In addition, there are certain common commands that have been upgraded within T-SQL in order to improve their functionality and therefore their use.

In our two-day SQL Continuation course, after a review of the most commonly used basic concepts, we will dive deeper into the possibilities that SQL and T-SQL offer to create queries in order to retrieve the necessary data from the database. At the end of the course, you will be able to use the unique features of T-SQL such as variables, transactions and procedural programming.

Topics

  • Repetition of Basic SQL:
  • Query data (SELECT FROM, TOP, DISTINCT)
  • Sort data (ORDER BY)
  • Filtering data (WHERE, comparison operators, BETWEEN)
  • Advanced filters (AND, OR, IN NOT)
  • Filtering using wildcards (LIKE)
  • Calculated fields (concatenate)
  • Adjust data with functions (ROUND, LTRIM, RTRIM, DATEPART)
  • Summarise data (COUNT, SUM, AVG, MAX, MIN)
  • Grouping of data (GROUP BY, HAVING)

  • Retrieve data from multiple tables with joins (INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, Composite JOIN, Non-equi JOIN)
  • Using sub-queries (IN, e.g. search against previous order, running aggregate)
  • Using table expressions (derived tables, alias, variables, WITH)
  • Combining queries (UNION, INTERSECT, EXCEPT)
  • Advanced techniques (Window functions OVER, PARTITION, LAG, LEAD, Pivoting)
  • Data modification (INSERT, UPDATE, DELETE, MERGE, OUTPUT), Export to Excel
  • Transactions and Concurrent Use (BEGIN, ROLLBACK, COMMIT, READ UNCOMMITTED, READ COMMITTED)
  • Programmable objects (Variables, Batch, IF, ELSE, WHILE, cursors, procedures, triggers)

Target group

The training is intended for users of Microsoft SQL Server. The training is suitable for database users who already have a reasonable grasp of basic SQL and now want to get more out of MS SQL Server, but also for functional administrators and data analysts who want to learn to use unique features of T-SQL such as variables, procedural programming and transactions.

Language

The training is provided in Dutch as standard. The trainer has a good command of the English language. Use can be made of course material in English. With a minimum of three participants, the training can also be provided entirely in English.

Investment

Prices mentioned are per person, including course material. Lunch is included in the on-site training.

On location Online
Duration 2 days 4 sessions of three hours
Price per day, excluding VAT € 475,- € 390,-
Total, incl. VAT € 1149,50 € 943,80

Certificate

After completion of the training, a Learnit certificate is issued as proof of participation.


Online

We also organise this training online. For this we use Webbex or Zoom. Login with Skype is also possible. On request, this training can also be organised with Microsoft Teams.

The training lasts 4 sessions of 3 hours, spread over 4 weeks.

  • You can participate again free of charge up to one year after the training.
  • For an additional catering fee, you can also participate in a classroom training.

References

The course SQL Follow-up has been assessed with an average of 8.

"This training gives you an even better idea, what you can do with SQL and how you can apply what you have learned. Highly recommended." - Rating: 8.1

Jurgen Koopmans, Roba Metals BV - SQL Follow-up

"This training is a fine refresher for the basic SQL knowledge, but also a fine follow-up with many useful techniques. The pace is pleasant. I was able to take away a lot that I can apply in my work."

- SQL Continued

"If the preparations are good and tailored to the customer's organisation (type/type), this can be an excellent course for most essential SQL statements." - Rating: 6.7

John van Enst, Municipality of Groningen - SQL Follow-up

"Interesting and practical training. Trainer was quick to respond to feedback given, making it even more of a tailor-made training course!" - Rating: 7.5

Marjolein Smits, Advanced Programs - SQL Advanced

"Very well organised training with room for own input." - Rating: 8.3

Jordy de Groot, Advanced Programs - SQL Advanced

"The training SQL provides insight into the creation of queries from databases. During the lessons, you learn how a query is constructed. During the lessons, first the theory is discussed and then a practical assignment is carried out. This is very fun and instructive." - Rating: 9.0

G.J. Leferink, Elementis Delden - SQL Basics

"Excellent training. You really get the basics! The trainer was very enthusiastic and gave the training in a fun way." - Rating: 8.0

H. Wennink, Province of Overijssel - SQL Basics

"This trainer is a very knowledgeable person who conveys the material of the training to the participants in a calm, considered and thorough manner."

- SQL Basics

"It was a tough training, where a lot was covered in two days. It was an enormously enjoyable training!" - Rating: 7.8

P. Janssen, Ministry of Defence - SQL Basics

"Excellent training if you want to learn SQL in a structured way. With many practical exercises. The content of the training was excellent: clearly structured, good learning material including exercises, good variation between theory and practical exercises. The knowledge of the trainer is good, as well as the way of explaining and communicating. He puts a good emphasis on building up knowledge in a structured way, rather than on quick results. Addressed the questions well." - Rating: 9.0

P. Soemers - SQL Basics

"I am positive. I now have less feeling of getting lost in queries made by others. For my job, it is not a requirement to create queries, but it is a requirement to make a small adjustment every now and then to generate output." - Rating: 7.4

J. van de Putte, CIBG - SQL Basics

"Good course to bet the basics of SQL!" - Rating: 8.0

Paul Bakker, Randstad Nederland B.V. Headquarters - SQL Basics

"The training exceeded my expectations, highly recommended. The trainer was very knowledgeable."

- SQL Report Builder

"I was expecting a basic training that would cover the writing of queries from scratch. The training did exactly that. A perfect match." - Rating: 10.0

C. van Lumig. Woonpunt - SQL Basis

"SQL Basis Oracle is a course that I can confidently recommend. The practical applicability is very great!" - Rating: 8.6

N. Meijer. Netherlands Institute for Economic Research - SQL Basis - Oracle

"Good clear training where the basics of SQL are explained."

- SQL Basics

"Never been on a course/training before and the training with everything around it was actually above my expectations." - Rating: 8.2

M. Goedhart, Duynie Holding B.V. - SQL Basics

"At Learnit they continue to learn from their own lessons. What a top course!"

- SQL Basics

"My first introduction to SQL in this SQL basic training. Good, clear explanation of the material. Many exercises to immediately put the material into practice and an enthusiastic trainer make this training a must for everyone who wants to know more about SQL."

- SQL Basics

"I was very satisfied with the design and implementation of this course. A good balance was sought in the difference in pace of the course participants. The explanations were clear and there was a good balance between doing the exercises together and doing them yourself." - Rating: 8.4

J. Esseling, Zorgon B.V. - SQL Basics

"Learnit has thought along well with the interpretation of the SQL Basic training on location. This was for a small group with different backgrounds and basic knowledge. This was no problem at all for the training and the trainer. The structure is pleasant and the training runs smoothly. There is room for deepening and a big advantage is that you do a lot yourself and discuss afterwards." - Rating: 8.0

Timo van Limbeek, University of Twente - SQL Basics

"Good training in which the basics are dealt with hands-on. Some prior knowledge is useful". - Rating: 7.7

Daniëlle van Dijk, TimeTell B.V. - SQL Basics

"Practical course where a user/information analyst quickly learns how to unlock (relational) databases using the basics of SQL." - Rating: 8.1

Arthur Wagenaar - Open Learning SQL

"With this training you will learn in 2 days what SQL is, how to use it and what are the well-known mistakes made. The trainer is very professional and has a lot of knowledge of the subject matter." - Rating: 9.6

D. Gebroers, Alfa Accountants and Advisors - Transact-SQL Basis - MS SQL Server

"Good training with an excellent trainer who could give a clear answer to all our questions. Not only theoretical knowledge, but a lot of practical assignments." - Rating: 7.6

R. Uters, Efteling - SQL Basics

"I can read at least one SQL script. I can create simple scripts myself.

Thata van Meerwijk, Albeda College - Open Learning SQL

"Practically applicable in my own work organisation." - Rating: 8.4

S. Groenen, Zuidzorg - SQL Basics

"The content met my expectations. Acquiring basic SQL knowledge. The trainer was very knowledgeable and also gave many good tips." - Rating: 8.4

W. Kok, Rolec - Oracle Database 10g: SQL fundamentals part I

"Clear explanations and good assignments gave a good idea of the possibilities of SQL." - Rating: 8.0

M. Bessem, Amsterdam Amstelland Police Force - SQL Basics

"Fun and very applicable training, it really helps you and you can immediately put it into practice. Highly recommended." - Rating: 8.0

N.J.G. Cairo-Pol, Diabetes Care System WF - SQL Basis

"The SQL Basic course at Learnit is highly recommended. Personal attention, care of the course material and training are in one word great. I have learned a lot in 2 days. It offers a great foundation to be able to grow further into a professional super user if you want to go to a higher level." - Rating: 8.7

Tim Engelhart, Centraal Beheer Achmea - Open Learning SQL

"After doing this training, I got a very good impression of SQL and its possibilities. I immediately developed ideas about applications in my own work environment and that of others. We know SQL, but only after the basics are clear do you learn to understand what you can and how to do it. This training was perfect for that." - Rating: 8.2

A. Ruijter, Tommy Hilfiger Europe B.V. - SQL Basics

"Good basic training to get you started with SQL" - Rating: 8.0

Ed Riemens, APG - Open Learning SQL

"Training with a good pace. Pleasant alternation between plenary treatment of the material and making individual exercises. Excellent price/quality ratio if you want to work with sql in practice." - Rating: 8.4

B. Willemse. Capter - SQL Basis

"Good training. Very clear and applicable. You learn all facets of SQL." - Rating: 8.6

K. Sijne, AB Vakwerk - SQL Basics

"Training is given by topic. A number of exercises are discussed, then you get to work and talk it through yourself. The method appealed to me because of its clarity."

- Open Learning SQL

"Excellent course where the full basics are explained, trainer can also discuss issues that are not within the scope of the course." - Rating: 8.0

A. Reuijl, Grant Thornton - SQL Basics

"A 2-day training that met my expectations and enabled me to successfully apply what I had learned in daily practice. The skilful trainer knew, by alternating theory and practice, to keep the training lively and to captivate our mixed group until the end. This in a good location with for this training excellent course material." - Rating: 8.4

Charles Slierendrecht, Municipality of Maastricht - Open Learning SQL

"Good training if you have no knowledge of SQL. You can immediately get to work with what you have learned." - Rating: 9.0

F. van Nuland, Sevagram - SQL Basics

"This is a good training to learn the basics of SQL. It is helpful for understanding if you already know something about databases/files. In a number of programming languages SQL knowledge is already indispensable." - Rating: 9.8

P. Anuels, Praclox - SQL Basics

"This training has a clear structure and build-up. In addition to the theory, there is plenty of room to practice and present practical situations to the trainer. Calm, qualified and clear trainer. Knew what he was talking about and how the training was structured. All in all a good way to make a start with SQL." - Rating: 8.6

R. Kemmenaar, Triage-IT - SQL Basics

"Very good training. A lot is covered in two days, but still at a pleasant pace. A good mix of theory and doing exercises yourself. Excellent trainer, has a lot of knowledge of the material and can convey this clearly and in a pleasant manner." - Rating: 9.0

T. Wolfs, NUON - SQL Basics

"Excellent training. Excellent teacher" - Rating: 9.0

Ernst Lesterhuis, Global Knowledge - SQL Basics - Oracle

"The combination of short explanations and assignments I experienced as very pleasant. The trainer has a pleasant way of conveying the knowledge and incorporates practical experience through the material." - Rating: 8.0

R. Mouwen, ATEA Group - Transact-SQL Basis - MS SQL Server

"Good training to take the first step towards becoming an SQL expert." - Rating: 7.7

Geert Jansen, Van Mossel Leasing - Open Learning SQL

"Training largely corresponded to the impression I had from the brochure. Excellent trainer who was clear; took into account different levels within the group and distributed the theory/exercise ratio very well." - Rating: 8.0

T. Koenraadt, AkzoNobel Decorative Paints - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"This training gives you an even better idea, what you can do with SQL and how you can apply what you have learned. Highly recommended." - Rating: 8.1

Jurgen Koopmans, Roba Metals BV - SQL Follow-up

"A good training to learn the basics of SQL and then to apply it directly in practice." - Rating: 8.9

Marianne van Oosten, Graphic Lyceum Utrecht - SQL Basics

"You get value for money. And leave with the knowledge to write your own SQL statements." - Rating: 10.0

D. Knijnsberg, Municipality of Purmerend - SQL Basics

"Followed the Report Builder training. Enthusiastic instructor, who was able to share his professional knowledge with us in a pleasant manner. During the day we could use good exercises, with excellent lesson structure. Learned a lot, optimal result with useful presentation as reference work." - Rating: 8.8

M. Sanders. GGD Brabant-Zuidoost - SQL Report Builder