Data Science with R & SQL Course @ Edinburgh - Virtual Learning Available.

Schedule

Sat Nov 23 2024 at 10:30 am to 02:00 pm

UTC+01:00

Location

21 Calder Road,Edinburgh,EH11 3PF,GB | Edinburgh, SC

Advertisement
*Please note that you must be a resident in Scotland to join this course and use SAAS part-time funding. More information on this is below. If you do not stay in Scotland, you will be unable to join our courses*
IT Professional Training is offering free (fully funded by SAAS) Data Science with R & SQL Course. Students have the option of attending this tutor-led course in the classroom in Edinburgh or as a virtual learner from home.
Course schedule:
Scheduled Start Date: Saturday 23rd November 2024
Classes per week: One day a week
Classes timings: 09:30am to 1:00pm
Day: Saturday(only)
Duration of the course: 16 weeks.
Spaces Available : 5
Introduction:
Much of the world's data is in databases, SQL (or a structured query language) is a powerful language used to communicate with and extract data from databases. If you want to be a data scientist, you need knowledge of databases and SQL.
Course Description:
The purpose of this course is to introduce you to the concepts of relational databases so that you can learn and apply basic knowledge of the SQL and R languages. It is also intended to help you get started in running SQL in your data science environment.
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:
 Introduction to SQL and Databases
 Triggers and Stored Procedures
 Transactions and Concurrency
 Indexing for high Performance and Securing the Database
 Introduction to R
 Data Cleaning (N/A, Outliers, Data Wrangling)
 Data visualization using tidyverse
 Visualization using Tableau
 Visualization using PowerBI
 Advanced Excel
 Data Modelling
 Statistics for Data Science
 Unsupervised Learning techniques
 Supervised learning techniques
 Research Methodologies
 Project
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).
SAAS Course Funding:
This course is funded by SAAS part time fee agency which is available to eligible individuals only:
SAAS General funding eligibility requirement:
1. You have to be a resident of Scotland
2. Either employed and earning less than 25k a year or can be unemployed as well
3. Have not used the SAAS funding in this Academic Year.
For more information on this, please visit the following link:
https://www.saas.gov.uk/_forms/funding_guide.pdf

Ticket Description:
This ticket logs your interest to join this course.
To study this course free, ITPT requires all interested students to complete SAAS PTFG application and ITPT course registration form. Please contact us to and we will be able to send this information via email.
Note: This course is fully funded by SAAS part-time funding and only eligible students will be able to join this course for free, please see below for the eligibility. If you are not eligible to get the SAAS part-time funding please contact us to discuss other options.
To check your funding eligibility:
Please follow the below link to check your course funding eligibility.
https://www.itpt.co.uk/funding-eligibility/
Course Enrolment:
To make an appointment to enrol in this course, click here to Book Course Registration/Consultancy Appointment.
We can send you the forms and information on how to complete them via email.

Contact:
Phone:
Edinburgh Office Number : 0131 552 5558 / 0131 552 5800
Glasgow Office Number : 0141 429 2922
Email: [email protected]
website: www.itpt.co.uk
Advertisement

Where is it happening?

21 Calder Road,Edinburgh,EH11 3PF,GB, United Kingdom

Event Location & Nearby Stays:

IT Professional Training

Host or Publisher IT Professional Training

It's more fun with friends. Share with friends

Discover More Events in Edinburgh

BEGINNERS KETTLEBELL COMPETITION
Sat Nov 23 2024 at 10:00 am BEGINNERS KETTLEBELL COMPETITION

34 Tennant Street, eh6 5na Edinburgh, United Kingdom

WORKSHOPS
Usui Reiki Level I Beginners
Sat Nov 23 2024 at 10:00 am Usui Reiki Level I Beginners

Edinburgh Palette

HEALTH-WELLNESS WORKSHOPS
French Fair 2024
Sat Nov 23 2024 at 10:00 am French Fair 2024

Institut Français d'Ecosse

ART LITERARY-ART
Radical Writing Workshop: Embracing the subjective in arts writing
Sat Nov 23 2024 at 10:00 am Radical Writing Workshop: Embracing the subjective in arts writing

Assembly Roxy, Edinburgh

ART WORKSHOPS
Needle Book Workshop
Sat Nov 23 2024 at 11:00 am Needle Book Workshop

10 Infirmary Street, EH1 1LT Edinburgh, United Kingdom

WORKSHOPS
Edinburgh Steiner School's Christmas Market
Sat Nov 23 2024 at 11:00 am Edinburgh Steiner School's Christmas Market

60 Spylaw Road, EH10 5BR Edinburgh, United Kingdom

CHRISTMAS-MARKETS-AND-FAIRS CHRISTMAS
Polwarth Preloved Sale 23rd Nov '24
Sat Nov 23 2024 at 11:00 am Polwarth Preloved Sale 23rd Nov '24

Polwarth Parish Church

KIDS NONPROFIT
Scottish Church History Autumn Conference
Sat Nov 23 2024 at 11:00 am Scottish Church History Autumn Conference

Edinburgh Theological Seminary

BUSINESS CONFERENCES
Edinburgh Vaults - The Burke & Hare Ghost Hunt With Haunting Nights
Sat Feb 15 2020 at 11:00 pm Edinburgh Vaults - The Burke & Hare Ghost Hunt With Haunting Nights

Edinburgh Vaults

WORKSHOPS GHOST-HUNTS
Gladstone's Land Guided Tour
Wed Jul 07 2021 at 03:00 pm Gladstone's Land Guided Tour

Gladstone's Land

WORKSHOPS
Sighthill Campus Tour
Fri Nov 19 2021 at 03:00 pm Sighthill Campus Tour

Edinburgh Napier University, Sighthill Campus

HEALTH-WELLNESS SPORTS
Cocktail Masterclass at Harvey Nichols, Edinburgh
Thu Apr 14 2022 at 07:00 pm Cocktail Masterclass at Harvey Nichols, Edinburgh

Harvey Nichols Forth Floor Brasserie and Bar

WORKSHOPS
Community Hatha Yoga
Mon Apr 25 2022 at 07:00 pm Community Hatha Yoga

The Salisbury Centre

HEALTH-WELLNESS NONPROFIT
Human Rights Awareness-Raising Training - Free Workshops
Thu Jun 02 2022 at 10:30 am Human Rights Awareness-Raising Training - Free Workshops

REH Patients Council Training Room, Andrew Duncan Clinic, Royal Edinburgh Hospital.

WORKSHOPS NONPROFIT
ISTQB\u00ae Advanced Level Test Manager Training Course (5 days) - Edinburgh
Mon Sep 05 2022 at 09:00 am ISTQB® Advanced Level Test Manager Training Course (5 days) - Edinburgh

Edinburgh regus

WORKSHOPS
How The Top 1% Of Leaders Manage Their Time Like Clockwork Using T5 System
Tue Sep 13 2022 at 04:30 pm How The Top 1% Of Leaders Manage Their Time Like Clockwork Using T5 System

Edinburgh

WORKSHOPS
Afraid Of Public Speaking? FREE Virtual class to Banish Anxiety and Fears
Sun Jan 01 2023 at 12:00 am Afraid Of Public Speaking? FREE Virtual class to Banish Anxiety and Fears

Leith

PUBLIC-SPEAKING WORKSHOPS
Film Photography Workshop - Edinburgh
Fri Jan 27 2023 at 01:00 pm Film Photography Workshop - Edinburgh

Edinburgh

ENTERTAINMENT WORKSHOPS
Queer Yoga Edinburgh @ Salisbury Centre
Fri Feb 10 2023 at 10:00 am Queer Yoga Edinburgh @ Salisbury Centre

Salisbury Centre

HEALTH-WELLNESS WORKSHOPS
Queer Yoga Edinburgh @ L\u012bla Yoga
Fri Jun 09 2023 at 07:00 pm Queer Yoga Edinburgh @ Līla Yoga

Lila Yoga

HEALTH-WELLNESS WORKSHOPS

What's Happening Next in Edinburgh?

Discover Edinburgh Events