• Login
  • No products in the cart.

Oracle: Database Design & Programming in SQL/PL @ Edinburgh

Click to view map
November 12, 2021 @ 9:00 am – 1:00 pm Europe/London Timezone
ITPT Edinburgh
62 West Harbour Road, Granton

Course Introduction
SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data in a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc.

PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and stored inside the database. And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency. PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database

This program offers entry-level credential and designed to ensure the knowledge and proficiency to build database-centric Internet applications for Oracle by preparing student towards OCA/P SQL & PL/SQL.

Basic Database Knowledge or spreadsheet knowledge required.

Course Objectives

1. Oracle certified Associate – SQL Database Programmer (OCA SQL)
• Retrieving Data Using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Using Conversion Functions and Conditional Expressions
• Reporting Aggregated Data Using the Group Functions
• Displaying Data from Multiple Tables Using Joins
• Using Subqueries to Solve Queries
• Using the Set Operators
• Manipulating Data
• Using DDL Statements
• to Create and Manage Tables
• Creating Other Schema Objects
• Practices and Solutions

2. Oracle PL/SQL Developer Certified Associate Certification (OCA PL/SQL)
• Introduction to PL/SQL
• Declaring PL/SQL Variables
• Writing Executable Statements
• Interacting with Oracle Database Server: SQL Statements in PL/SQL Programs
• Writing Control Structures
• Introduction to PL/SQL
• Working with Composite Data Types
• Using Explicit Cursors
• Creating Procedures
• Creating Functions
• Creating Packages
• Working with Packages
• Using Oracle-Supplied Packages in Application
• Development Using Dynamic SQL
• Design Considerations for PL/SQL Code
• Creating Triggers
• Creating Compound, DDL, and Event Database
• Triggers

Hands on:
This course is an instructor led training programme followed by hands on live labs, attendance is required.

SQA Framework:
The PDA Database Programming course also offers a number of shorter curricula which are related to SQA standalone HN Units. These are also assessed by means of restricted response questions and practical labs and so can give credit transfer to complete units. Learner can earn up to 56 credits upon passing all exams successfully. All SQA exams costs are included in the funding.

Exams and Recommended Training:
This course is designed to provide the student with the necessary tools and skills required to attain following certifications:

Oracle PL/SQL Developer Certified Associate Certification(OCA PL/SQL)
Oracle certified Associate – SQL Database Programmer(OCA SQL)

Oracle Certified Associate – SQL (OCA SQL) – 1Z0-071
Oracle Certified Associate – PL/SQL (OCA SQL) – 1Z0-071 & 1Z0-0144

Modes of Learning:
You have the option of undertaking this course via following learning modes:
1.) Face to Face Classroom based Learning: You will attend the class each week on the day and time mentioned above.
2.) Virtual Learning: Live traditional face to face class will broadcast to all virtual learners each week on a specified time.
3.) Blended Learning: Mixture of Face to face and Virtual learning (must inform when joining the course).
4.) ELearning: is self-paced, you will be completing the course in your own time and do not have to attend any traditional face to face classes or virtual.

SAAS Part Time Course Funding:
This course is funded by SAAS part time funding which is available to eligible individuals only and they do not need to pay it back as this is a grant not a student loan. This is different from the full time funding which can be applied by even someone previously granted fulltime funding for a degree, postgrad or any other full time studies (HNC/HND) etc.
• Please note that you can only use SAAS Part Time funding for one course per academic year.
• SAAS academic year starts from Aug to July.

SAAS General funding eligibility requirement:
1. You have to be a resident of Scotland
2. Either employed and earning less than 25k a year or can be unemployed as well
3. Have not used the SAAS funding in this Academic Year.

For more information on this, please visit this link:

If any student do not qualify for the funding then they can also self-finance this course, please contact us for the price.

How to Apply For the Course and Its Funding:

Step 1 – Funding Eligibility Self-Assessment (Optional):

Please follow the below link to check your funding eligibility;

Check your SAAS part-time funding eligibility

Step 2 – Get Registered (Mandatory);

Registration involves completion of application forms.

Book an Appointment:

Please follow the below link to book for in-person (physical) or phone appointment (online) with our course consultant who can guide you about the admission & funding process;


Our appointment hours are Monday to Friday 09:00 am – 05:00 pm and Saturday 10:00 am to 03:00 pm.

If you cannot book an appointment and like to apply by Post instead than please let us know and we will send you the forms via email.

Our Contact details:
Phone: 0131 552 55 58 – 552 58 00 (Edinburgh)
Phone: 0141 429 29 22
Email: info@itpt.co.uk
Website: www.itpt.co.uk

Please follow and like us:
December 6, 2021