Diploma in Oracle PL/SQL Programming (10 weeks, 20 Classes) - Evening Diploma

start date: 29 May 2018

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:

  • Over 3 months of intensive high-level oracle programming training with interactive modules covering: Introduction to PL/SQL, Declaring PL/SQL Identifiers, Writing Executable Statements, Interacting with the Oracle Server, Writing Control Structures, Working with Composite Data Types, Using Explicit Cursors, Handling Exceptions, Handling Exceptions, Creating Stored Functions, Creating Compound, DDL, and Event Database Triggers, Creating Packages, Working With Packages, Using Oracle-Supplied Packages in Application Development, Using Dynamic SQL, Creating Triggers, Using the PL/SQL Compiler, Managing PL/SQL Code, Managing Dependencies, etc.
  • Practical skills training delivery from leading industry professionals. All of Fitzwilliam Institute’s oracle programming trainers are top industry professionals with many years of successful oracle programming experience. Fitzwilliam Institute’s cutting edge program in oracle programming contains the core and vital oracle programming industry key skillset and, on completion, all of our students are industry-ready.
  • Real life oracle programming briefs. Fitzwilliam Institute’s Diploma in Oracle Programming offers practical and specific java programming skills that can be applied in real world situations. You will complete a real life oracle programing (database) brief, which will help you gain invaluable oracle programming experience and develop your work portfolio. A combination of interactive group sessions, presentations, and questions and answers allows you to gain transferrable skills and invaluable experience, in real-life situations, which will prepare you for a successful future in the industry.
  • Oracle programming jobs, networking and volunteer opportunities. Benefiting from years of industry experience, we are extremely well placed within the IT world. Employers are always looking for Fitzwilliam Institute’s students and alumni. Fitzwilliam Institute’s website features a comprehensive jobs and volunteer opportunities section.

 

Oracle Fundamentals: Introduction to Database Concepts

What is a database; Traditional Databases; The Hierarchical Database Model; The Network Database Model; The Relational Database Model;

Data Modeling

Introduction to Data Modeling; Entities ; Attributes; Relationships ; Entity-Relationship Diagrams;

Nominalization

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;

Programming Concepts

Software Development Life Cycle; Introduction to Programming; Flowcharts; Pseudocode; Variables ; Constants; Basic Program Control Structures; Conditional Logic; Iterative Logic;

PL/SQL Basics

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;

SQL Functions

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;

Oracle Cursors

Explicit & Implicit Cursors; Understanding the Cursor Processing; Steps to Build an Explicit Cursor; Cursor Attributes; Using a Cursor in a Loop;

Error Handling

Predefined Exceptions; User Defined Exceptions; Declaring Exceptions; Exception_init; Raising Exceptions; Unhandled Exceptions;

Subprograms

Creating Procedures and Functions; Declaring Subprograms; Parameters; Naming Notation; Overloading; Recursion;

Oracle Packages

Package Creation; Creating Package Body; Creating Package Specifications; Overloading Package; Subprograms; Oracle Standard Packages;

Oracle Triggers

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;

Oracle11 Architecture

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;

Managing Tables

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;

Rollback Segments

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.

 

Angela Sully

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.

Martin Nolan

On successful completion of this course you will receive a Diploma level 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.

next start date: 29th May 2018 (Tuesday)

Duration: 10 weeks, 20 classes (2 evenings/week), Tuesday & Thursday

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.