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

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

learnit SQL Basic

Course SQL Sequel

For data retrieval, database systems often use the SQL language. One of the most widely used database systems for the professional user is MS SQL Server. For this system, even additional SQL commands are created in the form of T (ransact)-SQL. For example, T-SQL provides the ability to extend the query with local variables and procedural programming. The latter include logical tests such as if.. ELSE.. Or WHILE.. to the commands. In addition, there are certain usual commands that in T-SQL have an ' upgrade ' to improve functionality and therefore use.

In our two-day training SQL sequel, after repeating the most common concepts, we delve deeper into the capabilities that SQL and T-SQL provide to create queries to retrieve the necessary data from the database. At the end of the training you will be able to use the T-SQL unique possibilities as variables, transactions and procedural programming.

Topics

  • Repeat base SQL:
  • Retrieving data (SELECT FROM, TOP, DISTINCT)
  • Sort data (ORDER BY)
  • Filter data (WHERE, comparison operators, BETWEEN)
  • Advanced Filters (AND, OR, IN NOT)
  • Filter using wildcards (LIKE)
  • Calculated fields (Concateneren)
  • Customizing data with Functions (ROUND, LTRIM, RTRIM, DATE PART)
  • Summarize data (COUNT, SUM, AVG, MAX, MIN)
  • Grouping data (GROUP BY, HAVING)

  • Query data from multiple tables with joins (INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER join, Composite JOIN, Non-equi JOIN)
  • Use subqueries (e.g. search versus previous order, running aggregate)
  • Using Table expressions (derived tables, alias, variables, WITH)
  • Combine 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 simultaneous use (START, ROLLBACK, COMMIT, READ UNCOMMITTED, READ COMMITTED)
  • Programmable objects (variables, batch, IF, ELSE, WHILE, cursors, procedures, triggers)

Target

The training is intended for Microsoft SQL Server users. The training is suitable for database users who already reasonably manage the basic SQL and now want to get more from MS SQL Server, but also for functional administrators and data analysts, who have unique functions of T-SQL as variables, procedural programming and Want to learn to use transactions.

Language

The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.

Investment

Mentioned prices are per person, including course material. Lunch is included in the training on location.

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

Certificate

After completing the training, a LEARNIT certificate will be issued as proof of participation.


Online

We also organize this training online. For this we use Webbex or Zoom. Logging in with Skype is also possible. On request this training can also be organized with Microsoft Teams.

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

  • Until one year after the training you can participate for free.
  • Against payment of the catering costs you can also participate in a classroom training.

References

The SQL Continuation course has been evaluated with an average of 8.

"This training is a fine refresher for the SQL basics, but also a fine sequel with many useful techniques. The pace is nice. I've been able to bring a lot I can apply in my work."

- SQL Continued

"Interesting and practical training. Trainer quickly switched to given feedback, making it even more of a customized training! - Assessment: 7.5

Marjolein Smits, Advanced Programs - SQL Continued

"If the preparations are good and tailored to the organization (type/type) of the client, this can be an excellent course for most essential SQL statements". - Review: 6.7

John van Enst, Municipality of Groningen - SQL Continued

"Very well organized training with room for own input." - Assessment: 8.3

Jordy de Groot, Advanced Programs - SQL Continued

"This training gives you an even better picture, what you can do with SQL and how you can apply what you have learned. Recommended." - Assessment: 8.1

Jurgen Koopmans, Roba Metals BV - SQL Continued

"Good training to take the first step towards SQL connoisseur." - Review: 7.7

Geert Jansen, Van Mossel Leasing - Open Learning Form SQL

"The contents met my expectations. Gaining basic knowledge of SQL. The trainer had a lot of knowledge and also gave a lot of good tips". - Assessment: 8.4

W. Cook, Rolec - Oracle Database 10g: SQL foundations part I

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

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

"Good training with which you can do a lot in practice." - Assessment: 8.2

R. Doctor, AM Group - SQL Base

"A training in an informal atmosphere, where personal contact is paramount. In this way, everyone can take in the dust at their own pace and there is enough room to achieve your goals". - Assessment: 8.2

J. Koopmans, Roba Mentals B.V. - SQL Base

"The training is very instructive, in which you learn the skill to query databases in a short period of time. The good atmosphere of the training stimulates the creativity, which makes learning almost self-evident. The training doesn't cost energy, but provides energy". - Review: 7.8

R. Schoonenberg, Agency EN - SQL Base

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

K. Sijne, AB Vakwerk - SQL Base

"Effective training from an experienced trainer with ample knowledge. The trainer was able to switch quickly between people and also focused on the people who needed it without forgetting the others". - Rating: 8.0

J. Heijmink, Norbert Dentressangle - SQL Base

"Thickly satisfied with the content, got a good explanation of the differences between SQLSERVER 2008 and 2012. The trainer was able to empathize with our problems/questions. He knows what he's talking about and he knows how to point out the differences and pros and cons." - Assessment: 8.2

J. Kok, Medical Centre Haaglanden - Administration Microsoft SQL Server 2012 Databases

"The training is very instructive, in which you learn the skill to query databases in a short period of time. The good atmosphere of the training stimulates the creativity, which makes learning almost self-evident. The training doesn't cost energy, but provides energy". - Review: 7.8

R. Schoonenberg, Agency EN - SQL Base

"A good basic course in which my knowledge has improved 100%. Good subject matter, quiet pace and excellent assignments. Highly recommended as a basic SQL course." - Assessment: 8.2

R. Wolters, DSV Venlo - SQL Base

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

- SQL Basis

"Great 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 Base

"Practical course in which a user/information analyst quickly learns how to unlock (relational) databases using the basic principles of SQL". - Assessment: 8.1

Arthur Wagenaar - Open Learning Form SQL

"Both for beginner and advanced, this is an instructive training, which is given in an interactive way. This is very pleasant, because you can apply it immediately while doing the exercises that are given during the training. You always have the opportunity to ask questions and the guidance is also good. So all in all a very good experience with the SQL basic training of Learnit Training"! - Rating: 8.0

G. Romkens, CompuGroup Medical (CGM) - SQL Base

"It was a tough workout, where a lot was treated in two days. It was a great training!" - Review: 7.8

P. Janssen, Ministry of Defence - SQL Base

"I'm positive. I don't feel like I'm getting lost in other people's queries. For my job it is not a requirement to make queries, but it is a requirement to make a small adjustment every now and then to generate output". - Assessment: 7.4

J. van de Putte, CIBG - SQL Base

"Nice basic training, perfect location (Amsterdam, Muziekgebouw aan 't IJ)." - Assessment: 7.4

S. Buster, The Dutch Central Bank - SQL Base

"Interesting and practical training. Trainer quickly switched to given feedback, making it even more of a customized training! - Assessment: 7.5

Marjolein Smits, Advanced Programs - SQL Continued

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

R. Uters, Efteling - SQL Base

"Nice and very applicable training, you can really use it and you can put it into practice right away. Highly recommended." - Rating: 8.0

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

"This basic training met my expectations. The teacher was knowledgeable and relaxed, with sufficient individual attention if necessary". - Assessment: 8.2

A. Arkeraats, ANWB - Transact-SQL Basics - MS SQL Server

"My main learning goal was to be able to read and understand queries/scripts better. By writing your own scripts and getting acquainted with a number of possibilities of SQL, this learning objective was certainly achieved. By practicing some scripts yourself, you get some insight and a principle. You have to do something with them yourself and practise at work or at home. Then the dexterity will certainly come". - Review: 7.6

Han Bennink, AFAS Software B.V. - Open Learning Form SQL

"Good clear training, really for building reports for beginners." - Rating: 9.0

D. Hoekstra, NLO - SQL Report Builder

"Briefly and clearly. Lestempo good and to follow. Practical exercises instead of theoretical assignments. The trainer had attention for everyone. Personal and always asking if the material is still understandable. Expert enough and honest about their own knowledge. Learnit Training is professional and service-oriented". - Review: 7.6

T.M. Mingoen, Cobalt - MS SQL Server 2005 Querying

"Got a nice explanation of all the basic principles within SQL and its various dialects. Also highly recommended as a refresher course". - Review: 8.9

Erwin Fox, OFGV - Open Learning Form SQL

"Definitely recommended if you work with SQL. Techniques not previously known to me I learned during this training." - Rating: 10.0

A. Puijn, DSV Venlo - SQL Base

"Learnit is a professional organization with a personal approach. The SQL course was well attuned to the entry level and the instructor skilfully and with great pleasure guided us through the material. Class!" - Review: 8.7

Shanna Wielinga, UWV Customer expertise - Querying Microsoft SQL Server (MOC20461)

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

- SQL Basis

"Got refreshed with my sql skils" - Rating: 6.0

Tejasvi Sabale, Mapscape B.V. - SQL Base

"Very good course for beginners, but also a refresher for the more experienced." - Rating: 8.6

Monique van de Wetering, Greenspans B.V. - Open Learning Form SQL

"Good balance between listening and practicing. After this course you'll have a good basis to get started." - Rating: 8.0

Peter Berkhout, UWV customer expertise - Querying Microsoft SQL Server (MOC20461)

"You will learn the basics of SQL in a simple way during this training. The exercise fits well with the lesson material." - Rating: 8.6

Wouter Louet, Municipality of Utrecht - Open Learning Form SQL

"Good training. Good to follow. The content met my expectations. The transfer of knowledge took place in a very pleasant manner." - Rating: 9.0

Ton van der Velden, Rijkswaterstaat (RWS) - SQL Base

"The training exceeded my expectations, highly recommended. The trainer had a lot of knowledge."

- SQL Report Builder

"Theory and practice (doing exercises yourself) in the right distribution. Very good training. Professional trainer. Pace of the training is right." - Review: 8.8

C. Bogaards, T-Mobile - SQL Base

"Briefly and clearly. Lestempo good and to follow. Practical exercises instead of theoretical assignments. The trainer had attention for everyone. Personal and always asking if the material is still understandable. Expert enough and honest about their own knowledge. Learnit Training is professional and service-oriented". - Review: 7.6

T.M. Mingoen, Cobalt - MS SQL Server 2005 Querying

"It was all explained clearly and enthusiastically. The trainer came across as an expert. We got enough attention, but we were also with a small club. Satisfied expectations. I've achieved my learning goals. It was also a beautiful location (Amsterdam, Muziekgebouw aan 't IJ)". - Rating: 8.0

J. Hensbroek, IDS - SQL Base

"Great training for beginners who already have a little bit of experience with SQL, the type of SQL you use yourself is reasonably taken into account (indicate this to the organization in advance, then you may receive a different textbook). In the training, it really stays with the basics." - Assessment: 7.3

Kelly de Kuyper, Pluriplus / Pluripharm - SQL Base

"A good training to learn the basics of SQL. Lots of practical exercises, so you can quickly get to grips with SQL. It was under the guidance of a good trainer who took the time to explain things. Teaches enthusiastically. A social and friendly person. Learnit Training is a professional organization, customer-oriented and has a good and fast service". - Rating: 9.8

C. Verkleij, Central Bureau of Statistics (CBS) - SQL Base

"Great course to start as a layman. You will first get acquainted with the software package after which you will immediately get to work on small assignments. allowing me to create small databases and reports." - Assessment: 7.4

J. Kramer, HC Group - SQL Report Builder

"The content of the course is fine, you get a clear picture of the applicability of the material within your own organisation. Nice exercises and a great teacher who knows how to teach in an inspiring way."

- SQL Basics - Oracle

"Excellent training for basic queries. A clear book with good examples and good structure, the trainer is very skilled. Kept the attention by his way of explaining. Clarifying explanation." - Assessment: 8.2

Anonymous - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

"A 2-day training that met my expectations and enabled me to successfully apply what I learned in daily practice. By alternating theory and practice, the knowledgeable trainer was able to keep the training lively and captivate our mixed company until the end. This in a good location with excellent course material for this training". - Assessment: 8.4

Charles Slierendrecht, Municipality of Maastricht - Open Learning Form SQL

"Good starting point for mastering SQL." - Review: 7.7

Gerard Teurlinx, Mapscape B.V. - SQL Base