Switch to the Dutch version/Switch to the English version
  1. Home
  2. SQL Basics
  3. In-company

SQL Basics in-company

A two-day course just for your group. You choose the date and the place, and the trainer tailors the content to your practice beforehand.

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

Eerder gevolgd door medewerkers van DSV Venlo, CBS Academy, Gemeente Purmerend, Gemeente Rotterdam en anderen.

  • Tailored: matched to the level and goals of your team
  • Trainers from the field, who do the work themselves
  • At your premises, at ours or online, on a date that suits you
  • In Dutch or English, in the language of your choice
MikePascal

Your trainer: Mike or Pascal 1,851 evaluations in total, with an average of 8.5. View the trainers

What the course covers

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.

Read the full programme of SQL Basics

How an in-company course works

  1. RequestYou tell us which course it concerns, how many people and roughly when. You receive a quotation with a fixed price for the group.
  2. AlignmentWe discuss what the group can already do and what should be different afterwards. The trainer adapts the examples and exercises accordingly.
  3. The courseOn the day and at the place you chose, with course materials for every participant.
  4. AfterwardsEvery participant receives a certificate of attendance.

Practical information

Duration
Two-day course
Group
Only your own people
Location
At your office, at one of our locations or online
Date
You choose
Language
Dutch or English
Included
Course materials and a certificate of attendance
Price
Fixed price per group, in a tailored quotation (scheduled course: EUR 1100 excl. VAT per participant)

The trainers of this course

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

Mike

Web design and IT trainer 8,6 from 1098 evaluations

Pascal

ICT and communication trainer 8,3 from 753 reviews

What participants say about SQL Basics

8.4
SQL Basics course: average 8.4 from 74 reviews

“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 Venlo10.0

“Absolutely excellent, a pleasant and knowledgeable trainer. Good pace, plenty of variation between content and exercises. The course comes highly recommended!”

A. Rebergen - CBS Academy10.0

“You get value for money. And you leave with the knowledge to write your own SQL statements.”

D. Knijnsberg
Gemeente Purmerend10.0

“Excellent SQL Server course with a clear structure.”

L. Wong - Gemeente Rotterdam10.0

“I expected a basic course that covered writing queries from scratch from A to Z. The course did exactly that. A perfect match.”

C. van Lumig. Woonpunt10.0

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

M. Serrano Bascunan - Gemeente Rotterdam9.8

Frequently asked questions about SQL Basics in-company

Where does the in-company SQL Basics course take place?

Wherever suits you: at your office, at one of our training locations or online. You also choose the date.

Can the content be tailored to our organisation?

Yes. Before the course we discuss with you what the group can already do, where things go wrong in practice and what should be different afterwards. The trainer uses examples and exercises from your own work.

How large can the group be?

That depends on the course. For a skills course we prefer to work with a small group, so that everyone can really practise. If more people are involved, we schedule several groups or set up a fixed programme.

What does SQL Basics in-company cost?

You receive a fixed price for the whole group, in a tailored quote. For a group this works out cheaper than booking everyone individually. By way of comparison: a place on the scheduled course costs € 1100,- excl. VAT per participant.

Can the course be delivered in English?

Yes. For in-company courses we deliver the training in the language of your choice, Dutch or English. Mention it in your request.

Do participants receive a certificate?

Yes, every participant receives a certificate of attendance afterwards.

How do I request a quote?

Via the quote form: state the course, the number of participants and roughly where and when you would like it. An adviser will then contact you.

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.

SQL Basics for your team?

Request a quotation without obligation and an adviser will get back to you soon. Coming with one or two colleagues? SQL Basics is scheduled 13 times over the coming year, in Amsterdam, The Hague, Utrecht, Rotterdam, Eindhoven, Arnhem, Groningen and Zwolle.

Request a quote View the scheduled dates
Private groupfixed price, tailored quotation
Request a quote