Cursus SQL Basis - Oracle in Den Haag

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.

Lees de volledige beschrijving van de cursus SQL Basis - Oracle

All dates in The Hague

None of the dates suitable? In-company takes place on a day of your choosing, and the course also runs in other cities.

Where in The Hague

Who teaches you in The Hague

• Mike Web design and IT trainer Cijfer 8,6 uit 1098 evaluaties

What participants thought

• “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 Zaanstad - SQL Basics - Oracle

• “Very good course. Excellent trainer”

  Ernst Lesterhuis, Global Knowledge- SQL Basics - Oracle

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

  R. Vercouteren - SGS Nederland- SQL Basics - Oracle

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

  P. de Best, Gemeente Westland - SQL Basics - Oracle

Frequently asked questions

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.