Courses
  1. Undergraduate
  2. Postgraduate
  3. Research Degrees
  4. CPD
  5. Short Courses
Courses

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

Choose a start date

Dates and fees to be confirmed

Key information

Duration:
TBC
Time:
TBC
Fees:
TBC
Course code:
TBC

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