Data Science with R & SQL Course @ Edinburgh – Face to Face/Blended and Virtual Learning Available.

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
• Use plotly for interactive visualizations
• Data Analysis using Numpy
• Data Analysis using Pandas
• Functions and Data Processing
• Testing Plans for testing datasets

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:

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).

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 – 0131 552 5800
Glasgow Phone: 0141 429 2922
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