To apply download and submit application forms to us

Contact us for more information

Course Description:
This course is designed for anyone who wants to learn SQL and PLSQL even if having no knowledge of Databases before. Not even this course will teach you basics and also it provides the student with necessary tools and skills required to attain following Oracle Professional certifications:

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

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

Course Schedule:
Classes per week: One day a week
Classes timings: 09:00 – 13:00 Hrs
Day: Friday (only)
Duration of the course: 20 Weeks
Prerequisites: Basic Spreadsheet Knowledge(MS Excel)

COVID 19 Note – All tutor-led courses are currently delivered via online live sessions. These Live sessions will continue if we are required to do so for the safety of our students current epidemic’s situation settles down. Live sessions are also being recorded and students can watch later if they miss one. We will inform all students when Tutor-Led(Face to face) classes are resumed. When center-based face to face classes are resumed, they will commence at our Training center in Edinburgh:

62 West harbour road
Edinburgh
EH5 1PW


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:

1) Database Administrator
2) Database Developer
3) Database Modeller
4) Oracle SQL Database Administrator
5) SQL Developer
6) Database Programmer
7) Secretary/Administrator
8) Metadata Administrator/developer
9) System Administrator
10) Accounts Administrator
11) Core Operation Engineer (Database)
12) Systems Operations Engineer - SQL, Database
13) Junior Database SQL administrator
14) SQL Database Developer
15) Data Analyst

Read more:
https://www.itpt.co.uk/course/database-programming-plsql/

This course is also available via eLearning(Self Paced).

Both modes Tutor-led(Live class) and eLearning are funded, which means eligible candidates will study for free if they qualify for funding criteria. General funding eligibility criteria is below:

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

Check your eligibility here: https://www.itpt.co.uk/funding-eligibility/

How to apply for the course with funding:

Follow the link below to download application forms.

https://tinyurl.com/sx4bfw4

If not sure which form to complete then contact us.

https://www.itpt.co.uk/contact-us/

1. Print and complete the ITPT course, SAAS application form (using black ink only). In the SAAS application form you must complete Section A, B, D & F and can leave rest to let us complete.

If you do not have access to a printer then send us additional documents via email at info@itpt.co.uk and your address, we will post your forms with a prepaid return envelope.

2. Send us scanned copy of forms or their clear pictures via email at info@itpt.co.uk OR Post application forms to us. If not sure which forms to complete then do not hesitate to contact us.

3. Send us additional documents scanned copy/clear photo via email to info@itpt.co.uk OR Post copies along with the post. Additional documents are listed below.

Additional documents:

Additional documents depend on your circumstances. They can be accompanied with completed forms by post or can be emailed to us.

1. If you are Non-UK (EU citizen) living in Scotland then EU national ID/Passport will be required OR if you are Non-EU citizen living in Scotland then your Biometric card and passport will be required.
2. If you are employed then-recent three payslips will be required OR in case of self-employment bring relevant documents to prove your earnings.
3. If you are receiving JSA/ESA then bring a recent letter you received recently. If you do not receive letters then send us screenshots of your online account showing your name and amounts you recently received. If you do not have any income (including benefits) then complete Nil income declaration form.

Should you have any questions do not hesitate to contact us.

IT Professional Training
0131 552 5558 | 0141 429 2922
www.itpt.co.uk