Oracle PL / SQL Programming

Start date: 16 September 2024

€1,495
• To secure your place on the course a deposit of €296 is required.
• The remainder €1,199 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.

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.

https://www.fitzwilliaminstitute.ie/application-form

Enrolment intake is strictly limited on this course. Early application is advised. Places are allocated on a first come first served basis.

Oracle is a dominant force in the global job market, being named one of the top 10 IT skills employers search for. To respond to growing demand for oracle programming developers, Fitzwilliam Institute’s highly skilled and experienced course experts have developed a dynamic, interactive, practical workshop approach platform, to acquire oracle programming industry’s best skills and practice. Fitzwilliam Institute’s practical skills approach model provides you with the full toolkit to efficiently design, develop and manage high performing oracle databases, and advance your career in this area.

Benefiting from over 30 years’ practical skills training experience, Fitzwilliam Institute’s part-time evening Diploma in Oracle Programming is one of the longest running and most successful Oracle Programming courses in Ireland.

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.

Tel: (01) 283 4579
Email: info@fitzwilliaminstitutegroup.ie