Home > Transfer Education > Training courses > Oracle - technology > Programming in Oracle > Oracle SQL

Oracle SQL

This course is only available in Dutch. Would you prefer to take the course in English? Please contact us.

A solid understanding of the SQL language is essential if you are going to develop in an Oracle environment or if you need to manage such an environment. Additionally, proficiency with SQL*Plus and SQL Developer products is necessary. In this four-day training, we provide you with the essential building blocks to work with Oracle. You will have ample time for hands-on practice: 60% of the course time is dedicated to completing exercises, while the remaining 40% is devoted to explanations and demonstrations.

You will learn:

  • What the essential features of a relational database are
  • How to query, insert, delete, and update data in Oracle tables
  • How to create, remove, and potentially modify objects such as tables, constraints, views, and sequences
  • The key skills in using SQL*Plus and SQL Developer
  • How to systematically structure SQL queries based on a data model
  • How to utilize the main syntactic capabilities (operators and functions) of the SQL language
  • How to handle the transaction and locking mechanism
  • How to avoid the most common pitfalls

Topics:

  • Concepts of relational databases
  • Connecting to the database
  • Operators and the case expression
  • Text, numeric, date, general, and conversion functions
  • Aggregate functions and grouping
  • Analytical functions
  • Joins
  • Set operators
  • Subqueries and inline views
  • Referential integrity and constraints
  • Hierarchical querying (connect by)
  • Data manipulation: insert, update, and delete
  • Transactions and locking
  • Data definition: creating and modifying tables, views, and sequences
  • SQL*Plus commands
  • Data dictionary
  • The SQL Developer interface
  • Avoiding pitfalls

Who should attend?

The course is intended for application designers and developers who are working with or will be working with an Oracle database and/or Oracle tools.

Prior knowledge

No special knowledge is assumed.

Price per person

€ 2.600,-  (excluding VAT)

Duration of this course

4 days

Course dates

2 - 7 january 2025
4 - 7 february 2025
4 - 7 march 2025
2 - 7 april 2025
2 - 7 may 2025
3 - 6 june 2025
3 - 6 december 2024

Share this training

FacebooktwitterlinkedinmailFacebooktwitterlinkedinmail

This training is also part of

Related training courses

Our 4 plus points

  1. Always experts
  2. Always flexible
  3. Always custom-made
  4. Always practical