SQL Basics course

In this SQL Basics course you learn to work with relational databases, write queries and filter, sort and edit data under the guidance of an experienced trainer.

8.4 from 74 reviews 4,6 on Google NRTO quality mark

Free cancellation up to four weeks before the start, so feel free to book now.

For a team or department? Arrange your own group, at your premises or ours. In-company for your team

In brief. SQL Basics is a classroom course lasting 2 days. You can take it in Amsterdam, The Hague, Utrecht and Rotterdam, among other locations, or online, in a group of no more than 8 participants. The price is € 1100,- excl. VAT per participant, including course materials, lunch on location and a certificate of attendance. For a team or department we also run this course in-company.

  • Start writing SQL queries straight away
  • Plenty of practice with real-life examples
  • An experienced database trainer as your guide
  • Useful reference material for later use
  • A solid foundation for data analysis
MikePascal

Your trainer: Mike or Pascal 1,852 evaluations in total, averaging 8.5. View the trainers

In this course you work under the guidance of an experienced trainer on building a solid foundation in SQL. You learn how relational databases work and write your own queries to retrieve, filter and edit data. Practical and directly applicable.

Description

In the SQL Basics course you learn to work with SQL under the guidance of an experienced database trainer. On the first day you become acquainted with various database systems and gain insight into the background and basic principles of SQL. You practise with simple queries to retrieve, sort, filter and group data.

On the second day you go into more advanced queries. You work with functions, calculations, subqueries and joins, and you learn how to add, modify and delete data. You are also introduced to creating and managing tables.

Thanks to the mix of theory, practical examples, demos and plenty of practice exercises, you will quickly master the most important functions of SQL. The course is practically oriented and useful for the most common relational database systems.

For teams and organisations. If several colleagues are learning SQL, we can also run the course in-company. We can agree to use examples that match your own data.

Topics

In this time you will master the basics of SQL. You will work on the following topics:

Day 1. Introduction to databases, SQL and simple queries

  • Introduction to databases: flat, hierarchical and relational
  • Different database systems (DBMS) and differences in SQL dialects
  • Data types and keys (primary key, foreign key)
  • Retrieving data (SELECT FROM, TOP, DISTINCT)
  • Sorting data (ORDER BY)
  • Grouping data (GROUP BY, HAVING)
  • Filtering data (WHERE, comparison operators, BETWEEN)
  • Filtering with wildcards (LIKE)

Day 2. More advanced SQL queries

  • Editing data with functions (ROUND, LTRIM, RTRIM, DATEPART)
  • Performing calculations (COUNT, SUM, AVG, MAX, MIN)
  • Working with subqueries (AND, OR, IN, NOT IN)
  • Combining tables (INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN)
  • Adding data (INSERT INTO)
  • Modifying and deleting data (UPDATE, DELETE)
  • Creating, modifying and deleting tables (CREATE, ALTER, DROP)

Result

After the SQL Basics course:

you understand the importance and benefits of good data management, you understand how a database system works and can name the most commonly used DBMSs, you know the basic concepts of SQL, you can run simple queries in an SQL database, you add more value to data by carrying out simple data manipulations, and you increase your employability, for example as a data analyst, database administrator, database developer or programmer.

Target audience

Do you work with data, or would you like to? Then this SQL Basics course is for you. The course is suitable for anyone who wants to work with relational databases, such as Microsoft SQL Server, Oracle, MySQL, PostgreSQL, MariaDB, IBM Db2 or SQLite.

Functions such as:

data analyst, functional administrator, database administrator, information manager, system administrator, junior database developer, programmer.

You do not need any prior knowledge of SQL or databases. A little affinity with data and logical thinking is enough to keep up.

Outside IT, too, more and more people need SQL, such as controllers, marketers and analysts who want to pull data from a database themselves. This course is suitable for them as well.

Teaching method

The SQL Basics course is given by an experienced database trainer. You work in a small group, so there is plenty of room for personal attention and questions from your own practice.

The teaching method alternates theory, demonstrations and, above all, plenty of practical exercises. This way you quickly master the most important functions of SQL. On the first day you get to know database systems and practise with simple SQL queries. After that you go into more depth with more advanced queries, functions and combining tables.

During the course you will receive an English-language book with exercises and exercise files. You use this book during the course and afterwards as a reference work at your workplace.

Prior knowledge

You don't need any specific prior knowledge for this course. Can you work with a computer and are you interested in databases and data? Then you can simply join. We build everything up from the basics, so that you get a good grasp of the material.

Comments


Practical information

Number of days
2 days
Course times
from 10 am to 5 pm
Teaching hours
12 hours
Education level
Suitable for all levels
Preparation time
None
Included
Course materials and lunch on site
Certificate
At the end of the course you will receive a certificate of attendance
Cancel
Free up to four weeks before the start (cancellation terms)

Language

The course is given in Dutch as standard. The trainer speaks English. English-language course materials can be used. If at least 3 participants register, the course can also be given entirely in English.

In-company

Would you like to organise this training for a whole group or several groups? This can be cost-effective. For example, we can tailor the content entirely to your organisation, and training a whole group is also cheaper.

Are you looking at large numbers of participants or a complete academy? That involves a great deal. Consider planning and communication, for example, or identifying and agreeing the objectives and content of the training. Or differences in level, feedback mechanisms and safeguarding. Fortunately, Learnit has extensive experience in this field (more than 25 years) and we are happy to help you through this process.

Request a quote More about SQL Basics in-company

All start dates

2 training days. Confirmed dates first, then in order of date.

  • Mon 19 & Tue 20 October 2026Certain to go ahead Eindhoven · 10:00–17:00 Enrol
  • Mon 9 & Tue 10 November 2026Certain to go ahead The Hague · 10:00–17:00Free cancellation until 12 October Enrol
  • Thu 19 & Fri 20 November 2026 Amsterdam · 10:00–17:00Free cancellation until 22 October Enrol
  • Tue 22 & Wed 23 December 2026 Eindhoven · 10:00–17:00Free cancellation until 24 November Enrol
  • Tue 16 & Wed 17 March 2027 Arnhem · 10:00–17:00Free cancellation until 16 February Enrol
  • Tue 30 & Wed 31 March 2027 Groningen · 10:00–17:00Free cancellation until 2 March Enrol
  • Tue 30 & Wed 31 March 2027 Zwolle · 10:00–17:00Free cancellation until 2 March Enrol
  • Thu 3 & Fri 4 June 2027 Utrecht · 10:00–17:00Free cancellation until 6 May Enrol
  • Mon 2 & Tue 3 August 2027 Rotterdam · 10:00–17:00Free cancellation until 5 July Enrol

No suitable start date? Send us a date request, and we'll look at the options together.

This course for your team?

Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.

  • Your date and location
  • Tailored content
  • Multiple groups or an academy are also possible
  • More than 25 years' experience
Request a quote No obligation, an adviser will be in touch shortly How in-company works

The trainers for this course

Ratings from participants after completing their course, across all courses by this trainer.

What others say about this course

8.4
SQL Basics course: average 8.4 from 74 reviews

“It was a demanding course, covering an enormous amount in two days. It was a thoroughly enjoyable course!”

P. Janssen
Ministerie van Defensie
7.8

“Clear explanations and good exercises gave a good picture of what SQL can do.”

M. Bessem
Regiopolitie Amsterdam Amstelland
8.0

“Good starting point for mastering SQL.”

Gerard Teurlinx
Mapscape B.V.
7.7

“Definitely recommended if you work with SQL. I learned useful things in this training course that I was not previously aware of.”

A. Puijn
DSV Venlo
10.0

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

Participant

“This is an excellent programme for learning the basics of SQL!”

M. Serrano Bascunan - Gemeente Rotterdam9.8

Training formats

Classroom

2 days€ 1100,-
  • Pleasant venue with a good trainer
  • Small groups
  • Inspiring and motivating
Choose a date

Online

2 days€ 930,-
  • Online with a trainer
  • Personal
  • Practical and interactive
Choose a date

In-company

Bespoke trainingOn request
  • 100% for your group
  • Bespoke training
  • At your place or ours
View in-company

Workshop

Up to 4 hours for groupsOn request
  • Suitable for events
  • Interactive and inspiring
  • Large groups too
Request a quote

Private training

At our place or yoursOn request
  • 100% just for you
  • Achieve a lot in little time
  • Whenever you want
Request a quote

Frequently asked questions

Can I cancel free of charge?

Yes. Up to four weeks before the first day of the course you can cancel free of charge, without giving a reason. You then receive a credit note or, if you have already paid, a refund. If you cancel later, you pay part of the course fee: 25% between four and two weeks before the start, 75% in the two weeks before it and 100% in the final week. Moving to another start date is free of charge up to two weeks before the start, after that 50%. Sending a colleague in your place is always possible. Read the cancellation terms.

What prior knowledge do you need for the SQL Basics course?
For the SQL Basics course you do not need any specific prior knowledge of SQL or databases. Basic computer skills are sufficient. The course starts at the beginning: you first learn how relational databases work and then build up your SQL skills step by step. The course is therefore suitable both for beginners and for professionals who want to formalise their knowledge.
Which topics does the SQL Basics course cover?
The SQL Basics course covers the most important SQL topics in . Day 1: database systems, data types, keys and simple queries using SELECT, ORDER BY, GROUP BY, WHERE and LIKE. Day 2: more advanced queries with functions (ROUND, DATEPART), calculations (COUNT, SUM, AVG), subqueries, JOINs (INNER, LEFT, RIGHT) and modifying data and tables with INSERT, UPDATE, DELETE, CREATE, ALTER and DROP.
Which database systems will you learn to use in the SQL Basics course?
In the SQL Basics course you learn to work with all common relational database systems, including Microsoft SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2 and SQLite. The course covers the standard SQL language and the differences between the various DBMSs. As a result, after classroom training you can get straight to work with virtually any SQL database you come across in your workplace.
Who is the SQL Basics course suitable for?
The SQL Basics course is suitable for anyone who wants to learn to work with relational databases, without needing any prior knowledge of SQL. Think of functional administrators, data analysts, information managers, system administrators, aspiring database developers and programmers. This classroom course is also a good fit if your work increasingly requires you to retrieve data from a database.
Do you receive a certificate after the SQL Basics course?
Yes, on completion of the SQL Basics course you receive a certificate of participation. This certificate shows that you have attended the classroom course and have mastered the basics of SQL, including writing SELECT queries, filtering with WHERE, sorting, grouping and combining tables with JOINs. A useful piece of evidence for your CV or LinkedIn profile.
What is the difference between the classroom SQL Basics course at Learnit and an online SQL course or self-study via YouTube?
The classroom SQL Basics course You work under the guidance of an experienced database trainer and practise with assignments that you can link to your own daily work. That last point is the biggest difference with self-study via YouTube or an online course: you get direct feedback on your queries and can ask questions about your specific database situation. In you cover both the basics (SELECT, WHERE, ORDER BY, GROUP BY) and more advanced topics (JOINS, subqueries, INSERT, UPDATE, DELETE, CREATE). With self-study you are more inclined to click through without really practising. Choose the classroom option if you want to learn in a structured way and become productive quickly; choose self-study if your budget is limited and you are able to keep going in a disciplined way.
How quickly after the SQL Basics course can I write queries independently in practice?
Straight after the course you will be able to write simple to medium-sized SQL queries. On day 1 you practise with SELECT, WHERE, ORDER BY, GROUP BY and filtering with wildcards. On day 2 you work with JOINs, subqueries, aggregate functions (COUNT, SUM, AVG) and modifying data using INSERT, UPDATE and DELETE. The mix of theory, demonstrations and plenty of practice exercises with sample files means the material sinks in quickly. How soon you can apply it in your own working environment depends on the database system (Microsoft SQL Server, MySQL, PostgreSQL, Oracle) and the complexity of your data model. Most participants are writing their own reporting queries within a week. For more complex matters such as stored procedures or performance tuning you will need a follow-up course; this is a basic course.
Which SQL dialects do I learn during the SQL Basics course, and is that knowledge usable in PostgreSQL or MySQL, for example?
The SQL Basics course covers standard SQL: the syntax and functions that work in virtually all relational database systems. Think of SELECT, WHERE, GROUP BY, JOIN, INSERT, UPDATE, DELETE and CREATE. That knowledge is directly applicable in Microsoft SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2, Microsoft Access and SQLite. The trainer explicitly points out the differences between the dialects, so that you know what to look out for when moving between systems. Functions such as ROUND, LTRIM, RTRIM and DATEPART are covered; the exact name may differ slightly per DBMS (for example EXTRACT in PostgreSQL instead of DATEPART). The course material is in English, as is the software. After the course you will be able to get started with basic queries in any common DBMS.
What do I get in the SQL Basics course that I won't learn from an online SQL tutorial?
In the classroom SQL Basics course at Learnit you get three things an online tutorial doesn't offer. First, direct feedback from an experienced database trainer on your queries, including an explanation of why a JOIN or WHERE clause could be written differently. Second, exercises linked to your own practical examples, so that the material matches the type of data you work with every day. Third, a fixed structure in which, in a small group, you work through all basic and more advanced topics from start to finish, from SELECT and WHERE to INNER JOIN, subqueries and INSERT/UPDATE/DELETE. You receive a reference work with exercises and practice files. A tutorial is free, but you miss the alignment with your context and the opportunity to ask questions.
Is the SQL Basics course also useful if I will mainly be working with data analysis tools such as Power BI or Python?
Yes. SQL underpins almost every data analysis workflow, including when you later work with Power BI, Tableau or Python (pandas). In Power BI you retrieve data from databases using SQL queries, and in Python you use SQL to load data from a database into a DataFrame. The SQL Basics course teaches you how to build SELECT statements, filters (WHERE), groupings (GROUP BY) and joins (INNER JOIN, LEFT OUTER JOIN). You can apply that knowledge directly in other tools. Many data analysts find that SQL lets them retrieve data more efficiently than a visual query builder or an export to Excel. The course is taught in a classroom setting.
When should you choose the classroom-based SQL Basics course and when does an in-company programme or follow-up course make more sense?
The classroom-based SQL Basics course at Learnit is the right choice if you are enrolling individually, have no SQL experience yet and want to lay the groundwork. You will learn SELECT queries, filtering, grouping, joins and simple data manipulation with INSERT, UPDATE and DELETE. An in-company programme makes more sense when you want to learn together with a team of at least 4 to 6 colleagues, or if you want to practise on your own company database and data model. Do you already have the basics under control and are you working with window functions, complex subqueries or performance tuning? Then a follow-up SQL course is a better fit than a repeat of the basics. If you are unsure about your level, a short intake will help you start in the right variant.
How much does the SQL Basics course cost and how long does the course last?

You can find the current price at the top right of this course page, along with the schedule, location and delivery format. For in-company or bespoke courses we are happy to provide a quotation on request.

Mon 19 & Tue 20 October 2026 in Eindhoven

This date already has enough participants. Free cancellation up to four weeks before the start, so you can secure a place now.

€ 1100,-excl. VAT · confirmed on Mon 19 Oct
Choose a date