SQL Basics - Oracle 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.
NRTO quality markPreviously attended by staff from Gemeente Zaanstad, Global Knowledge, SGS Nederland, Ayvens Nederland and others.
- 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
Your trainer: Mike 1.098 evaluations in total, averaging 8,6. View the trainers
What the course covers
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.
Read the full programme of SQL Basics - Oracle
How an in-company course works
- RequestYou tell us which course it concerns, how many people and roughly when. You receive a quotation with a fixed price for the group.
- AlignmentWe discuss what the group can already do and what should be different afterwards. The trainer adapts the examples and exercises accordingly.
- The courseOn the day and at the place you chose, with course materials for every participant.
- 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.
What participants say about SQL Basics - Oracle
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”
“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.”
“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.”
“SQL Basics Oracle is a course I can recommend with complete confidence. Its practical applicability is very high!”
Frequently asked questions about SQL Basics - Oracle in-company
Where does the SQL Basics - Oracle in-company 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 - Oracle 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 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.
SQL Basics - Oracle for your team?
Request a quote without obligation and an adviser will get back to you shortly. With one or two colleagues? SQL Basics - Oracle is scheduled 13 times over the coming year, in Amsterdam, The Hague, Utrecht, Rotterdam, Eindhoven, Arnhem, Groningen and Zwolle.