PDA Database Programming

This Professional Development Award (PDA) is one of a suite which was designed to incorporate the knowledge and understanding required by popular Oracle certification programmes into SQA’s Higher National frameworks.


    Introduction to the Award

    This PDA is based on the knowledge and understanding associated with the Oracle Database Curriculum and will be attractive to candidates seeking a position as a database programmer, developer, administrator or those wanting to certificate their existing skills in a similar role prior to progressing their careers further.

    Course Introduction

    The PDA in Database Programming is a 7-credit PDA(Awards 56 credits) and 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 SQL & PL/SQL and would be attractive to candidates who were looking for a position as a Database Administrator, or candidates who needed to verify their existing skills in Database Administration for progression within an organisation.


    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 on a database, or retrieve data from a database.


    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

    SQA PDA Framework:

    The PDA Database programing also offers a number of shorter curricula which are related to SQA HN Units. These are also assessed by means of restricted response questions and practical labs and so can give credit transfer to complete units.

    Candidates are required to achieve all four core units: The PDA comprises four Higher National units which are mapped to the Oracle: Database Programming in PL/SQL qualification.

    PDA SQA Units Structure

    The SQA units are as follows:

    Unit TitlesUnit CodesSCQF PointsSCQF LevelSQA Credit Value
    SQL: IntroductionDH3J 34871
    Software Development: Relational Database Management SystemsH16W 351682
    Software Development: Structured ProgrammingDH3E 351682
    Software Development: Object Oriented Programming


    H171 351682 

    Oracle Exams and Progression Routes:

    Candidate can also appear for the following exam:

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

    The units, which make up this PDA in Database Programming at SCQF Level 8 include vendor-related topics but are generic in nature with units in certain HN frameworks. Including these PDAs in the HN frameworks, allows candidates to work towards a Higher National qualification through short courses or part time study.



    No Prerequisite required but candidate should have ease to use computer

    Good to have some prior basic programming experience with any language but not essential.

    ITPT may offer 1 week Pre-course Preparation


    This statement is about access to the Professional Development Awards as a whole. However, in addition to the detail which follows, part of the specification of each and every unit includes recommended access levels. Students should normally be expected to satisfy both sets of access requirements.

    Different combinations of relevant National Qualifications, Vocational Qualifications and equivalent qualifications from other awarding bodies may also be acceptable, as would suitable vendor qualifications at an appropriate level.

    Mature candidates with suitable work experience may be accepted for entry provided the enrolling Centre believes that the candidate is likely to benefit from undertaking the award.

    It would be advisable for all candidates to have some prior knowledge of computing or information technology although formal qualifications may not be necessary if suitable experience had been gained informally or through work experience.

    Such work experience may provide inferred or actual evidence of a candidate’s skills and knowledge as they apply either to particular units.

    Oracle Exams Training

    By completing this PDA students will be able to sit for OCA DA Part 1 , OCA SQL and OCA PL/SQL associated exams. Following is breakdown of all associated exams

    Oracle Certified Associate Database Administrator (OCA DA) – Part 1


    Oracle Certified Associate – SQL (OCA SQL)1z0-071


    Oracle Certified Associate – PL/SQL (OCA SQL)1z0-071





    Why Get Certified:

    With IT job openings being created faster than trained people can be found to fill them, IT certification is the best way to open the door to a higher salary, more opportunities and career fulfilment.

    Trained and certified IT professionals are needed worldwide.

    More IT professionals are getting certified than ever before because IT certifications:

    • Validate your knowledge and skills
    • Help you remain competitive and employable
    • Give you job proficiency more quickly
    • Show dedication to your career

    Target Audiences:

    The IT training classes which we are currently offering are suitable for a wide range of candidates including:

    • School leavers
    • Adult returnees to education
    • Individuals who intend to leave school and further their career path in a college or equivalent
    • Individuals who are in employment and wish to enhance their career prospects
    • Individuals who wish to start a new career in IT
    • Individuals who wants to get promotion at work
    • Individuals who wants to upgrade in their IT skills
    • Individuals who intend to progress their career after the study of either the NQ in Computing, the NQ in Information Systems
    • Individuals who intend to progress their career after the study of the PDA into further study at HN level
    • Individuals who wish to study on a part-time (day or evening) or day-release mode

    Further Study Progression:

    Candidates will acquire 56 SCQF credit which can be used to get exemptions towards HND Software Development and Computer Science or any other course which has a combination of all four existing units in this PDA qualification.

    Candidates who successfully completed this PDA would have the knowledge and skills required to sit for the Oracle relevant exams.

    Successful completion of these would allow candidates to obtain the Oracle Certified Associate/Administrator award and they can progress their career further by joining into further vendors neutral/specific relevant courses.

    Classes Duration & Course delivery:

    This course will be delivered 1day a week, 7 hours a week, one full classroom.

    4.5 months.

    Modes of Learning:

    ITPT is currently providing different method of learning opportunities to our clients. Many people are looking for learning diversity to enhance their qualifications, but they don’t have the time to take on full-time instructor led study or attending courses regularly at their appropriate venues.

    Online, distance and blended learning is a popular solution helping busy people study flexibly around their needs and requirements. We want to be the first choice for those potential online and distance learners so we are introducing variety of different study channels so the people can facilitate themselves accordingly.

    Modes of Course Delivery 
      Modes of Attendance 
    Instructor Led learningPart Time
    Blended learningWeekends</strong 
    Distance Blended Learning Evening

    Career Opportunities/ Job Roles:

    Upon completion of related certification exams student will be able to advance in their career if they are currently in related job role or be able to pursue roles in jobs such as:

    • Database Administrator
    • Database Developer
    • Database Modeller
    • Oracle SQL Database Administrator
    • SQL Developer
    • Database Programmer
    • Secretary/Administrator
    • Metadata Administrator/developer
    • System Administrator
    • Accounts Administrator
    • Core Operation Engineer (Database)
    • Systems Operations Engineer – SQL, Database
    • Junior Database SQL administrator
    • SQL Database Developer
    • Data Analyst

    Reasons You Should Get this Certification

    • You’ll earn a higher salary
    • Oracle Certification is globally recognized
    • It gives you a competitive edge
    • You’ll get more opportunities
    • Your skills will be universal.

    Learning Objectives

    At the end of the award candidates will be able to:

    • Create and maintain a data storage system
    • Manipulate data stored within a table structure and produce formatted reports
    • Explain the terminology and techniques used in the design of relational information systems
    • Create a relational database design from user requirements
    • Describe the issues involved in implementing a relational database system
    • Implement structures and manipulate data in a relational database management system
    • Use a programming language to interface with a relational database management system
    • Use programming techniques to develop program modules
    • Implement a solution from a design and test the completed product
    • Create technical and user documentation

    Application Process:

    You will be expected to attend an interview with a member of the course team. There will be a basic aptitude test to observe your understanding of this course. Course consultant will help you in filling forms and provide you further guidance if require.

    Funding Available:

    This course is FREE (SAAS part-time funding) to anyone who is receiving state benefits or earning £25,000 or less, given that they have not used SAAS/ILA funding towards any other course/training in the last 12 months.

    Those in receipt of following benefits are automatically eligible:

    • Jobseekers allowance
    • Income support
    • Incapacity Benefit/Employment Support Allowance
    • Child Tax Credit (minimum rate)
    • Pension Credit

    Apply for course funding 

    Our Courses are fully funded by SAAS: Student Awards Agency for Scotland

    Please visit the SAAS website www.saas.gov.uk to see your eligibility.

    Download: SAAS Part Time Funding Guide, Part Time Forms

    Read: Part Time Students Eligibility Criteria, Disabled students’ allowance (DSA)

    For Students who don’t qualify for the above fundings:

    How much will this course cost?

    If for any reason you do not qualify for SAAS funding our fees are as follows for students living  in UK or the European Union:

    PDA Database Programming


    Full Course (can be paid in instalments) £650

     Fees are payable in advance at the start of course unless otherwise agreed.

    We also provide flexible fee instalments to help students in paying their fee.

    There are a number of other funding opportunities available to UK and EU students to help them to pay for their studies. Contact the college for more details.

    Course Curriculum

    No curriculum found !

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 10 Days

    Request Call Back!

    Our Partners

    SAAS Bio Certification Certiport CompTIA Microsoft PearsonVUE SQA CIW Android ATC Authorized Training Center Logical operations Nextec Testing


    Linux has grown into an industry-leading software and service delivery platform that is used for everything from super computers and Web servers to virtualised systems and your Android phone. This growth creates a high demand for qualified Linux professionals.CompTIA Linux+ course teaches students how to install, configure and maintain a Linux system in a networked environment. Students will not only learn to perform basic administrative tasks such as adding and managing users, creating and maintaining file systems, developing and implementing a security policy, and performing software installation and package management, but will also learn to perform Linux network-related tasks, including installing and supporting SSH, NFS, Samba, DNS, DHCP, and the Apache Web server. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.You will learn how to?- Installing a Linux operating system and configuring peripherals- Performing and modifying startup and shutdown processes- Setting up and maintaining basic networking- Populating the system with users and groups- Setting specific file permissions on directories and regular files- Performing maintenance on file systems- Managing running processes- Automating daily tasks- Performing backups and restoration of files- Troubleshooting system problems- Analyzing and taking measures to increase system performance- Working with the X Windows interface- Configuring networked file systems- Deploying a working Web server configuration- Sharing files with a Windows SMB protocol- Configuring DHCP services- Configuring DNS services- Implementing security measuresThis is a FREE Fully SAAS FUNDED CompTIA Linux+ certification course which is starting from 2nd May 2018 at IT Professional Training Glasgow. Contact us today to enroll. E-mail: info@itpt.co.uk or call us at Tel: 0141 429 2922.This course will be delivered once a week every Wednesday 2:00pm - 5:00pm for 16 weeks. Seats are limited ... See MoreSee Less

    View on Facebook

    Upcoming Courses

    1:00 pm Free Funded – Java Programming L...
    Free Funded – Java Programming L...
    May 26 @ 1:00 pm – 5:00 pm
    This course will be delivered once a week (4 hrs) for 16 weeks. Hands on experience will also be provided. We also provide MOODLE access to students where they can[...]
    9:00 am Free Funded – CompTIA A + (IT Es...
    Free Funded – CompTIA A + (IT Es...
    May 27 @ 9:00 am – 12:30 pm
    Course Introduction: The CompTIA A+ certificate is widely recognized and prepares the individual to enter the market as PC Technician. The CompTIA A+ certification is the industry standard for validating[...]
    9:30 am Free Funded – CCNP Routing & Swi...
    Free Funded – CCNP Routing & Swi...
    May 30 @ 9:30 am – 4:30 pm
    Introduction CCNP Routing: This course covers routing protocols and related technologies at the professional level. The backbone of the course is focused on EIGRP, OSPF, BGP, and IPv6. You’ll dive[...]
    9:00 am CCNA Routing & Switching @ Glasgow
    CCNA Routing & Switching @ Glasgow
    Jun 1 @ 9:00 am – 1:00 pm
    Introduction Cisco Certified Network Associate (CCNA) Routing and Switching is a certification program for entry-level network engineers that helps maximize your investment in foundational networking knowledge and increase the value[...]
    1:30 pm CompTIA A+ (Gateway to IT) @ Gl...
    CompTIA A+ (Gateway to IT) @ Gl...
    Jun 1 @ 1:30 pm – 5:00 pm
    Course Introduction The CompTIA A+ certificate is widely recognized and prepares the individual to enter the market as PC Technician. The CompTIA A+ certification is the industry standard for validating[...]
    9:30 am MOS: Microsoft Office Specialist...
    MOS: Microsoft Office Specialist...
    Jun 14 @ 9:30 am – 1:00 pm
    This course will be taught one day a week for 16 weeks. ————————————————————————- MOS Core (Basic) Course: ——————————————————————– 1. MOS: Microsoft Word 2013- Core 2. MOS: Microsoft PowerPoint 2013 –[...]