ITPT

Data Science with R & SQL Course @ Edinburgh - Face to Face/Blended and Virtual Learning Available.
2026-04-09 14:00 - 17:00 (Europe/London) | 21 Calder Road, Edinburgh EH11 3PF
Introduction:
In the contemporary information age, the vast majority of the world’s knowledge and transactional records are meticulously stored within complex database systems. To access, interrogate, and harness the full potential of this unprecedented volume of data, mastery of SQL (Structured Query Language) is indispensable. SQL is not simply a tool; it is the universally recognised lingua franca of databases, a language of extraordinary precision and power that enables scholars and practitioners alike to communicate effectively with data at scale. For the emerging data scientist, an understanding of databases and fluency in SQL are not peripheral skills but rather foundational pillars without which genuine expertise in the discipline cannot be attained.
The principal aim of this course is to introduce learners to the fundamental concepts of relational database theory, thereby equipping them with the intellectual framework and technical competence required to engage meaningfully with SQL and its integration alongside the R programming language. Furthermore, the course is designed to facilitate a practical initiation into the execution of SQL commands within a contemporary data science environment, ensuring that participants develop both conceptual sophistication and operational confidence as they embark on their trajectory toward advanced data analysis and scientific inquiry.
Prerequisites:
No prerequisite required, anyone can join this coming for any background as this course will be taught from basic to advanced level.
Course Objectives:

Get started with PostgreSQL and PgAdmin, two of the world’s most popular SQL tools
Learn the basics of SQL syntax
Analysing data using aggregate functions with GROUP BY commands
Running advanced queries with string operations and comparison operations
Learn to use logical operators to add logic flow to your SQL queries
Learn common SQL JOIN commands
Learn to create tables and databases with constraints on data entries
Programming with R
Data Manipulation with R
Data Visualization with R
Advanced R Features
Using R Data Frames to solve complex tasks
Use R to handle Excel Files
Connect R to SQL
Use ggplot2 for data visualizations

Exams & SQA Framework:
There will be an opportunity for leaners to attain a PDA (Professional Development Award) from SQA upon completion successfully (passing all relevant exams) as this qualification is aligned with the PDA DATA Science @ SCQF level 8. Learner can earn up to 40 SCQF credit points upon passing all exams successfully. All SQA exams costs are included in the funding.
Modes of Learning:
You have the option of undertaking this course via following learning modes:

Face to Face Classroom based Learning: You will attend the class each week on the day and time mentioned above.
Virtual Learning: Live traditional face to face class will broadcast to all virtual learners each week on a specified time.
Blended Learning: Mixture of Face to face and Virtual learning (must inform when joining the course).

How to apply for the Course Funding from SAAS PTFG:
SAAS Part Time full funding is available for this course and the course training will be totally free for eligible candidates only. SAAS Part Time full funding is available for this course and the training will be totally free for eligible candidates only. This is a grant not a loan and the funding covers the full cost of our designated courses including the SQA relevant exams.
Student Awards Agency for Scotland (SAAS)
Please visit the https://www.saas.gov.uk/part-time/undergraduate-funding to apply for the course funding;
In addition to the funding application student must fill ITPT course admission application form so we can reserve the place while their SAAS funding application is in process. Any student who do not inform us then their place in the course will not be guaranteed as we have minimum places to offer to SAAS funded students/learners.
Students intending to use SAAS Part Time Fee Grant to fund their studies should apply well prior to the course starting dates. In some cases we allow students to enrol while their funding is in process, if the course date is near or gone past but they have to provide the proof that their funding has been applied to SAAS PTFG and is in under process.
Self-Finance
Students can also self-finance this course if do not qualify for the funding. The cost can be divided into manageable instalments but this needs to be paid within the course duration. To book the place, first instalment must be paid three weeks before the course starting date.
Group Learner Discounts:
There are further discounts if there a group of students or delegates from the company wants to attend the course.
What ITPT do to help students for SAAS funding application forms?
We advise & provide information regarding their SAAS funding application, how and what information to fill through SAAS PTFG online portal so don’t worry just make an appointment and pop along, our dedicated course consultants will be happy to assist you accordingly.
Contact Us:
For more information please do contact us;
Edinburgh Phone: 0131 552 5558
Email: info@itpt.co.uk
website: https://www.itpt.co.uk/
Contact us via website: https://www.itpt.co.uk/contact-us/
To Book an Appointment with Course Advisors:
To Book course registration or for further information about the course or its funding, please follow the below link;
https://tinyurl.com/ITPT-Appointment

Microsoft Office Specialist (MOS) Associate 2019 Course @ Edinburgh (Word, Excel, PowerPoint,)
2026-04-09 09:30 - 12:30
Introduction:
The MOS Associate 2019 certification is part of Microsoft’s broader certification program, focusing on foundational Office skills in the 2019 version of Microsoft Office. The certification covers essential tasks in popular Microsoft Office applications like Word 2019, Excel 2019, and PowerPoint 2019. The exams for each product assess practical abilities, including document formatting, data analysis, presentation design, and email management. MOS certification validates proficiency in these programs and demonstrates a candidate’s ability to apply their knowledge in real-world scenarios.
The Experts agreed that opportunities in IT are merely growing and more opportunities exchange into higher pay, Vendor Certifications place candidates in a better position to take benefit of them.
Link for further information:
https://www.itpt.co.uk/courses/microsoft-office-specialist-core/
Prerequisites:

There is no prerequisite currently required to study this course from Microsoft.
ITPT recommend, ECDL SCQF Level 5 or 6 would be an advantage but not essential as this course will be taught from basics.
Ease of computing use is required.

Course Objective:
The MOS Associate 2019 certification is a valuable credential for anyone aiming to showcase their competence in Microsoft Office applications. It provides an edge in the job market and helps improve both productivity and confidence in performing tasks that involve Office applications. Whether you’re a student, job seeker, or working professional, MOS certification can serve as a stepping stone to enhance career prospects and job performance
Advantages of MOS Associate 2019:

Global Recognition: MOS is an internationally recognized certification, which can be beneficial for people seeking jobs or promotions, especially in administrative, office management, and business roles.
Career Advancement: It can enhance your resume, as many employers value candidates with verified Office skills. It demonstrates proficiency, which can be advantageous for office jobs that require advanced productivity software use.
Enhanced Productivity: Certified individuals tend to be more efficient and productive at using Microsoft Office tools, enabling faster and more effective work in tasks like data management, presentations, and document creation.
Practical Knowledge: The certification assesses real-world tasks. Earning the MOS Associate 2019 certification ensures that you have the skills to use the applications effectively in everyday work scenarios.
Confidence Boost: Obtaining certification can boost personal confidence by validating your skills and demonstrating a recognized level of expertise in Microsoft Office applications.
Potential Salary Increase: Certified professionals often have better salary prospects. Employers may offer higher wages to certified candidates, recognizing the value they bring to the organization.
Access to Advanced MOS Certifications: Once certified as a MOS Associate, you can advance to higher-level certifications, like MOS Expert, which focuses on more complex tasks in Office applications.
Support for Career Change: It can help individuals who are transitioning into office-based roles from different career paths by validating the necessary digital literacy skills needed for office environments.
Better Job Opportunities: MOS certification is often a requirement or a highly desired skill in industries like administration, marketing, finance, education, and customer support.
Verification of Skills: Employers can trust that certified individuals possess the necessary skills to manage Office applications, reducing the need for on-the-job training in these tools.

Modes of Learning:
You have the option of undertaking this course via following learning modes:

Face to Face Classroom based Learning: You will attend the class each week on the day and time mentioned above.
Virtual Learning: Live traditional face to face class will broadcast to all virtual learners each week on a specified time.
Blended Learning: Mixture of Face to face and Virtual learning (must inform when joining the course).

How to apply for the Course Funding from SAAS PTFG:
SAAS Part Time full funding is available for this course and the course training will be totally free for eligible candidates only. SAAS Part Time full funding is available for this course and the training will be totally free for eligible candidates only. This is a grant not a loan and the funding covers the full cost of our designated courses including the SQA relevant exams.
Student Awards Agency for Scotland (SAAS)
Please visit the https://www.saas.gov.uk/part-time/undergraduate-funding to apply for the course funding;
In addition to the funding application student must fill ITPT course admission application form so we can reserve the place while their SAAS funding application is in process. Any student who do not inform us then their place in the course will not be guaranteed as we have minimum places to offer to SAAS funded students/learners.
Students intending to use SAAS Part Time Fee Grant to fund their studies should apply well prior to the course starting dates. In some cases we allow students to enrol while their funding is in process, if the course date is near or gone past but they have to provide the proof that their funding has been applied to SAAS PTFG and is in under process.
Self-Finance
Students can also self-finance this course if do not qualify for the funding. The cost can be divided into manageable instalments but this needs to be paid within the course duration. To book the place, first instalment must be paid three weeks before the course starting date.
Group Learner Discounts:
There are further discounts if there a group of students or delegates from the company wants to attend the course.
What ITPT do to help students for SAAS funding application forms?
We advise & provide information regarding their SAAS funding application, how and what information to fill through SAAS PTFG online portal so don’t worry just make an appointment and pop along, our dedicated course consultants will be happy to assist you accordingly.
Contact Us:
For more information please do contact us;
Edinburgh Phone: 0131 552 5558
Email: info@itpt.co.uk
website: https://www.itpt.co.uk/
Contact us via website: https://www.itpt.co.uk/contact-us/
To Book an Appointment with Course Advisors:
To Book course registration or for further information about the course or its funding, please follow the below link;
https://tinyurl.com/ITPT-Appointment
