Delivered interactively by Ireland’s leading Oracle Programming developers, Fitzwilliam Institute's Diploma in Oracle Programming course takes places in Dublin City Centre, two evenings per week for 10 weeks, and features:
Oracle Fundamentals: Introduction to Database Concepts
What is a database; Traditional Databases; The Hierarchical Database Model; The Network Database Model; The Relational Database Model;
Introduction to Data Modeling; Entities ; Attributes; Relationships ; Entity-Relationship Diagrams;
Importance of Normalization ; Database Normalization Rules; 1st Normal Form; 2nd Normal Form; 3rd Normal Form; 4th and 5th Normal Forms; Resolving Many-to-Many Relationships;
Overview of Oracle Architecture
Why you must know the Architecture; Database structure; Logical Database Structures; Schema Objects; Tablespaces; Physical Database Structures; Password File; Parameter File; Data Files; Redo Log Files; Control Files; Memory Structures;
Features of Oracle11
New Features in Oracle11; Internet File System; ConText Cartridge; JDeveloper; Java Virtual Machine; XML support; Oracle 11 Lite; Web Assistant; Popular Oracle Tools; WebDB; Designer; Developer; Oracle Application Server;
Introduction to SQL
Programming Technology; Datatypes; Data Definition Language Commands; Create; Integrity Constraints; Alter; Drop; Rename; Truncate; Data Manipulation Language Commands; Insert; Update; Delete; Select statements; Where Clause; Transaction Control Language Commands; Grant; Revoke ; Data Control; Language Commands; Commit; Rollback; Savepoint;
Software Development Life Cycle; Introduction to Programming; Flowcharts; Pseudocode; Variables ; Constants; Basic Program Control Structures; Conditional Logic; Iterative Logic;
What is PL/SQL?; PL/SQL Blocks; Types of PL/SQL Blocks; Basic Procedural Rules; Declaring Variables and Constants; Generating output on screen; SELECT INTO statement; Overview of PL/SQL Control structures; IF conditional statements; Simple Loop; While Loop; For Loop;
Object Oriented Technology
Overview of Object-Oriented Technology; Object Oriented Components; Classes; Objects and Properties; Methods ; Discussing System Behaviour; Encapsulation; Inheritance; Polymorphism; Object Relational Database Management System; Object Types;
Introduction to Oracle 11: SQL and PL/SQL
Introduction to Structured Query Language; Overview of SQL commands; SQL*PLUS; PL/SQL;
Introduction to SQL*PLUS
Using SQL*PLUS Commands; Calling External Files; Executing SQL Statements; Creating Reports with SQL*PLUS;
Tables and Constraints
Creating and Modifying Tables; Integrity Constraints; Creating and Modifying Constraints;
More Database Objects
Creating Sequences; Creating Synonyms; Creating and managing Views; Accessing the Oracle Data Dictionary Views; Creating and Managing Indexes; Creating Roles and Privileges;
Numeric Functions; Character Functions; Date Functions; Conversion Functions; Error Reporting Functions; Miscellaneous Functions;
Restricting and Sorting Data
Comparison Operators; Sorting Data; Aggregate Functions;
Working with Multiple Tables
Working With Compound Triggers, Identifying the Timing-Point Sections of a Table Compound Trigger;
Joins; Using a Select Statement without a Direct Match; Writing Simple Subqueries; Writing Multi-Column; Subqueries; Performance Comparisons;
Creating a Simple PL/SQL Block
Building a PL/SQL Block; Declaration; Naming Convention; Scope & Visibility; Understanding Identifier; Creating Scalar Data Types; Expressions and Comparisons;
Manipulate Data with PL/SQL
Using Composite Variables; Writing SELECT, INSERT, UPDATE, and DELETE Statements; Using Commit and Rollback; Including Save Points in the Program;
PL/SQL Control Structures
Understanding the Conditional Constructs; Using Loops in PL/SQL ; Using the Unconditional Branching; Constructs within the PL/SQL;
Collections and Records
Defining and Declaring Collections; Initializing and Referencing Collections; Assigning and Comparing; Manipulating Collections; Collection Methods;
Explicit & Implicit Cursors; Understanding the Cursor Processing; Steps to Build an Explicit Cursor; Cursor Attributes; Using a Cursor in a Loop;
Predefined Exceptions; User Defined Exceptions; Declaring Exceptions; Exception_init; Raising Exceptions; Unhandled Exceptions;
Creating Procedures and Functions; Declaring Subprograms; Parameters; Naming Notation; Overloading; Recursion;
Package Creation; Creating Package Body; Creating Package Specifications; Overloading Package; Subprograms; Oracle Standard Packages;
Types of Triggers; Building the Trigger Body; Enabling and Disabling Triggers; Understanding the; Restrictions on Triggers; How to Fire a Trigger; Using Triggers to Audit;
Database Architecture; The User Connection Process; The Oracle Data Dictionary;
Creating a Database
An Overview of Database Creation; Creating a Database with the Database Configuration Assistant;
Managing the Oracle Instance
Logical and Physical Structures; Database Objects and Their Physical Structure; Managing the Instance; Managing and Maintaining the Control File;
Tables and Datafiles
Managing Tablespaces; Resizing and Moving Tablespaces;
Constructing Tables; Information and Analysis;
Indexes, Views and Sequences
Managing Indexes; Managing Views; Managing Sequences;
Maintaining Data Integrity and Data Relationships
Implementing Constraints; Maintaining Integrity Constraints;
Planning and Creating Rollback Segments; Monitor and Maintain Rollback Segments;
Redo Log Management
Purpose and Operation of Redo Log Operation; Plan and Configure the Redo Log Files;
Managing Users and Security
Managing Users; Managing Resources and Roles; Authenticating and Auditing;
Loading and Reorganising Data
SQL*Loader; Export and Import; Transportable Tablespaces;
Introduction to Oracle Backup and Recovery
Backup and Recovery Administration Responsibilities; Defining a Backup Strategy; Planning for Disaster Recovery;
Oracle RDBMS Backup and Recovery Fundamentals
Recovery & Backup 101;
Oracle Troubleshooting Utilities
Oracle Problem Detection; LogMiner;
I would like to say thank you to my tutor for the help and support given to me on the recent Diploma in Oracle PL/SQL Programming course. I found the course both challenging, rewarding and finally a very valuable skillset to have in the IT industry today.
At all times I received encouragement and support throughout the course and overall found it to be interesting learning.
This is an excellent hands-on Oracle Programming course. I had very little PL/SQL experience and I was a little bit nervous when I enroled, but the trainer’s knowledge of the subject matter and willingness to help were impeccable. This, matched with the very relevant course materials, ensured the course was a big success. I would certainly recommend this course to anyone interested in starting an Oracle Programming career.
On successful completion of this course you will receive a Professional Diploma qualification that is certified and awarded by the ICM (Institute of Commercial Management).
The Institute of Commercial Management was founded in 1979 and is one of the leading Professional Examination and Certification Bodies in the world today. Fitzwilliam Institute have developed and provided practical skills training courses in liaison with the Institute of Commercial Management qualifications and certifications framework for over 25 years. The Institute of Commercial Management certifications and continual professional development training awards are recognised by leading industries, bodies and professions.
Duration: 10 weeks, 20 classes (2 evenings/week), Monday & Wednesday
Time: 6:30pm – 9pm
Venue: The Capel Building, Mary’s Abbey, Dublin 7 (The Capel Building is located in Dublin’s City Centre on Mary’s Abbey (Between the Jervis and Four Courts Luas stops).
Course Fees: €1,395.
To secure your place on the course a deposit of 20% (€279) is required. The remainder of the course fee (€1,116) is due 30 days prior to the commencement of the course. All fees must be paid before the course begins. Please note, the full course fees are inclusive of all course materials and certification costs.
Enrolment intake is strictly limited on this course. Early application is advised. Places are allocated on a first come first served basis.
Fitzwilliam Institute closes on Bank Holidays and for a number of days at Christmas and New Year. Fitzwilliam Institute reserves the right to postpone, cancel or alter courses without notice or to change any of the details in this brochure. Fees are not refundable unless the course is cancelled by the Fitzwilliam Institute. Distance Learning courses are provided by Fitzwilliam Institute - BGLS Ltd.
Year on year, we have the pleasure of training students from top
Ireland and international companies. See where our most recent students come from and find out what they have to say.