McCormick House, 50 Darnely Street Glasgow
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.
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.
No prerequisite required, anyone can join this coming for any background as this course will be taught from basic to advanced level.
* 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
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.
This course focuses on practicals and hands-on learning. Therefore, use real databases, real data science tools, and real datasets. You will acquire the skills needed to bring together heterogeneous and disconnected data sources, use the R programming language to transform your data into insights. In a series of hands-on exercises, you will practice creating and executing SQL queries. You will also learn how to access the database from RStudio using SQL and R. By the end of the course you will be able to query, analyse and make industry level reports from the data.
This is a 16-week course that provides the required knowledge and skills required to become data Scientist, this course will be delivered 4 hours a day every week, one full classroom.
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.
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. The course fee if you do not qualify for SAAS funding is £500. Please note that this does not include any examination costs
Group Learner Discounts:
There is 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.
For more information please do contact us;
Edinburgh Phone: 0131 552 5558 – 0131 552 5800
Glasgow Phone: 0141 429 2922
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;