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.

9 from 6 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 - 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.

  • 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
Mike

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.

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.

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.

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.

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.

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.

Request a quote More about SQL Basics - Oracle in-company

All start dates

2 training days. In order of date.

  • Tue 22 & Wed 23 December 2026 Amsterdam · 10:00–17:00Free cancellation until 24 November Enrol
  • Tue 22 & Wed 23 December 2026 Online · 10:00–17:00Free cancellation until 24 November Enrol
  • Tue 5 & Wed 6 January 2027 Utrecht · 10:00–17:00Free cancellation until 8 December Enrol
  • Wed 27 & Thu 28 January 2027 Utrecht · 10:00–17:00Free cancellation until 30 December Enrol
  • Wed 17 & Thu 18 February 2027 Amsterdam · 10:00–17:00Free cancellation until 20 January 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
  • Wed 14 & Thu 15 April 2027 The Hague · 10:00–17:00Free cancellation until 17 March Enrol
  • Wed 28 & Thu 29 April 2027 Eindhoven · 10:00–17:00Free cancellation until 31 March Enrol
  • Tue 1 & Wed 2 June 2027 Arnhem · 10:00–17:00Free cancellation until 4 May Enrol
  • Tue 31 Aug & Wed 1 Sep 2027 Rotterdam · 10:00–17:00Free cancellation until 3 August Enrol
  • Tue 14 & Wed 15 September 2027 Rotterdam · 10:00–17:00Free cancellation until 17 August 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

9
SQL Basics course - Oracle: average 9 from 6 reviews

"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."

Participant

“Very good course. Excellent trainer”

Ernst Lesterhuis
Global Knowledge
9.0

"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."

Participant

“Excellent course with plenty of depth added to the basic material by a professional trainer.”

R. Vercouteren - SGS Nederland9.0

“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.”

A. Mangal - Ayvens Nederland8.8

“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.”

H. Rijnsburger - Gemeente Zaanstad10.0

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 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.

Can I bring my own practical questions to the SQL Basics - Oracle course?
Yes. You work on the exercises at your own pace and can bring in questions from your own work, so that you learn how to apply the queries to situations you encounter yourself.

Next start: Tue 22 & Wed 23 December 2026 in Amsterdam, also available online

Free cancellation up to four weeks before the start, so you can secure a place now.

€ 1100,-excl. VAT · next start Tue 22 Dec
Choose a date