SQL*Plus

At the end of this course, the delegate will be able to use the Oracle database by means of the SQL*Plus interface. He/she will be able:

  • to use the SQL*Plus environment efficiently;
  • to configure the SQL*Plus environment;
  • to write simple queries;
  • to handle, adapt and execute SQL scripts;
  • to format the query results.

Schedule a training?

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

REQUEST IN-COMPANY TRAINING

 

Public training calendar

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

Everyone who has:

  • to write and execute SQL queries by means of SQL*Plus;
  • to generate reports.

Background

Participants should be familiar with a relational database (see course SQL and relational databases fundamentals)

You can test yourself to see if you have enough SQL background by filling out the online self-test.

Main topics

  • Basic principles:
    • Relational database • table • line • column • index • domain
  • The SQL*Plus environment:
    • Commands to edit, to execute and to handle
    • Configuration of the environment • user variables • prompt interaction • bind variables • refcursors
    • Formatting of the result • columns • regrouping • titles
  • Data manipulation - the SELECT statement:
    • Basic syntax: select - from - where - group by -having - order by • operators and expressions • predicates • NULL • scalar functions in Oracle • column functions
  • Data manipulation • INSERT, UPDATE, DELETE statement

Training method

Classroom instruction. Demonstrations and exercises.

Certificate

At the end of the course session, the participant receives a 'Certificate of Completion'.

Duration

2 days.

Course leader


SESSION INFO AND ENROLMENT