Learnit Training
Course Structured query language
  • You learn to easily retrieve all data from the 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

Would you like to easily modify or retrieve data from a database? Then use SQL (Structured Query Language). Also learn how to work with this standardized query language.

Yes, I want to know more

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

learnit SQL Basic

Course Structured query language

If you want to easily retrieve data from a relational database, you can use SQL (structured Querylanguage). In addition, you can modify, manipulate, and modify table structures with SQL data. 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 standardized database language and is now no longer to be thought of when using relational databases. ANSI SQL can be used for querying MS SQL Server, ORACLE, MS Access, PostgreSQL and MySQL databases. Because ANSI SQL is standardized, it can be used with almost all modern relational databases.

In our two-day training SQL Base you will develop knowledge and skills in the FIELD of SQL. Under the guidance of an experienced database trainer, you will actively get to work on creating queries. After this training you have mastered the basics of SQL and can easily create queries to retrieve data.

Topics

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

Target

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

Training materials

You will receive a clear book with exercises and practice files at the start of the training. This can also be used as a reference book after the training. Because the terminology in the software is mostly English, the training material is also.

Prior knowledge

No prior knowledge is required for this training.

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

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

Marianne van Oosten, Graphic Lyceum Utrecht - SQL Base

"Very good workout. In two days there is a lot of treatment, but this goes at a pleasant pace. Good alternation of theory and doing exercises yourself. Great trainer, has a lot of knowledge of the material and can convey this clearly and in a pleasant way". - Rating: 9.0

T. Wolfs, NUON - SQL Base

"This trainer is a very knowledgeable person who communicates the material of the training to the participants in a calm, well-considered and thorough way.

- SQL Basis

"The SQL training provides insight into creating queries from databases. During the lessons you will learn how to build a query. During the lessons the theory is first discussed and then carried out with a practical assignment. This is very fun and educational." - Rating: 9.0

G.J. Leferink, Elementis Delden - SQL Base

"Fine, short and yet complete basics course."

- SQL Basis

"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

"Had good training with good material. Got the basics of SQL well mastered in two days, it may be advisable to do something to prepare in advance to tackle the topics better and faster. The trainer was open to questions and gave a good explanation". - Review: 7.8

R. Direction Blenke, ProQuro Services - SQL Base

"Basic hands-on training. So you go straight to work with what you've learned. Some foreknowledge is useful" - Review: 7.7

Daniëlle van Dijk, TimeTell B.V. - 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

"For a good SQL base, this is definitely a training course that is recommended. I also like the way of teaching and practice. What you learn you do immediately to understand it better". - Review: 7.8

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

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

K. Sijne, AB Vakwerk - 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

"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

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

- SQL Basis

"Practically applicable in my own work organization." - Assessment: 8.4

S. Greens, Zuidzorg - SQL Base

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

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

"A training that will bring you up to a level within two days, with which you will then be able to work in practice yourself. The content of the training fitted in very well with my expectations. I've now mastered the basics of the SQL language." - Assessment: 8.2

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

"Without much programming experience, I learned a lot from SQL these two days. If you then look at what query you can make at the end of the second day, you'll actually see the progress you've made during those two days. The trainer paid attention to everyone and he took plenty of time for that". - Rating: 8.0

J. Blow, A.S.R. Insurances - SQL Base

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

"Challenging, especially since it was possible to tune in to the level of the students on the spot." - Assessment: 7.4

M. Spring Camp, Magna Carta - 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

"Recommended for people with little SQL-knowledge, in 2 days the base is fine!" - Assessment: 8.4

W. de Rijke, Delta Energy B.V. - SQL Base

"Properly orchestrated, clear explanations, sound teaching material." - Assessment: 8.4

E. van Loon, Amaranth Group - SQL Base

"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

"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

"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

"Clear explanation of SQL with lots of useful examples and good exercises. It was all good to do and after attending this basic training I gained more than enough knowledge to perform all necessary queries on our database. And that yielded a lot of useful information. In short: Excellent training! - Review: 8.8

V. Young, Kyocera Document Solutions Nederland B.V. - 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

"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

"The training is ideal for people who have never 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 advanced training." - Rating: 8.6

R. Arentsen, I-Real - SQL Base

"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

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

D. Knijnsberg, Municipality of Purmerend - SQL Base

"E. van Herijnen - "Positive impression. Good location, training, exercise material and applicability in practice." - Rating: 7.2"

- SQL Basis

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

P. Anuels, Praclox - SQL Base

"This basic training gives a good overview of what SQL is and what you can do with it. Using a logical structure, you can move from a very simple query to a very sophisticated in-depth query in two days."

- SQL Basis

"I expected basic training that covered writing queries 'from scratch' from A to Z. The training did exactly that. A perfect match." - Rating: 10.0

C. van Lumig. Residence point - SQL Base

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

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

"Thanks to the amount of practice and the pleasant way of teaching, this training is extremely suitable for quickly acquiring basic knowledge of SQL". - Review: 8.8

R.C.C.F. Baijens, Kluwer - SQL Base

"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

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

Gerard Teurlinx, Mapscape B.V. - SQL Base

"Connect very well to the step to being able to see and use SQL. For my work, we're going to have more to do with SQL. For this I needed more insight into SQL from the function of functional administrator. And this has worked out well with the professional training of Learnit Training. This is already my second Learnit training. Given the very wide range of training, I think it will not have been the last". - Rating: 9.0

H. van den Driesche, Evides - SQL Base

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

- SQL Basis

"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

"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

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

B. Willemse. Capter - SQL Base

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

- SQL Basis

"Do you have an affinity with ICT, but no experience with SQL yet, then this course is perfect to learn this". - Review: 8.8

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

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

N. Claessens, UWV - SQL Base

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

Tejasvi Sabale, Mapscape B.V. - SQL Base

"It's a well-constructed course, which is good 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 Base