Learnit Training
SQL Basis course
  • You learn to easily retrieve all data from database
  • Suitable for SQL Server, ORACLE, MS Access, PostgreSQL and MySQL databases
  • Modify, manipulate and adapt SQL data and table structures
  • Small group
  • Very experienced teacher

Do you want to change or retrieve data from a database in a simple manner? Then use SQL (Structured Query Language). Learn to work with this standardised query language.

Yes, I want to know more

"The training is extremely suitable for people who have not been in contact with SQL before. The possibilities of SQL are well and clearly explained. This is a good basic training. If you already apply SQL regularly, I recommend an advanced training." - Rating: 8.6

learnit SQL Basics

SQL Basis course

If you want to retrieve data from a relational database in a simple manner, you can use the query language SQL(Structured Query Language). In addition, SQL allows you to modify, manipulate and change table structures. SQL is widespread and is often used in combination with other programming languages such as PHP, ASP and VBA. ANSI SQL is the most popular standardised database language and is nowadays indispensable when using relational databases. ANSI SQL can be used to query MS SQL Server, ORACLE, MS Access, PostgreSQL and MySQL databases, among others. Because ANSI SQL is standardised, it can be used with almost all modern relational databases.

In our two-day SQL Basis course, you develop your knowledge and skills in the field of SQL. Under the guidance of an experienced database trainer, you actively get to work with the creation of queries. After this training, you will have mastered the basics of SQL and you will be able to easily create queries for data retrieval.

Topics

  • Introduction to SQL, basic principles: data types, keys (primary key, foreign key)
  • 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)
  • Working with sub-queries (IN)
  • Combining data from multiple tables with joining (INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN)
  • Advanced Joins (table aliases)
  • Combining queries (UNION)
  • Add data (INSERT INTO)
  • Modifying and deleting data (UPDATE, DELETE)
  • Create, modify and delete tables (CREATE, ALTER, DROP)
  • Differences in SQL between database systems

Target group

The training is intended for users of relational databases (e.g. Microsoft SQL Server, ORACLE, Microsoft Access, MySQL, Apache Open Office Base, IBM DB2, PostgreSQL, SAS and SQLite). The training is suitable for both novice database users and functional administrators and data analysts.

Training material

At the start of the training you will receive a clear book with exercises and practice files. You can also use this as a reference book after the training. Because the terminology in the software is mostly in English, the training material is too.

Prior knowledge

No previous knowledge is required for this training.

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 € 425,- € 340,-
Total, incl. VAT € 1028,50 € 822,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 Basis has been assessed with an average of 8.4.

"Without much experience in programming, I learned a lot about SQL during these two days. If you then look at the query you can make at the end of the second day, you can really see the progress you have made during those two days. The trainer paid attention to everyone and he took his time. - Rating: 8.0

J. Blaas, A.S.R. Insurance - SQL Basics

"Very easy to follow especially for people who want to start with SQL. Suitable for both IT and non-IT people. Definitely recommended!" - Rating: 7.4

M. Thakoer, NN Group N.V. - SQL Basics

"The training is extremely suitable for people who have not been in contact with SQL before. The possibilities of SQL are well and clearly explained. This is a good basic training. If you already apply SQL regularly, I recommend an advanced training." - Rating: 8.6

R. Arentsen, I-Real - SQL Basics

"Good trainer, enough training material. I achieved my initial goals." - Rating: 8.4

H. Vranac-Arapovic, Municipality of Breda - SQL Basics

"If you have an affinity with ICT but no experience with SQL, then this course is perfect for learning this." - Rating: 8.8

J. Witvoet, S.R.S. B.V. - SQL Basics

"It is a very good basis, to start working with SQL immediately afterwards." - Rating: 7.8

T. Crane - SQL Basics

"Super instructive, step-by-step structure and easy to understand for people who have no knowledge of this."

- SQL Basics

"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

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

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

- SQL Basics

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

S. Groenen, Zuidzorg - SQL Basics

"Connects very well with the step up to being able to view and use SQL. For my work, we are going to have to deal more with SQL. For this, I needed more insight into SQL from the position of functional administrator. And this has succeeded well with the professional training of Learnit Training. This is already my second Learnit training. Given the very wide range of training courses, I think it will not have been the last." - Rating: 9.0

H. van den Driesche, Evides - SQL Basics

"Recommended for people with little SQL knowledge, in 2 days the basics are in order!" - Rating: 8.4

W. de Rijke, Delta Energy B.V. - 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

"Very good training that can be applied in practice."

- SQL Basics

"A training that brings you to the next level in two days, which you can then put to use in practice. The content of the training matched my expectations very well. I have now mastered the basics of the SQL language." - Rating: 8.2

P. Willems, Zorgon B.V. - SQL Basics

"Clear explanation of SQL with many useful examples and good exercises. It was all very easy to do and after following this basic training, I have more than enough knowledge to carry out all the necessary queries on our database. And that has provided a lot of useful information. In short: excellent training! - Rating: 8.8

V. Young, Kyocera Document Solutions Netherlands B.V. - SQL Basics

"The training has given me enough handles to get started with SQL. You gain the experience in practice, but this training gives you enough solid ground under the feet." - Rating: 9.0

B. Engelhart, Achmea IM&IT - SQL Basics

"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

"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

"Excellent, short and yet complete basic course."

- SQL Basics

"This is an instructive training for both beginners and advanced students, which is given in an interactive way. This is very pleasant, because you can immediately apply it while making 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 Basics

"Very nice training and organisation, very satisfied!" - Rating: 9.0

N. Claessens, UWV - SQL Basics

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

Tejasvi Sabale, Mapscape B.V. - 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

"Excellent training, easy to follow. The content met my expectations. The knowledge transfer was very pleasant." - Rating: 9.0

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

"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 Basics

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

Paul Bakker, Randstad Nederland B.V. Headquarters - 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

"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

"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

"The trainer had a lot of experience and thorough knowledge of the content. Excellent training!" - Rating: 7.6

J. Green, Kennemerland Police - SQL Basics

"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 starting point for mastering SQL." - Rating: 7.7

Gerard Teurlinx, Mapscape B.V. - SQL Basics

"SQL is a language. The training teaches you how to read and understand this language and how to use it to tell a simple story. The location (Amsterdam, Muziekgebouw aan het IJ) was great - top location, with all necessary facilities, hospitality, a bit of the home feeling .Learnit Training met my expectations - approachable, good dialogue, no unnecessary waiting time, good information provision, clear." - Rating: 7.4

K. Gnezda Meijer, Diebold - SQL Basics

"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

"A good training to learn the basics of SQL. Many practical exercises, so that you quickly get to grips with SQL. It was supervised by a good trainer who took the time to explain things. Teaches enthusiastically. A social and friendly person. Learnit Training is a professional organisation, customer focused and has a good and fast service." - Rating: 9.8

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

"A good basic course which improved my knowledge 100%. Good learning material, calm pace and excellent assignments. Highly recommended as a basic SQL course." - Rating: 8.2

R. Wolters, DSV Venlo - SQL Basics

"A training course in an informal atmosphere, where personal contact is paramount. In this way, everyone can take in the material at his or her own pace and there is enough room to achieve your goals." - Rating: 8.2

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

"Thanks to the many exercises and the pleasant way of teaching, this training course is ideal for quickly acquiring basic SQL knowledge." - Rating: 8.8

R.C.C.F. Baijens, Kluwer - 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

"A SQL course that can be followed by everyone without any programming experience. In small groups which makes personal interaction with the trainer possible." - Rating: 8.8

S. Grootendorst, PSfm B.V. - SQL Basics

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

- SQL Basics

"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

"The training was given at a good pace and the participants were able to keep up. It was not a large group, so there was enough room for the individual. The material was in a logical order, so that by continuing the training you kept repeating the basics, which keeps them up."

- 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

"For a good SQL-basic, this is definitely a training that can be recommended. I also like the way of teaching and practice. What you learn, you immediately execute to understand it better." - Rating: 7.8

M. Amasslam, Quby B.V. - SQL Basics

"Excellent training with a lot of information realized by experienced and professional teachers. I wish it lasted longer, so I could learn even more that I did. I recommend it without any hesitation. Learnit Training is a professional company, they are doing what they promise. Their teachers are professionals who know what they are talking about." - Rating: 9.2

D. Szalobryt, Syncreon Netherlands N.V. - SQL Basics

"The trainer conveyed his knowledge well and clearly. The combination theory-practice was very pleasant!" - Rating: 8.8

P. Biermans, CompuGroup Medical (CGM) - SQL Basics