In the SQL Basics for Oracle course you learn to work with SQL Developer. You write queries, filter data, combine tables and edit data in Oracle databases.
Free cancellation up to four weeks before the start, so feel free to book now.
In brief. SQL Basics - Oracle is a classroom-based course lasting 2 days. You can attend it in Amsterdam, Utrecht, The Hague and Rotterdam, among other locations, or online, in a group of up to 8 participants. The price is EUR 1100 excl. VAT per participant, including course materials, lunch on site and a certificate of attendance. We also run this course for teams or departments in-company.

Your trainer: Mike 1.114 evaluations in total, averaging 8,6. View the trainers
With SQL you can retrieve information from an Oracle database at high speed. You learn how to query, filter, combine and edit data, and how to derive well-founded insights from it.
Companies are collecting more and more data, but without the right query language that data remains unused. Oracle is one of the most widely used database systems in the world, and SQL is the language you use to extract information from it. During this course you will learn how to combine the two.
You start with the basic principles: data types, keys and simple SELECT queries in Oracle SQL Developer. You then build on this with filters, sorting, calculations and functions. On day two you get to work with joins, subqueries and modifying data and tables.
The trainer alternates theory with demonstrations and plenty of practical exercises. You work at your own pace and can raise questions from your own practice. That way you leave with a working toolkit.
For teams and organisations. If your department works with the same Oracle database, we also offer this course in-company. In consultation with you, we work with examples from your own practice, so that the practice queries match the questions the team asks of the data.
Day 1: Introduction to SQL and simple queries
Day 2: Advanced queries in Oracle
After this course you will understand how an Oracle database is structured and you will be able to write queries independently to retrieve, filter, combine and edit data. You will know how to merge data from several tables using joins, how to apply subqueries and how to modify tables with INSERT, UPDATE and DELETE. This allows you to turn data into usable information more quickly in your work as an application manager, data analyst, developer or DBA.
This course is intended for anyone starting out with Oracle databases who wants to learn to write queries themselves. Think of application managers, novice Oracle SQL developers, database administrators, BI professionals, data analysts and software developers who want to support their work with SQL.
The course is also suitable for application managers, controllers and reporting staff who want to retrieve data from an Oracle database themselves instead of waiting for an export or a colleague from IT.
You work in a small group under the guidance of an experienced database trainer. Theory alternates with demonstrations and plenty of practical exercises in a real Oracle environment. Beforehand you receive a workbook with practice cases, which you can then use as a reference work. The course materials and the software are in English.
No prior knowledge of SQL or Oracle is required. Basic computer experience and logical thinking are enough to follow the course successfully.
Would you prefer a platform-independent SQL basics course? Then take our SQL basics. Are you looking for a basic SQL course aimed specifically at Microsoft SQL Server? Then register for our course Transact-SQL Basics - MS SQL Server.
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.
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.
2 training days. In order of date.
No suitable start date? Send us a date request, and we'll look at the options together.
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.
Ratings from participants after completing their course, across all courses by this trainer.
"A good basic course. Topics are explained step by step, after which participants practise for themselves with a number of short exercises. Because the trainer walks around and looks on, you get immediate feedback."
“Very good course. Excellent trainer”
"The content of the course is very good; you get a clear picture of how the material can be applied within your own organisation. Enjoyable exercises and an excellent trainer who teaches in an inspiring way."
“Excellent course with plenty of depth added to the basic material by a professional trainer.”
“Good course with a good progression from the basics to somewhat more complex content spread over two training days. I found it a very useful course and it is good that we also have reference material in the form of a course book and access to the website with the material from the book and practical exercises including answers.”
“The SQL training course was a welcome one. Thanks to this course I can move on with a better understanding of ORACLE SQL. The two course days we enjoyed were really very instructive.”
“SQL Basics Oracle is a course I can recommend with complete confidence. Its practical applicability is very high!”
“You learn the basic commands for querying a database and combining tables. This tied in perfectly with the issues I come across in my daily work. I was lucky to be in a class where everyone took part with the same goals. As a result the pace was high and you didn't have to wait for other participants. It is a requirement to have some knowledge of application management and database querying, so that you can translate the content straight into daily practice.”
“Very well organised course with room for your own input.”
“A good basics course in which my knowledge improved by 100%. Good material, a steady pace and excellent exercises. Recommended as an SQL basics course.”
“Enjoyable and highly applicable course; you really get something out of it and you can put it into practice straight away. Highly recommended.”
“Good balance between presentation and doing exercises yourself. Good variation in the difficulty of the exercises, there were a few nice challenging ones among them. The trainer had a great deal of knowledge and explained clearly how to tackle a problem in a structured way.”
“Well organised, clear explanations, sound course material.”
“An excellent course to start with as a complete beginner. You first get to know the software package and then get straight to work on small assignments. As a result, I am now able to create small databases and reports.”
“The SQL Basics course at Learnit comes highly recommended. Personal attention, the quality of the course material and the training itself are, in a word, excellent. I was able to learn a great deal in 2 days. It provides a great foundation for growing into a professional super user if you want to move up to a higher level.”
“Very good course. Excellent trainer”
“I would like to move into an IT role, preferably one involving working with databases. As a maintenance engineer with an above-average interest in MS Access, I found this trainer reasonably easy to follow. The content was clear, with practical exercises. Well balanced.”
“A good, instructive course with a professional trainer who knows a great deal about the subject. This keeps you listening with interest so you don't lose your attention.”
“If you have an affinity with IT but no experience with SQL yet, this course is perfect for learning it.”
“Very easy to follow, especially for people who want to get started with SQL. Suitable for both IT and non-IT people. Definitely recommended!”
"This trainer is a highly knowledgeable person who conveys the course material to the participants in a calm, considered and thorough manner."
“The course is interactive. Within two days you have a clear picture of the possibilities of SQL”
“Clear explanations and good exercises gave a good picture of what SQL can do.”
“You learn the basic commands for querying a database and combining tables. This tied in perfectly with the issues I come across in my daily work. I was lucky to be in a class where everyone took part with the same goals. As a result the pace was high and you didn't have to wait for other participants. It is a requirement to have some knowledge of application management and database querying, so that you can translate the content straight into daily practice.”
“An SQL course that anyone without any programming experience can follow, through a piece of theory followed by exercises. In small groups, which allows for personal interaction with the trainer.”
“Thanks to all the practice and the pleasant teaching style, this course is extremely well suited to picking up basic SQL knowledge quickly.”
“A 2-day course that met my expectations and enabled me to apply what I had learned successfully in daily practice. By alternating theory and practice, the knowledgeable trainer managed to keep the course lively and to hold the attention of our mixed group right to the end. All this at a good location and with excellent course material for this subject.”
“This basic course met my expectations. The trainer was knowledgeable and relaxed, with plenty of individual attention where needed.”
“Enjoyable and interesting course in which you get straight to work applying the material through related assignments that are discussed as a group afterwards.”
“This course gives you a clear overall picture of the basic queries in SQL, without wasting any time. The trainer is driven and to the point, and open to input and feedback. Two days well spent!”
“The trainer is extremely knowledgeable and manages to present the often dry material in an entertaining way as well. Keep it exactly like this! Everything was arranged pleasantly and quickly by Learnit Training!”
“Enjoyable and interesting course. Clear explanations, examples and exercises. It was also good that the assignments were phrased the way a colleague would put them to you, so you have to work out for yourself how to tackle them. Learned a lot of functions in a short space of time.”
"Learnit is a professional organisation with a personal approach. The SQL course was well matched to our starting level, and the trainer guided us through the material skilfully and with great enjoyment. Excellent!"
“Excellent course with plenty of depth added to the basic material by a professional trainer.”
"This course contains a welcome refresher of the basic SQL knowledge, but is also a good follow-up with many useful techniques. The pace is comfortable. I was able to take away a great deal that I can apply in my work."
"A fine course if you are really getting to know this subject matter. There is clear and well-structured course material with plenty of exercises to learn SQL."
“A useful and practical course for anyone who wants to master the SQL fundamentals.”
“Very practical training course. Clear explanations and plenty of relevant exercises.”
“A good balance between listening and practising. After this course you have a solid basis to get started on your own.”
"A good basic course. Topics are explained step by step, after which participants practise for themselves with a number of short exercises. Because the trainer walks around and looks on, you get immediate feedback."
“A course in an informal atmosphere, where personal contact comes first. This way everyone can take in the material at their own pace and there is plenty of room to achieve your goals.”
“Excellent course with plenty of depth added to the basic material by a professional trainer.”
“Definitely recommended if you work with SQL. I learned useful things in this training course that I was not previously aware of.”
“The trainer sets a good pace for beginners, keeps your attention and is extremely clear in the way he communicates. As a result you remember everything better and stay motivated!”
“The SQL course was very informative. The course was presented in an enjoyable way by a trainer with a great deal of knowledge. All the basic SQL functions were covered step by step, so I can certainly take this further within my company.”
"A good, clear course in which the basics of SQL are explained."
“I expected a basic course that covered writing queries from scratch from A to Z. The course did exactly that. A perfect match.”
"Extremely instructive, built up step by step and easy to understand for people with no prior knowledge of this."
“Very easy to follow, especially for people who want to get started with SQL. Suitable for both IT and non-IT people. Definitely recommended!”
“I expected a basic course that covered writing queries from scratch from A to Z. The course did exactly that. A perfect match.”
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.
You learn to write SQL queries independently to retrieve, filter, sort and combine data from Oracle databases. You work with Oracle SQL Developer and practise with SELECT, WHERE, JOIN, GROUP BY, subqueries and modifying data and tables.
The course is intended for novice database users who are going to work with Oracle. Think of application managers, Oracle SQL developers, database administrators, BI professionals, data analysts and software developers.
No, no prior knowledge of SQL or Oracle is required. Basic computer experience and a little logical thinking are enough to follow the course successfully.
Before the course starts you will receive a workbook with exercises and practice cases. You will use this book during the course and afterwards as a reference work. The course material and the software are in English.
Yes, afterwards you will receive a Learnit certificate of participation. This shows that you have completed the SQL Basics for Oracle course.
Yes, you practise in a real Oracle environment using Oracle SQL Developer. This means you write working queries against a live database from day one and see the result immediately.
The basics of SQL (SELECT, WHERE, JOIN, GROUP BY) are virtually the same in all databases. Oracle uses its own dialect, PL/SQL, with specific functions and syntax for dates, strings and subqueries, among other things. In this course you learn to work in that Oracle dialect using Oracle SQL Developer.
A JOIN allows you to combine data from two or more tables on the basis of a shared column. An INNER JOIN returns only those rows that appear in both tables. A LEFT OUTER JOIN retains all rows from the left-hand table, even without a match. A RIGHT OUTER JOIN does the same for the right-hand table. During the course you will practise with all three variants.
A subquery is a query within a query. You use it, for example, to first retrieve a list of values and then use that list as a filter in another query, often with IN. Subqueries help you break complex questions down into logical steps.
WHERE filters individual rows before they are grouped. HAVING filters on the result of a grouping, so after GROUP BY. Want to see only customers with more than ten orders, for example? Then you use COUNT and HAVING, not WHERE.
You can take the course in a classroom setting at one of our locations or in-company at your own organisation. For in-company courses we tailor the content and examples to your own databases and practical situations.
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.
Free cancellation up to four weeks before the start, so you can secure a place now.