home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral Introduction to HW & SW Soft skills TracksOperating systems MVS - z/OS UNIX - Linux - AIX Mac OS X iPad and iPhone iOSDatabases and middleware Relational databases & SQL DB2 for z/OS DB2 for LUW Oracle SQL Server MySQL & MariaDB IMS CICS IBM MQ WebSphere Big data and analyticsApplication development Methods and techniques TOGAF PRINCE2 Agile development and Scrum Programming languages Internet development Object Oriented systems Java Development tools SAS XML SOA & web servicesSystems management ITIL SecuritybalkjePractical informationRegistration 
SQL*Plus

Objectives

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.

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
 

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)

Training method

Classroom instruction. Demonstrations and exercises.

Course leader

Kris Van Thillo.

Duration

2 days.

Schedule

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