Diploma in Oracle PL/SQL Programming - Evening Part Time Course - Dublin City Centre

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;

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.

next start date: 16th September 2024 (Monday)

Duration: 2 evenings a week, 12 weeks (Monday & Wednesday)

Time: 6:30 pm – 9 pm

Venue: Dublin City Centre

Course Fees: €1,495.00

To secure your place on the course a deposit of €296.00 is required. The remainder €1,199.00 is due 30 days prior to the commencement of the course. 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.

We want to make education easy and enjoyable for you. At Fitzwilliam Institute, we offer a range of finance options to suit your needs.

You can buy now and pay later with humm - humm provides a simple application process, simple terms and conditions, up to 36 monthly payments. With low-interest rates.

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.