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

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

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.

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

- SQL Basics

"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

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

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

N. Claessens, UWV - SQL Basics

"Good training with good material. I mastered the basics of SQL in two days. I can recommend doing some preparation beforehand to pick up the subjects better and faster. The trainer was open to questions and gave a good explanation." - Rating: 7.8

R. Richtering Blenke, ProQuro Services - 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

"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

"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

"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

"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

"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

"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

"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

"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

"The training is very instructive, where in a short time you learn the skill of questioning databases. The good atmosphere of the training stimulates creativity, making learning almost automatic. The training does not cost energy, but rather provides energy!" - Rating: 7.8

R. Schoonenberg, NL Agency - SQL Basis

"Excellent, short and yet complete basic course."

- 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

"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

"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

"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 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 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 is a very good basis, to start working with SQL immediately afterwards." - Rating: 7.8

T. Crane - 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 and then to apply it directly in practice." - Rating: 8.9

Marianne van Oosten, Graphic Lyceum Utrecht - 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

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

S. Buster, Dutch Central Bank - SQL Basics

"This training is ideal for people who are going to work with SQL databases. A lot is explained, the pace is never too slow. All kinds of queries are discussed and also the cross use of types. Highly recommended!" - Rating: 8.2

J. de Groot, Kemira - SQL Basics

"It was all explained clearly and enthusiastically. The trainer seemed to be an expert. We received sufficient attention, but we were also with a small group. The expectations were met. I achieved my learning goals. It was also a beautiful location (Amsterdam, Muziekgebouw aan 't IJ)." - Rating: 8.0

J. Hensbroek, IDS - 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

"It's a good training for filling in the gaps if you have patchy knowledge, due to on the job learning, like I did." - Rating: 8.0

Laszlo Iliasics, Mapscape 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 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

"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

"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

"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

"It is a well-constructed course, which is easy to follow even for the absolute beginner.The teacher is passionate, clear and good at answering questions." - Rating: 9.7

N. de Korte, Q-TC Nederland B.V. - 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 training. Very clear and applicable. You learn all facets of SQL." - Rating: 8.6

K. Sijne, AB Vakwerk - SQL Basics

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

- SQL Basics

"Well-orchestrated, clear explanations, sound teaching materials." - Rating: 8.4

E. van Loon, Amarant Group - 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

"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

"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

"Nice training which will be very useful if you want to start working with SQL. - Rating: 8.4

R. de Munck, Municipality of Amersfoort - SQL Basics

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

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

"Challenging, especially as it was possible to tailor the course to the level of the trainees on the spot." - Rating: 7.4

M. Veerkamp, Magna Carta - SQL Basics