Study at City
  1. Courses
  2. Applying
  3. Fees and funding
  4. Living in London
  5. Visit us
  6. Student support
  7. International students
  8. Order a prospectus
  1. Short courses
  2. Courses
Study at City

Essential PL/SQL and Database Administration for Oracle Database Short Course

Key information

Dates and fees to be confirmed

To be confirmed
To be confirmed
To be confirmed
To be confirmed
Course Code:
To be confirmed
To be confirmed
Booking Deadline:
To be confirmed
To be confirmed

This PL/SQL and Database Administration for Oracle Short Evening Course is an introduction to PL/SQL and administration tasks for Oracle DBAs.

Course overview

This is an introductory course to PL/SQL and administration tasks for Oracle databases aimed at students who have used Oracle (or any other Relational Database Management Systems) for simple tasks (join queries, updates and creating tables) and want to advance their knowledge.

The short course assumes a basic knowledge and familiarity with the Oracle and SQL environment but no further knowledge of programming.

What will I learn?

What will I learn?

  • PL/SQL language statements: syntax elements, control statements, loops;
  • PL/SQL exception handling, records, collections, procedures, functions, packages, cursors, transactions;
  • Basic administrative tasks (configuration, startup/shutdown the database, user management, privileges, backups, data dictionary, etc.).

By the end of the short course you will be able to:

  • Define and work with cursors;
  • Define and use triggers;
  • Write PL/SQL programs;
  • Write PL/SQL functions and procedures;
  • Handling exceptions;
  • Using transactions;
  • Perform basic administration tasks on an Oracle database (creating a  database, starting up/shutdown the server, database configuration,  user privileges, adding/deleting tablespaces, getting tablespace data, etc.)

Teaching & assessment

Teaching & assessment

In-class exercises and a bigger home assignment.

Recommended reading

Recommended reading

  • Oracle PL/SQL Programming by Steven Feuerstein and Bill Pribyl
  • Introduction to PL/SQL by Farhan Ali Arain
  • Beginning Oracle Database 11g Administration: From Novice to Professional (Expert's Voice in Oracle) by Iggy Fernandez
  • Easy Oracle Jumpstart: Oracle Database Management Concepts & Administration by Robert G. Freeman and Steve Karam