SQL Basics course - Oracle
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.
NRTO quality markFree cancellation up to four weeks before the start, so feel free to book now.
In brief. SQL Basics - Oracle is a 2-day classroom course. You can take it in Amsterdam, The Hague, Utrecht and Rotterdam or online, in a group of no more than 8 participants. The price is EUR 1100,- excl. VAT per participant, including course materials, lunch on location and a certificate of attendance. For a team or department, we also deliver this course in-company.
- Working with Oracle SQL Developer
- Writing queries: filters, joins and subqueries
- Plenty of practical exercises in a real Oracle environment
- English-language workbook for reference
- Small groups and an experienced database trainer
Your trainer: Mike 1,099 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.
Description
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.
Topics
Day 1: Introduction to SQL and simple queries
- Basic principles of SQL: data types, primary key and foreign key
- Working with Oracle SQL Developer
- Retrieving data with SELECT FROM, TOP and DISTINCT
- Sorting with ORDER BY
- Filtering with WHERE, comparison operators and BETWEEN
- Advanced filtering with AND, OR, IN and NOT
- Filtering with wildcards (LIKE)
- Calculations and concatenation
Day 2: Advanced queries in Oracle
- Using functions: ROUND, LTRIM, RTRIM, DATEPART
- Summarising with COUNT, SUM, AVG, MAX and MIN
- Grouping with GROUP BY and HAVING
- Subqueries with IN
- Combining tables with INNER JOIN, LEFT OUTER JOIN and RIGHT OUTER JOIN
- Table aliases and advanced joins
- Combining queries with UNION
- Adding, modifying and deleting data (INSERT, UPDATE, DELETE)
- Creating and managing tables (CREATE, ALTER, DROP)
Result
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.
Target audience
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.
Teaching method
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.
Prior knowledge
No prior knowledge of SQL or Oracle is required. Basic computer experience and logical thinking are enough to follow the course successfully.
Comments
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.
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.
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
The trainers for this course
Ratings from participants after completing their course, across all courses by this trainer.
What others say about this course
SQL Basics course - Oracle: average 9 from 6 reviews
“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.”
“Very good course. Excellent trainer”
“SQL Basics Oracle is a course I can recommend with complete confidence. Its practical applicability is very high!”
"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."
“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.”
“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.”
“Excellent course with plenty of depth added to the basic material by a professional 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."
“Very pleasant course and organisation, highly satisfied!”
“Good, clear SQL basics course. Learned enough methods that I can apply straight away and that lay the foundation to take it further (on my own).”
“Practically applicable within my own organisation.”
“Excellent course with plenty of depth added to the basic material by a professional trainer.”
“A course with a good pace. Pleasant alternation between plenary treatment of the material and doing individual exercises. Excellent value for money if you want to start working with SQL in practice.”
“Very good course for learning how to build basic queries. Clear book with good examples and a good structure. The trainer is highly knowledgeable. His way of explaining things held our attention. Clarifying explanations.”
“A good course with good materials. I got a solid grasp of the SQL basics in two days. I would recommend doing some preparation beforehand so you pick up the topics better and faster. The trainer was open to questions and explained things well.”
“A good, practice-oriented programme, recommended for the increasingly popular field of Big Data.”
“Very satisfied with the content, received a good explanation of the differences between SQLSERVER 2008 and 2012. The trainer was well able to relate to our problems/questions. He knows what he is talking about and is good at pointing out the differences and the pros and cons.”
"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 good course that you can put to plenty of use in practice.”
“Very good course for learning how to build basic queries. Clear book with good examples and a good structure. The trainer is highly knowledgeable. His way of explaining things held our attention. Clarifying explanations.”
“This course has a clear structure and build-up. Alongside the theory there is plenty of room to practise and to put real-life situations to the trainer. A calm, qualified and clear trainer. He knew what he was talking about and how the course fits together. All in all a good way to make a start with SQL.”
“Excellent SQL Server course with a clear structure.”
“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.”
“Enjoyable basic course, perfect location (Amsterdam, Muziekgebouw aan 't IJ).”
“It is a well-structured course that is easy to follow, even for the absolute beginner. The trainer is passionate, clear and good at answering questions.”
"A good, clear course in which the basics of SQL are explained."
“The course is interactive. Within two days you have a clear picture of the possibilities of SQL”
“Challenging, particularly because it could be adjusted on the spot to the level of the participants.”
“Recommended for people with little SQL knowledge – the basics well covered in 2 days!”
“Good course for beginners who already have a little experience with SQL; reasonable account is taken of the type of SQL you use yourself (let the organisation know in advance if you like, then you may receive a different textbook). The course really does stick to the basics.”
“This course has a clear structure and build-up. Alongside the theory there is plenty of room to practise and to put real-life situations to the trainer. A calm, qualified and clear trainer. He knew what he was talking about and how the course fits together. All in all a good way to make a start with SQL.”
“Absolutely excellent, a pleasant and knowledgeable trainer. Good pace, plenty of variation between content and exercises. The course comes highly recommended!”
“Very easy to follow, especially for people who want to get started with SQL. Suitable for both IT and non-IT people. Definitely 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.”
"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!"
“Recommended for people with little SQL knowledge – the basics well covered in 2 days!”
"The trainer was very good and the course material was clear. The pace of the course was manageable and the exercises offered exactly the right amount of challenge."
“Excellent course if you want to learn SQL thoroughly and in a structured way. With plenty of practical exercises. The content of the course was excellent: clearly organised, good course material including practice assignments, a good balance between theory and practical exercises. The trainer's knowledge is good, as is the way he explains and conveys the material. He places a strong emphasis on building knowledge in a structured and solid way, rather than on quick results. He responded well to questions.”
“Excellent course in which the complete basics are explained; the trainer can also discuss matters that fall outside the scope of the course.”
“Received a good explanation of all the basic principles within SQL and its various dialects. Highly recommended as a refresher course too!”
“If you have no experience with sql and would like to learn the basics, this course is a good start! Now I know a bit about what sql involves.”
“I was very satisfied with the set-up and delivery of this course. A good balance was struck between participants working at different paces. The explanations were clear, with a good balance between doing exercises together and getting to work on exercises yourself.”
“For beginners and advanced users alike this is an instructive course, taught in an interactive way. That is very pleasant, because you can apply it immediately while doing the exercises given during the course. There is always the opportunity to ask questions and the guidance is good too. So all in all a very good experience with the SQL Basics course from Learnit Training!”
“Enjoyable and instructive course with a good mix of theory and practice. The trainer presented it in a relaxed way and with humour, which made it all the more pleasant. Everything was well organised and I was able to apply what I had learned straight away!”
“Very good, the trainer had a lot of knowledge. Good examples. Room for questions.”
“A good, practice-oriented programme, recommended for the increasingly popular field of Big Data.”
"The course was delivered at a good pace, allowing the participants to keep up well. It was not a large group, so there was plenty of room for the individual. The material was in a logical order, so that as you progressed through the course the basics kept being repeated, which made them stick."
"Fine, short yet complete basic course."
“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.”
“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.”
Training formats
Classroom
2 days€ 1100,-- Pleasant venue with a good trainer
- Small groups
- Inspiring and motivating
In-company
Bespoke trainingOn request- 100% for your group
- Bespoke training
- At your place or ours
Workshop
Up to 4 hours for groupsOn request- Suitable for events
- Interactive and inspiring
- Large groups too
Private training
At our place or yoursOn request- 100% just for you
- Achieve a lot in little time
- Whenever you want
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 do you learn during the SQL Basics - Oracle course?
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.
Who is the SQL Basics - Oracle course intended for?
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.
Do I need prior knowledge for the SQL Basics - Oracle course?
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.
What course material do I receive with the SQL Basics - Oracle course?
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.
Do I receive a certificate after the SQL Basics - Oracle course?
Yes, afterwards you will receive a Learnit certificate of participation. This shows that you have completed the SQL Basics for Oracle course.
Do you work in a real Oracle environment during the 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.
What is the difference between SQL for Oracle and SQL for other databases?
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.
What is a JOIN and when do you use which variant?
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.
What is a subquery in SQL?
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.
What is the difference between WHERE and HAVING?
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.
Which delivery formats does Learnit offer for the SQL Basics - Oracle course?
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.
What does the SQL Basics - Oracle course cost?
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.