SQL for Data Analysts

Name: SQL for Data Analysts
Author: admin

About the Course

The course includes a series of video lectures combined with a variety of conceptual and hands-on activities to help you develop the skills to identify the critical characteristics of databases and work with relational databases. You’ll learn about database design and modelling
essentials. Here you’ll learn about the Database Management System, which is the system in charge of the control, storage, organisation, and retrieval of data through end-user applications.

You’ll then explore the most common features of the SQL programming language using Microsoft’s SQL Server. During the final part of the course, we’ll focus on MySQL, an open-source relational database management system. In this module, you’ll learn the fundamentals of data management using MySQL. The course is divided into three modules and includes knowledge tests at the end of each section.

Course Info

Duration 44 hours. This will vary based on prior knowledge and ability.

Training Type Course

Study Type In centre, Online

Awards & Qualifications

Awarded 44 CPD points upon successful completion

Is this course right for me?

In this course, you’ll learn the essentials of Structured Query Language (SQL), a programming language used to extract and organise data stored in relational databases.

Is this course for you?
This course is for those who are interested in learning the SQL programming language to efficiently access the data you wish to analyse.

Awarded 44 CPD points upon successful completion

Duration 44 hours. This will vary based on prior knowledge and ability.

Course Content

Course Content

Module 1: Generic Database Fundamentals Architecture and Normalisation Concepts; Concepts and Conceptual Design.
Module 2: Introduction to SQL Managing Table Design, Multiple Tables and Advanced Queries; Views, Transactions, and SQL
Security Architecture.
Module 3: MySQL Database Development Database Design Fundamentals; DDL Statements; Manipulating Data; SELECT Statements and Operators; Working with Functions.

Course Overview

Aims and Objectives
The aim of the course is to introduce you to database design and management and to help you develop your skills using SQL tools that you can implement in the field of data analysis.

Career Path
To become an effective data analyst, you’ll need several programming languages in your toolkit. SQL is among the most sought-after skills among data analysts.

Pre-Requisites
Strong critical-thinking and problem-solving skills, a strong background in mathematics (e.g., advanced algebra), and some experience with coding.

May 2024

May 13 @ 9:30 am - 4:30 pm Power BI Intermediate

Power BI Intermediate

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 14 @ 9:30 am - 4:30 pm Excel Advanced

Excel Advanced

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 14 @ 9:30 am - 4:30 pm Communication Skills

Communication Skills

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 15 @ 9:30 am - 4:30 pm Microsoft Project Introduction

Microsoft Project Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 15 @ 9:30 am - 4:30 pm Meetings and Minutes

Meetings and Minutes

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 16 @ 9:30 am - 4:30 pm PowerPoint Introduction

PowerPoint Introduction

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 16 @ 9:30 am - 4:30 pm Time Management

Time Management

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 17 @ 9:30 am - 4:30 pm Word Introduction

Word Introduction

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 21 - May 22 Executive PA – 2-day workshop

Executive PA – 2-day workshop

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 21 @ 9:30 am - 4:30 pm Power BI Introduction

Power BI Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 22 @ 9:30 am - 4:30 pm Identify and Manage Stress

Identify and Manage Stress

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 23 @ 9:30 am - 4:30 pm Telephone Techniques

Telephone Techniques

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

Testimonials

Very friendly and I never felt that I was being taught anything but the information flowed. Your trainer is the best thing about this course. Thank you Julie.

Tracy – Support Assistant – Train The Trainer

General PD, Organisations Testimonials, Train the Trainer

‘’I would like to say how much I enjoyed the above course yesterday. I have to say this ranked as one of the very best courses I have attended and I now have a more positive attitude towards meetings/minute taking. Please pass my thanks to the trainer.’’

L D

Minutes and Note Taking, Organisations Testimonials

Very good. I did a full semester in university on Project Management and this course taught me much more than I learned at university.

Rosemary – Wind Farm Developer – Project Management Principles

General PD, Organisations Testimonials, Project Management

Excellent.

Alison – Receptionist – Outlook

IT Tutor Led, Organisations Testimonials, Outlook Seminar

“The course exceeded my expectations and I would recommend it to all my colleagues and will let our training department know that it was excellent”

Bob—–Co-ordinator—–Voluntary Sector

Organisations Testimonials, Time Management

“I just wanted to send you a quick email to say thank you most sincerely for finding me a place on the course. I have to say to you that I found the course totally inspirational. I have been on many courses, some dreadful and some ok, but none came anywhere near to the quality delivered by Pitman Training. The Trainer was so energetic, enthusiastic, very knowledgeable, friendly and adaptable to our needs – no wonder you heard the hoots of laughter from the course room, everyone was just enjoying it so much. It was a great group as well, lots of characters and this helped as well.
Our Trainer kept us totally captivated for 3 days and that’s no easy task when delivering – she is a gem. If I could be a Trainer with even half her ability I would be delighted.”

Derek Walker ——Project Manager

Organisations Testimonials, Train the Trainer

“I was amazed with what I achieved with My course. I’m over 3 months into my job at HM Revenue and Customs and the background I received through the Accounting Technician Diploma undoubtedly helped me secure the job and has helped ‘on the job’.”

GM – Accounting Tecnhnician Diploma

Book-Keeping, Private Individuals

“This was one of the most useful training sessions I have ever been to.The tutor gave a lot of practical advice and I thought asking people to commit to action plans to take advice back to the workplace was great.The trainer really listened to people and made sure everyone’s objectives were dealt with fully.”

Zoe Westwood—–Project Officer—-Changeworks

Organisations Testimonials, Time Management

“After graduating a few years ago and going off for a few years to live abroad, I then came back and decided to pursue a career in law. I decided the best route was to first get experience in a law firm and then perhaps study part time. My goal was to become a legal secretary to start off but the skills required such as Microsoft Office packages and knowledge of legal terminology and procedures was not something I had picked up at university!!
I decided I needed a foot in the door and chose to study for the legal secretarial diploma at Pitman. The course was great because it was completely flexible and the training facilities were of the highest standard. The supervisors were always happy and friendly and I was impressed that they really took an interest in everyone personally.
Towards the end of my course, the supervisors referred me to a vacancy at Simpson and Marwick for a litigation secretary. Litigation was the most interesting module and that was the area I wanted to get into. I decided to apply. The very next morning, I had an interview lined up and two days later I had the job. It was the first job I applied to. The HR manager at Simpson told me that the diploma at Pitman had secured me the job and she believed the course to be an excellent grounding for starting work there.”
As regards the job, I have been there for a few weeks now and I can honestly say that I’m loving every minute of it. It’s definitely challenging and at times hard work but it’s interesting and I work with a great group of people in the best litigation team in Scotland.
I’d also like to say a big thank you to the training team who helped me the most. They really went that extra mile to help me and they were always so friendly and nice to be around. Please pass on my thanks to them – they are great assets to Pitman!

LC – Legal Secretarial Diploma

General Diploma, Legal Secretarial, Private Individuals

I completely understood the topics covered and everything was explained very well. Thank you!

Abbi – Receptionist Seminar

General PD, Organisations Testimonials, Receptionist Seminar

Well delivered, friendly and approachable.

Claire – Property Services Assistant – Report Writing

General PD, Organisations Testimonials, Report Writing

Excellent. Very approachable and knowledgeable. Made the subject interesting.

Angela – Assistant Facilities Manager – Excel

Excel Seminars, IT Tutor Led, Organisations Testimonials

‘I found this course hugely beneficial. I have just taken on a training aspect to my current role and the skills gained on this course have given me the confidence to approach the training sessions in a much more positive way.
This course gave me both the knowledge of how to put a training session together, and insight into the different approaches and skills used to deliver the training. I particularly found the practical aspect of the course useful. Throughout the three days, we not only learnt ‘how’ to do various tasks, but actually did, and evaluated them’.

MC—-Project Officer

Organisations Testimonials, Train the Trainer

I was offered three jobs within a matter of weeks!

H S – Personal Assistant

Private Individuals

I believe that the only reason I was granted an interview let alone being offered this position, is because I had enrolled for your course at Pitman Training, Edinburgh.

F C – Medical Secretary

Private Individuals

I came to Pitmans after leaving my job as a Customer Service Team Leader as I wanted to better myself & change careers. I studied the Executive PA Diploma, the course was very informative & could be done at my own pace. After completing the course I temped for 3 months & then I managed to get a job as an administrator through Office Angels. I am now working for an Interior Design company as PA to the Managing Director.
I would recommend Pitman to anyone who wants to improve themselves, I also made some new friends who I am still in contact with, as my circle of friends was very limited as I knew no-one when I moved to Edinburgh 3 years ago…
Many thanks again, I will be back!

LB – Executive PA Diploma

Executive PA, Private Individuals

“I started off with Pitman doing Microsoft Office 2007 specialist before progressing into Microsoft Office 2010 and attaining Microsoft Office Master status by sitting Microsoft exams at Expert Level in Word and Excel and standard level Outlook and PowerPoint.
To add to my knowledge I have just completed Pitman’s ‘Train the Trainer’ 3 day course and applied to become a Microsoft Certified Trainer (MCT). With this training I have plans to increase the knowledge of Office within East Coast Mainline staff.
The skills and knowledge I gained, studying at Pitman Training, have made my job easier by using the advanced features in Microsoft Office to ‘correctly’ format and automate reports and simplify data collation. The ‘Train the Trainer’ course has provided me with increased confidence in dealing with people and situations and will allow me to improve working practice in the office by imparting my ‘Pitman gained’ Microsoft Office Knowledge to others. By raising the overall Office knowledge this should allow the depot to operate better with less time spent ‘trying’ to figure out bullet points and how to create graphs and more time spent doing the actual work.
You have an amazing team of staff at York Place, they are all a credit to you.
The flexibility of learning at Pitman Training is excellent given that you are able to study at Pitman Offices or distance learning at work or home to suit your personal circumstances.
I would thoroughly recommend Pitman Training whether you are looking to improve your situation by training to get a better job or improve your job security at your current location by improving your skills.”

KS – Microsoft Office

General Courses, General Diploma, Microsoft Office, Private Individuals

A very good course. Learned quite a lot of new supervision tips that I never knew. Hope to take things I have learned from this course into my working environment which hopefully will make me a good supervisor.

William – Maintenance Chargehand – Supervisory Skills

General PD, Organisations Testimonials, Supervisory Skills

The training course helped me to build on my degree and specialise in Microsoft Skills to help me find employment in the computer support and administration industry. I enjoyed being able to get a “hands on” approach from the course.

M H – IT Systems Administrator

Private Individuals

Julie was able to convey the content of the course clearly and used lots of real life examples to demonstrate. As we were a small group she was able to detail the course to meet our own objectives. Very useful course with knowledgeable trainer. I have learnt skills which will be used immediately within the workplace and at home.

Cara – Assistant Accountant – Influencing Skills

General PD, Influencing Skills, Organisations Testimonials

The training has helped give me a lot of the practical skills I needed to be a secretary. But more importantly it gave me confidence in myself and my ability to go out and get a job, knowing I had a great head start in comparison with many other people in the job market.

S D – Executive PA

Private Individuals

The course was invaluable in helping me to work in the publishing industry and my two employers have been very impressed by the diploma.

R J – Publishing

Private Individuals

I have a job with the Inland Revenue as a Revenue Assistant. I enjoyed your course’s flexibility the most, as it was at my own pace.

J M – Inland Revenue Assistant

Private Individuals

Very useful, customised experience, highly recommended.

Sam – Programme Officer – Project Management Principles

General PD, Organisations Testimonials, Project Management

“Having chosen not to go to University, and after a years work in the retail business, I was still unsure as to which career path I ultimately wanted to follow. I enrolled on the Executive PA Diploma course with Pitman Training School in Edinburgh in September 2008, knowing that it was highly respected amongst employers.
The course for me was an undoubted success. I completed the main Microsoft modules reasonably quickly – they proved to be very easy to follow and actually quite a lot of fun! I very much enjoyed having the flexibility to choose which elective courses to do, and I was pleased to be given the choice of seminars as well as computer programmes. I have completed two seminars; both were great fun, and whereas I had found Pitman to be a quiet and studious place, suddenly we got to interact with other students and I met some great people.
I now have the role of Personal Assistant to an Art Broker in Edinburgh, which I found through word of mouth. All that I learnt during my time in Pitman has certainly now been put to use – especially the PA Seminar, which focuses not only on the general office keeping but also on the more personal and, often hugely overlooked aspects. Approximately two months elapsed between my finishing the main bulk of the course and securing my current job.
I also hold the position of Secretary on the board of the Edinburgh Charity Fashion Show. This is a non-profit and student run body that annually holds a highly respected Fashion Show in aid of three charities. My job involves organising meetings, taking minutes and being the administrative organiser. Without the Pitman background I would not have the skills that I now use daily.
I am moving to London in March, and thanks to my time at Pitman I am approaching agencies with confidence in myself and my abilities.”

HJ – Executive PA Diploma

Executive PA, General Diploma, Private Individuals

“Two years ago I was at a crossroads in my career as a Textile CAD designer and decided to expand my IT knowledge in the hope of broadening my job options.
Knowing the cost involved I began my research and found plenty of organizations who offered IT courses, but little else. Pitman Training on the other hand offered the support and the resources at an extremely competitive price.
Starting with the CompTIA A+ courses passing both these exams, I was extremely motivated to expand my knowledge further and receiving all the advice I needed from Pitman I am now one exam away from achieving my MCSA Microsoft qualification.
I am currently working in an IT support role which was initially a trainee position. But using the knowledge I have obtained through the courses at Pitman this has allowed me to become a supervisor a lot sooner than I had imagined.
I can’t recommend Pitman Training enough to people and although the courses I undertook where online and mostly home study, I enjoyed using the facilities finding the atmosphere very conducive to studying with very helpful, friendly and knowledgeable staff.”

IL – IT Technical

General Courses, IT Technical, Private Individuals

“I started the Executive PA/Secretarial Diploma course at the Pitman Training Centre in Edinburgh in August 2012 and followed up with 2 Legal Modules.
Before I started my Pitman Training course I was working in retail and not feeling like I was getting anything out of my job. My training has helped me to build up the knowledge and skills required to work in a much more demanding position and has been a great help to me.
In April 2013, I left my job and applied for a job as a receptionist at a Hotel outside Aberfeldy – a job which a friend had seen advertised and suggested I applied for. The job description entailed working mainly behind reception, dealing with guests, but also comprised of a lot of secretarial based work such as organising functions and meetings and typing up notes and menus etc. I was offered the job only hours after I went for the interview and so of course accepted it straight away.
I applied for the receptionists job 9 months after I began my course, as initially I was in no great rush to find another job, but would rather focus on working through the modules so that I would have the necessary experience for when I did decide to apply for something else.
I have loved doing my Pitman courses and have found the workbooks and online exercises very beneficial. I have enjoyed being able to work through each part of the course in my own time and being able to repeat exercises and aspects of modules has definitely been a help, especially on some of the more tricky subjects. It has made me a feel a lot more comfortable in what I am doing and has allowed me to go over parts that I was having any difficulty with.
All of the tutors and staff at the Centre in Edinburgh have been fantastic, and are always there on the end of the phone or an email whenever I have needed any help or clarification on any part of the course. They have always been more than happy to give me advice and guidance, no matter how trivial I think my questions are.
My experience at Pitman Training has been excellent and I will definitely consider doing another course at the Centre in the future, and would highly recommend it to other people.”

CS – Legal/ Executive PA Diploma

Executive PA, General Diploma, Legal Secretarial, Private Individuals, Secretarial Diploma

I would have no hesitation in recommending Pitman Training to anyone who has an interest in investing in their personal development

C N – Executive Assistant

Private Individuals

“Just a note to let you know I’ve now managed to secure a permanent post as a Finance Assistant/Purchase Ledger Clerk for an electronics firm just South of Edinburgh.
I would just like to say that I believe my Pitman Training certificates in Sage Line 50 and Purchase Ledger were instrumental in securing the above post.
I would like to take this opportunity to thank you and your colleagues for all your help in assisting me in my future career in finance.”

BS – Sage Accounts and Payroll

Book-Keeping, Private Individuals, Sage

Excellent facilities. Excellent trinaing course!

Kirsty – Team Organiser – PowerPoint

IT Tutor Led, Organisations Testimonials, Powerpoint Seminars

” I would like to thank you for giving me this unique opportunity to change my life and get a good job as a bookkeeper.
To be honest, as a foreigner I was scared at hat the course would be too hard to study and understand but I decided to take this challenging opportunity and improve my skills.
The training materials were amazing. They were very well presented and easy to learn. However the greatest advantage was the Training Supervisors. At any point when you are stuck with the subject or do not understand the questions then all you have to do is ask and all the help you need is there for you.
After I completed just three of the modules I decided to look of a job as a part time bookkeeper and I was in seventh heaven when I was offered a job before I had even finished my course.
The knowledge I have received from Pitman has helped me to develop my skills and improve my financial situation.
I strongly believe that anyone with a bit of discipline, patience and effort can change their lives for the best with the help of Pitman Training.”

AKS – Accounting Technician Diploma

Book-Keeping, Private Individuals

Very good, no improvements to suggest. Marion was very knowledgeable and friendly.

Joyce – Governance manager – Better Business Writing

Better Business Writing, General PD, Organisations Testimonials

“I successfully completed Executive PA Diploma at Pitman in 2013. With the help of Pitman training I also gained Microsoft 2010 Master Qualification which enabled me to become a confident and proficient administrator in record times.
But most importantly, Pitman training changed my life, forever and beyond I could have ever imagined. I did not have a job and had a very low self-confidence. It took me a while to have a courage and sign up for the advanced course that I had chosen, but I never looked back since that moment and everything in my life went on from strength to strength.
The staff became my second family and I would like to thank you for making me a better person. Every day you were transforming a young girl into a confident successful woman. We, as students are so lucky to have you.
After completing Pitman I was working for a Law Company, Edinburgh College and sat further exams that enabled me to progress further in my career.
I have recently been accepted for the position of Sales Consultant with Travelex. It took me just 7 days to get approved for the job since I saw the vacancy at the Job Fair and had a phone call to congratulate me for getting the job!!
I owe a lot in my life to Pitman Training. It truly changes lives, it gives confidence in your professional abilities, provides you with necessary qualifications to get that Dream Job!!”

DT – Executive PA Diploma

Executive PA, General Courses, General Diploma, Private Individuals

The skills that I learnt on the course come up time and time again on a daily basis and I am sure that the diploma on my CV has ensured interviews for a number of job applications.

L B – PR Assistant

Private Individuals

No Improvement required. Speed, clarity and technique ideal. The trainer was excellent!

Wendy – Receptionist – Meetings and Minutes

General PD, Meetings and Minutes, Organisations Testimonials

“I studied the Microsoft Fast Track Diploma and the computer keyboard skills course two years ago. At the time I was completing my Open University degree, and panicking because I had to submit a properly- bound word-processed project, including diagrams taken from scientific journals and I barely knew how to switch the computer on! In my first session I was advised to undertake the introduction to Windows course first because I didn’t have even the very basics.
Having overcome that first hurdle, I really enjoyed the course. The supervisors were really helpful and patient, and never made me feel that I was being stupid, even when I was! I got a distinction for the diploma, and first class honours for the degree. I am now studying for an MSc at Edinburgh University, and I don’t know how I’d cope without the IT skills I gained through the diploma. Even though I’ve forgotten a lot of what I learned through lack of use, I feel I have so much more confidence to try things I would not have attempted before.
My typing speed will never set the world alight, but compared to my former two-fingered jabbing it’s brilliant. Even my teenage daughters have stopped laughing at my efforts!
Thanks to Pitman for a real confidence boost!”

GD – Fast Track Diploma

General Diploma, Microsoft Office, Private Individuals

First time being in Marion’s course and was an excellent experience, I need more!

Linda – Centre Manager – Conflict Management

Conflict Management, General PD, Organisations Testimonials

I found the course to be excellent, hard to think of any improvements that could be made.

Derek – Finance Manager – Better Business Writing

Better Business Writing, General PD, Organisations Testimonials

The course content was clear and relevant. I met the objectives I came with.

Leanne – Sales Executive – PowerPoint

IT Tutor Led, Organisations Testimonials, Powerpoint Seminars

The trainer was very responsible and a very clear communicator. Paid attention to what people in the group said and made the day enjoyable and very worthwhile.

Kenneth – Faculty Head Sciences – Time Management

General PD, Organisations Testimonials, Time Management

Marion was excellent. Kept us all motivated. Structured the session well. Looking forward to attending another one of Marions training workshop.

Natalie – Executive Assistant – Report Writing

General PD, Organisations Testimonials, Report Writing

“I really enjoyed the Diploma which I am sure will improve my career prospects. I am looking forward to putting what I learned into practice.”

CC – Diploma

General Diploma

“I relocated to Scotland after teaching English abroad for 15 years. Unable to find similar work here, I spent an anxious 12 months as an office temp, eventually gaining a permanent position as an admin assistant at a law firm in Glasgow. I carried out the usual range of tasks – photocopying, filing, distributing faxes. Although happy to have a job and appreciating its positive qualities, I felt held back – both in my own workplace and on the job market as a whole – by my lack of IT and keyboard skills.
One happy day I made an appointment to see Linda Morrison at the Glasgow Pitman Training Centre. Linda understood my frustration and recommended the Diploma in Business Skills, a qualification that combined basic keyboard training with Microsoft Office courses, plus Effective Business Communication and an elective (from a wide range of options, I chose ‘Get Into HR’).
There were eight modules in all and the sessions had to be fitted in around a full-time job and busy family life. Ultimately I took 18 months to complete it all but felt very proud when I took home my Diploma. I’m still working for the same firm but now run the library and deputise for the Archivist in his absence. My daily work is far more interesting and varied than it once was, and that fact – combined with the high unemployment brought about by the recession – means that I’m not interested in changing jobs in the foreseeable future. Nonetheless, it’s crucial to be flexible in these hard times and to be able to offer additional skills if need be. I don’t regret the time and energy I put into my courses – they’ve given me tremendous self-confidence and a great sense of relief that I’m no longer left behind or marginalised by my lack of knowledge.
I’ve already recommended the Glasgow Pitman Training Centre to a number of friends and am happy to do so again. I’d also like to put on record my thanks to all the staff for their cheerful help and unfailing moral support throughout my training.”

MF – Diploma

General Diploma, Private Individuals

‘’Just to thank you again for the excellent course. It was at just the right level and I really appreciated being able to attend without having done the previous one.Too many courses insist on a progression through levels with certificates rather than accepting experience. Callum presented the course at a very good pace giving plenty of time for questions.Definitely the best computing related course I have attended!’’

Excel level 2 C M——-National Trainer

IT Tutor Led, Organisations Testimonials

“After 12 years working for an airline I decided to make a career change and started looking into various training companies. I selected Pitman Training based on their helpfulness and support.
I started studying in August of 2007 and initially signed up for Comptia’s A+ to ensure I was making the right choice. After completing this with the great help I got from John and Martin I then went on to study for my MCSA.
Before completing my course I started applying for a few jobs and was lucky to secure a position with BCF Technology as an IT support engineer. I have no doubt that taking this course had a lot to do with their decision.
Throughout my involvement with Pitman Training I received nothing but encouragement from all the staff and fellow students, which certainly made learning easier and more enjoyable. I wouldn’t hesitate recommending Pitman Training to anyone that asked and will be using them for any future training I may need to undergo.”

MM – IT Technical

IT Technical, Private Individuals

“I first enrolled for a computer course in January 2013, I only had very limited knowledge and knew I had to get more advanced skills. I started with word then decided I was enjoying my course and chatted with Linda the Manager regarding what options I should take and that would be best for me in the working environment, so we decided on Office Diploma.
I had just been made redundant from the Airline Industry, which had been my life for the last twelve years, so I knew I wanted to change my career. I had realised that IT skills are so important as I had now started looking for work and realised very quickly that the job market was very competitive.
I have not mentioned this till now but I am visually impaired and have been since birth so having a disability makes it even more difficult for employers to consider employing a disabled person, when so many abled bodied people are available so the training I received was incredible, the one to one help that the Glasgow ladies gave me was amazing I am surprised I never turned them to drink, but nothing fazed them they provided me with Zoom text and large print books and test papers. I was not very successful at school and the thought of taking exams really scared me but they sat me down and told me I could do it just take my time and they were right I managed to complete my Diploma.
I am now working for a charity called Momentum on the east side of Glasgow on a six months contract which was arrange through another charity to give me some office experience.
I enjoyed every day in the Glasgow office such a lovely atmosphere and such kindness that I was shown was just incredible and gave me a new found confidence.
Thank you team Glasgow, you’re the best.”

DB – Word and Microsoft Office Plus Diploma

General Diploma, Microsoft Office, Private Individuals

I found learning at Pitman Training was enjoyable, which makes all the difference. It was probably one of the best decisions I have made in the last decade.

S E

IT Tutor Led, Private Individuals

“I just wanted to write and say how much I enjoyed the medical terminology course, and also the medical audio word processing.
After spending the last few years as a carer looking after mum, even the thought of part-time work was daunting. At the time I started the course I was not confident to look for work, but the more I went into the “office” the more my confidence grew.
The Pitman Centre in Glasgow is a very casual/informal office environment, with absolutely no pressure and time for tea/coffee whenever I like.
All I had to do was book my time in advance and I felt I had complete control of my own time for studying. I also continued the learning at home in between visits to Glasgow.
It is absolutely incredible the difference I feel at the end of the course to when I first started.
I am now looking forward to finding suitable part time work alongside my carer role, and feel I have gained the confidence to become a valuable member of the team at my local hospital.
Thank you again for all your assistance.”

EC – Medical

General Courses, Medical, Private Individuals

“I studied the Legal Secretarial Diploma with Pitman because I wanted to have some formal IT qualifications and was interested in finding work in the legal or property sector. Before taking the course I was doing housekeeping and cleaning work and I had decided I wanted to look for something with a more administrative focus.
I had used computers a lot before doing the diploma but I now feel like I have a much better and more organised understanding of programmes like Microsoft Word and Excel and I am confident enough to experiment with them.
I thought I could already type very well but I am so much faster now that I’ve done the Typaz and speed development courses.
I have just been offered a job as a Plans Officer with Registers of Scotland through the Pertemps agency. I wouldn’t have been able to apply for this job without my Pitman diploma.
I would definitely recommend Pitman to others, especially other graduates, because it gives you more confidence and more options. I liked being able to work at my own pace and the supervisors in the training room were really helpful with all my modules.”

HB – Legal Secretarial

General Diploma, Legal Secretarial, Private Individuals, Secretarial Diploma

I have a better understanding of how to manage conflict in the work place, and how to be more confident.

Ann – Staff nurse – Conflict Managment

Conflict Management, General PD, Organisations Testimonials

Upcoming Events

April 29

All day

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

May 7

All day

There are no events on this day.

There are no events on this day.

There are no events on this day.

May 13

May 13 @ 9:30 am - 4:30 pm

There are no events on this day.

There are no events on this day.

There are no events on this day.

May 21

All day

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

May 28

All day

There are no events on this day.

There are no events on this day.

Choose your centre

Your details

Course details

Course subjects

Courses by title

Diploma subjects

Diplomas by title

SQL for Data Analysts