BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ITPT - ECPv6.8.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:ITPT
X-ORIGINAL-URL:https://compassionate-sinoussi.185-249-75-142.plesk.page
X-WR-CALDESC:Events for ITPT
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Europe/London
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20260329T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20261025T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20260409T140000
DTEND;TZID=Europe/London:20260409T170000
DTSTAMP:20260423T190704
CREATED:20250224T064939Z
LAST-MODIFIED:20260327T181555Z
UID:10037-1775743200-1775754000@compassionate-sinoussi.185-249-75-142.plesk.page
SUMMARY:Data Science with R & SQL Course @ Edinburgh - Face to Face/Blended and Virtual Learning Available.
DESCRIPTION:Introduction: \nIn 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. \nThe 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. \nPrerequisites: \nNo prerequisite required\, anyone can join this coming for any background as this course will be taught from basic to advanced level. \nCourse Objectives: \n\nGet started with PostgreSQL and PgAdmin\, two of the world’s most popular SQL tools\nLearn the basics of SQL syntax\nAnalysing data using aggregate functions with GROUP BY commands\nRunning advanced queries with string operations and comparison operations\nLearn to use logical operators to add logic flow to your SQL queries\nLearn common SQL JOIN commands\nLearn to create tables and databases with constraints on data entries\nProgramming with R\nData Manipulation with R\nData Visualization with R\nAdvanced R Features\nUsing R Data Frames to solve complex tasks\nUse R to handle Excel Files\nConnect R to SQL\nUse ggplot2 for data visualizations\n\nExams & SQA Framework: \nThere 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. \nModes of Learning: \nYou have the option of undertaking this course via following learning modes: \n\nFace to Face Classroom based Learning: You will attend the class each week on the day and time mentioned above.\nVirtual Learning: Live traditional face to face class will broadcast to all virtual learners each week on a specified time.\nBlended Learning: Mixture of Face to face and Virtual learning (must inform when joining the course).\n\nHow to apply for the Course Funding from SAAS PTFG: \nSAAS 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. \nStudent Awards Agency for Scotland (SAAS) \nPlease visit the https://www.saas.gov.uk/part-time/undergraduate-funding to apply for the course funding; \nIn 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. \nStudents 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. \nSelf-Finance \nStudents 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. \nGroup Learner Discounts: \nThere are further discounts if there a group of students or delegates from the company wants to attend the course. \nWhat ITPT do to help students for SAAS funding application forms? \nWe 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. \nContact Us:\nFor more information please do contact us;\nEdinburgh Phone: 0131 552 5558\nEmail: info@compassionate-sinoussi.185-249-75-142.plesk.page\nwebsite: https://compassionate-sinoussi.185-249-75-142.plesk.page/\nContact us via website: https://compassionate-sinoussi.185-249-75-142.plesk.page/contact-us/ \nTo Book an Appointment with Course Advisors: \nTo Book course registration or for further information about the course or its funding\, please follow the below link;\nhttps://tinyurl.com/ITPT-Appointment \n 
URL:https://compassionate-sinoussi.185-249-75-142.plesk.page/event/data-science-with-r-sql-course-edinburgh-face-to-face-blended-and-virtual-learning-available/
LOCATION:21 Calder Road\, Edinburgh EH11 3PF
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20260409T093000
DTEND;TZID=Europe/London:20260409T123000
DTSTAMP:20260423T190704
CREATED:20250117T202828Z
LAST-MODIFIED:20260327T181451Z
UID:9771-1775727000-1775737800@compassionate-sinoussi.185-249-75-142.plesk.page
SUMMARY:Microsoft Office Specialist (MOS) Associate 2019 Course @ Edinburgh (Word\, Excel\, PowerPoint\,)
DESCRIPTION:Introduction: \nThe 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. \nThe 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. \nLink for further information:\nhttps://compassionate-sinoussi.185-249-75-142.plesk.page/courses/microsoft-office-specialist-core/ \nPrerequisites: \n\nThere is no prerequisite currently required to study this course from Microsoft.\nITPT recommend\, ECDL SCQF Level 5 or 6 would be an advantage but not essential as this course will be taught from basics.\nEase of computing use is required.\n\nCourse Objective: \nThe 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 \nAdvantages of MOS Associate 2019: \n\nGlobal 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.\nCareer 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.\nEnhanced 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.\nPractical 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.\nConfidence Boost: Obtaining certification can boost personal confidence by validating your skills and demonstrating a recognized level of expertise in Microsoft Office applications.\nPotential 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.\nAccess 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.\nSupport 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.\nBetter Job Opportunities: MOS certification is often a requirement or a highly desired skill in industries like administration\, marketing\, finance\, education\, and customer support.\nVerification 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.\n\nModes of Learning: \nYou have the option of undertaking this course via following learning modes: \n\nFace to Face Classroom based Learning: You will attend the class each week on the day and time mentioned above.\nVirtual Learning: Live traditional face to face class will broadcast to all virtual learners each week on a specified time.\nBlended Learning: Mixture of Face to face and Virtual learning (must inform when joining the course).\n\nHow to apply for the Course Funding from SAAS PTFG: \nSAAS 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. \nStudent Awards Agency for Scotland (SAAS) \nPlease visit the https://www.saas.gov.uk/part-time/undergraduate-funding to apply for the course funding; \nIn 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. \nStudents 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. \nSelf-Finance \nStudents 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. \nGroup Learner Discounts: \nThere are further discounts if there a group of students or delegates from the company wants to attend the course. \nWhat ITPT do to help students for SAAS funding application forms? \nWe 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. \nContact Us: \nFor more information please do contact us;\nEdinburgh Phone: 0131 552 5558\nEmail: info@compassionate-sinoussi.185-249-75-142.plesk.page\nwebsite: https://compassionate-sinoussi.185-249-75-142.plesk.page/\nContact us via website: https://compassionate-sinoussi.185-249-75-142.plesk.page/contact-us/ \nTo Book an Appointment with Course Advisors: \nTo Book course registration or for further information about the course or its funding\, please follow the below link;\nhttps://tinyurl.com/ITPT-Appointment
URL:https://compassionate-sinoussi.185-249-75-142.plesk.page/event/microsoft-office-specialist-mos-associate-2019-course-edinburgh-word-excel-powerpoint-access-2/
LOCATION:21 Calder Road\, Edinburgh EH11 3PF
END:VEVENT
END:VCALENDAR