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.

April 2024

April 29 - April 30 Microsoft Project Complete – 2-day course

Microsoft Project Complete – 2-day course

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

April 29 - April 30 Project Management Principles

Project Management Principles

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 2024

May 1 @ 9:30 am - 4:30 pm Better Business Writing

Better Business Writing

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 2 @ 9:30 am - 4:30 pm Personal Development Workshops

Personal Development Workshops

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 2 @ 9:30 am - 4:30 pm Management Skills

Management Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 7 @ 9:30 am - 4:30 pm Excel Intermediate

Excel Intermediate

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

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

Time Management

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 7 Adobe Photoshop

Adobe Photoshop

May 8 @ 9:30 am - 4:30 pm Influencing Skills

Influencing Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 8 @ 9:30 am - 4:30 pm Report Writing

Report Writing

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 9 @ 9:30 am - 4:30 pm Excel Intermediate

Excel Intermediate

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 9 @ 9:30 am - 4:30 pm Personal Development Workshops – Assertiveness

Personal Development Workshops – Assertiveness

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

Testimonials

‘Couldn’t improve, one of the best courses I have ever attended.”

Susan K—–Director—-The PA Exchange

Organisations Testimonials, Presentation Skills

Julie was an extremely good deliverer of the course content, very knowledgeable. I noticed she never failed to answer any questions and had offered solutions to all issues put to her.

Paul – Scientist – Supervisory Skills

General PD, Organisations Testimonials, Supervisory Skills

“I had been having trouble making the databases at work behave themselves but every problem that I had been having has been dealt with today.”

Access Level 2 A M——-Administration Co-ordinator

IT Tutor Led, Organisations Testimonials

Very good! Relaxed atmosphere which helped. I have come away with many ideas.

Lyndsay – Management Trainee – Executive PA Seminar

Executive PA Seminar, General PD, Organisations Testimonials

I have now come to the end of my courses in finance, and I should like to say how impressed I was with the quality of training I received through them all.
The knowledge I have gained has consolidated and enhanced my previous experience in a number of accounts jobs over the years, and given me new confidence in my skills and abilities to truly pursue bookkeeping as a specialist career. There are certainly many businesses out there that really need competent “accounting technicians”.
As soon as I had completed my Sageline 50 Accounts course, I got a second job using both this training and the previous course I completed, Excel Proficient. My training in Manual PAYE and Sage Payroll has enabled me to take over the wages responsibility in my other part-time bookkeeping job, and I have also set up a stock control system on the laptop using Excel spread sheets.There is also a possibility of taking on a further job working from home a couple of afternoons / evenings a week, doing the accounts for another local business using Sage on a laptop.
I am delighted with the “instant” results my training with yourselves have produced – the investment of time, money and effort was definitely worthwhile, now that I am reaping rewards well beyond my original expectations…. even at my time of life (over 50), retraining to specialist level in accounts has been an excellent decision.
THANK YOU!

DG – Accounting Technician Diploma

Book-Keeping, Private Individuals

Knowledgeable, Approachable and effective communicator.

Margaret – Care home manager – Assertiveness

Assertiveness, General PD, Organisations Testimonials

‘’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

“I just want to thank you and your staff for all the help you offered me while I was studying my Executive PA Diploma at Pitman in Glasgow.
Before doing my training with Pitman I had studied ACCA but did not have much work experience, by doing the course I gained valuable skills that are now helping me at my new job at one of the big accountancy firms.
What I liked best about the course was flexibility of the course, I was able to choose the time and hours I did the course. The staff were very helpful and I will not hesitate to recommend this course to any of my friends.
Thank you again for all your help.”

SK – Executive PA Diploma

Executive PA, Private Individuals

“When I started my Executive PA Diploma last September I was quite unsure what direction my career was going in, I guess you may hear this fairly often, however as the course progressed and my confidence increased I felt ready to look for a PA Executive job. In January I was very successful to be offered the role PA to the Senior Dental Advisor at Practitioner Services (part of the NHS) which I believe my Pitman training played a pivotal part and gave the company confidence to employee me.
I have now completed my three month contract at Practitioner Services, so again I had to think about the direction my career would go. So, I am delighted to let you know that I have been offered a permanent job as a Training Co-ordinator, taking over all the logistics and administration associated with the training events and seminars that the Company delivers and I will be working directly with the Managing Director.
Therefore, I would like to take this opportunity to thank you and your training administration team without whom none of this would have happened.”

LF – Executive PA Diploma

Executive PA, Private Individuals

Excellent trainer, made you feel at ease and felt comfortable to join in.

Laura – PA to Directors – Time Management

General PD, Organisations Testimonials, Time Management

Julie related ‘real life’ situations which I could relate to.

Paul – Problem Manager – Communication Skills

Communication Skills, General PD, Organisations Testimonials

Marion was really good and helped me to understand what I was doing and extremely fun.

Fiona – Trainee Administrator – Assertiveness

Assertiveness, General PD, 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

“Our Trainer was excellent, this is the most knowledge I have ever taken from a course.”

Carol—-Edinburgh Business School

Organisations Testimonials, Supervisory Skills

Will be taking a lot from the course back to the work place.

Graham – Home Manager – Conflict Management

Conflict Management, General PD, Organisations Testimonials

Very good training and very good facilities. The trainer was very competent, friendly, engaging and welcoming, very patient and good manner.

Andrea – Trainee Administrator – Excel

Excel Seminars, IT Tutor Led, Organisations Testimonials

I finished a Pitman Secretarial Diploma in 2008 and after one month working as a temp. I was lucky enough to be offered a permanent job as Clerical/Admin Assistant which is where I am still working now.
Learning to touch type at Pitman definitely helped to secure the job, and also having a certificate from all the units of the secretarial diploma which showed that I could use Microsoft Office programs competently.
I took the option to study from home as living in Perth , it meant I could fit in work around the kids school hours. Though I did enjoy going into Edinburgh occasionally to do Outlook, and Audio. The course was really straightforward, and the tests were an enjoyable challenge.
I love being able to touch type, and it will be useful for the rest of my life, in whatever job I do. I have even got my children started on the BBC’s cool typing lessons for kids, where singing animals encourage you, and I hope that they will be able to type by the time they are teenagers.
All the trainers at Pitman were really helpful, and always ready to explain things, when I phoned or emailed with questions.

GA – Secretarial Diploma

Private Individuals, Secretarial Diploma

Marion had great knowledge. I benefited from the examples provided. Great that Marion encouraged discussion, as the hints and tips will help me in my work environment.

Natalie – Executive Assistant – Executive PA Seminar

Executive PA Seminar, General PD, Organisations Testimonials

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

“I started doing a Secretarial Diploma at Pitman because I had been working in retail since graduating from university in 2008. I had pretty good admin skills but no qualifications and felt like I was stuck in a rut. Pitman was a perfect fit for me because I was working shifts at my job at Glasgow Science Centre and could come in whenever I was free.
At first I thought I was just going to be getting a qualification for skills I already had but I actually learned a lot more than I expected. Modules like Effective Business Communication were helpful and I did electives in Access and Introduction to Medical Secretary which was extremely helpful in getting my new job.
In May 2013, before I had even completed my diploma, I started my job as an Audio Typist for the NHS. I had been searching the NHS pages before I started my diploma and it took the help of Pitman to actually help me find a job. My typing and audio typing skills along with the medical terminology learned in Pitman have been essential in my progress within my job with my manager telling me she feels I have a career in the NHS ahead of me.
I just discovered today that I received a distinction for my diploma and am now thinking of where to move up within my new sector. Without Pitman, I don’t think I would have been able to get out of retail so I’m very happy to have chosen to take this course!”

EJ – Secretarial Diploma

General Diploma, Private Individuals, Secretarial Diploma

I am enjoying my new role as medical audio typist. Studying at Pitman Training was a good break from the every day world of work. I learned that some of the computer applications I’d heard of before were not as scary as I’d once thought!!

M M – Medical Audio Typist

Private Individuals

I am really enjoying the challenge of my new career and appreciate all that Pitman Training did to make it possible.

J M – Medical Secretary

Private Individuals

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

“In the last year I successfully completed and passed Sage Accounting and Sage Payroll Computer Courses with Pitman Training. Before my training I was looking for a job, but realised that I needed more qualifications in order to get my ideal job.
I am now applying for jobs and feel more equipped and confident. I am searching the job sites and sending my CV. I know it’s only a matter of time until I have the job I desire.
My learning time at Pitman Training was a very happy time for me. I felt warmly welcomed each day and this enabled me to learn quickly. The staff were extremely professional, friendly and helpful and the atmosphere was very relaxed. I so enjoyed my Courses and it really was learning made easy.
I wish to Thank each member of Pitman Training Staff. I have never enjoyed a learning experience as much as I enjoyed my time with you.
Many Thanks!”

GC – Sage

Book-Keeping, Private Individuals, Sage

I am now at the start of a great career in Networking, due mainly, to starting my MCSE course.

J M – Trainee Network Analyst

Private Individuals

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.

DT – Executive PA Diploma

“The training and facilities were both excellent.Callum was both patient and understanding to my level of knowledge.The course has certainly benefited me and in turn, my work.”

Excel Level 2 Lesley Allan——Sales Coordinator—–George Wimpey

IT Tutor Led, Organisations Testimonials

“Thank you for the excellent course and in particular your friendly and helpful staff. Being able to revise the course information and the convenience of the flexible hours made the learning much more enjoyable.”

SH – Diploma

General Diploma

From going from redundancy to this is just a great feeling! I actually love my job!

I C – Legal Secretary

Private Individuals

High praise. Marion drew from her own experiences which I appreciated. She was able to help us with our individual issues. She listed to us and adapted her training to suit our needs.

Alanna – Office Manager/PA – Executive PA Seminar

Executive PA Seminar, General PD, Organisations Testimonials

“I found the style of teaching, materials provided, seminars, the instructors’ behaviour and attitude, of excellent quality and standards. I am happy.”

SD – Executive PA Diploma

General Courses, Private Individuals

The small group to tutor ratio was very helpful. It was at a great location, lunch was a treat, the training was well-paced and clear. The trainer was very patient, not patronising (a relief) and very helpful.

Paula – Assistant Visitor Experience Manager – Word

IT Tutor Led, Organisations Testimonials, Word Seminars

Clear and easy to follow instructions.

Karen – Cashroom Assistant – Word

IT Tutor Led, Organisations Testimonials, Word Seminars

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

Very easy to understand, follow and very approachable.

Michelle – IT change manager – Assertiveness

Assertiveness, General PD, Organisations Testimonials

Everything needed was provided. Work booklets, pad, pen and pencil were all good quality.

Louise – PA – Speedwriting

General PD, Organisations Testimonials, Speedwriting

Great, helpful, friendly staff, good location easily accessible etc.

Sam – Customer Services Administration – Speedwriting

General PD, Organisations Testimonials, Speedwriting

The trainer was capable of explaining things so they were easily understood and answered all questions I had during the Intermediate Course.

Amy – Admin Assistant – Access

Access Seminars, IT Tutor Led, Organisations Testimonials

“I studied the Accounting Technician Diploma with Pitman Training in Edinburgh. I decided to do this course, as I was just about to be made redundant, and decided that I wanted to gain some new skills to help me when applying for a new job. I was also thinking about starting my own company, and thought that finance studies would never go wrong.
A couple of months after redundancy, I got a temporary post at SAMH, and then applied and got my current post as the HRD (Human Resources & Development) Administrator. Although I hadn’t completed the course when I got my job, the skills I had learnt so far has helped me out in my new job, as I have to monitor budgets and make monthly reports to my boss.
I enjoy learning at Pitman. You learn at your own speed, which makes it all much easier. This is the second course I’ve done at Pitman, and would recommend it to anyone.”

LM – Accounting Technician Diploma

Book-Keeping, Private Individuals

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

I know the Diploma qualification was a major selling point. Without my Pitman Training I would be lost at sea!

E W – PA

Private Individuals

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 trainer had an excellent general knowledge which helped with explaining things in the course.

Annette – Production and Accounts – Project Management Principles

General PD, Organisations Testimonials, Project Management

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

The trainer was excellent and took time to make sure we all understood what we were doing.

Louise – Commercial Manager – Word

IT Tutor Led, Organisations Testimonials, Word Seminars

Excellent trainer. Knowledgeable with a very pleasant and helpful manner.

Julie – Manager – Outlook

IT Tutor Led, Organisations Testimonials, Outlook Seminar

Like the style of the course, right amount of group and tutor led sections. I find the courses excellent, can’t think of anything to comment on. Thank you.

Sharon – HR Assistant – Influencing Skills

General PD, Influencing Skills, Organisations Testimonials

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 thought the Executive PA Seminar was just fantastic, our trainer was excellent, she was completely inspirational and motivational, she really knows her stuff and maintained your interest at all times. I would recommend this course to any PA who is looking to increase their confidence in knowing how best to deal with their boss, the assertiveness training in particular has proved to be very useful!
Overall, it proved to be an invaluable opportunity to gain useful skills and share experiences with other PA’s. I’m already thinking of which course I can go on next!

Hayley—–PA

Executive PA, Organisations Testimonials

“I started studying for a Secretarial Diploma with Pitman training in September 2013. After working as a mail room assistant for years, I wanted to move on to a better job with more opportunities.
I researched courses at various colleges but the hours weren’t suitable for me with a full time job. I liked the flexibility of studying with Pitman, it allowed me to study in my own time and at my own pace. At my first meeting with Linda we chatted about what kind of job I would like to do in the future and what kind of organisation I would like to work for. I had originally been interested in taking an ECDL course but after speaking with Linda we decided that a Secretarial Diploma would give me more opportunities of finding the job I was looking for.
I was very impressed with the course materials and facilities and found the course straightforward and easy to follow. The learning environment is very relaxed and girls are all very friendly and helpful. I have learned so many new skills while studying with Pitman and also learned to feel confident in my abilities. In July 2013 I started working as an administrator in an organisation that I have wanted to work in for several years. My new employer, the Scottish Police Federation was impressed by the qualifications I had earned and with the amount of my own time I had dedicated to studying for them. I love my new job and without all the help I received from Pitman Training I wouldn’t be in the position I am in now.
I want to thank all the staff for all the help you gave me and for making the time I spent at the training centre so enjoyable. I would recommend anyone to take a course with Pitman Training and wouldn’t hesitate to take another course if I feel I need to expand the skills I have learned in the future.”

NM – Secretarial Diploma

General Diploma, Private Individuals, Secretarial Diploma

Upcoming Events

There are no events on this day.

April 2

April 2 @ 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.

April 8

All day

There are no events on this day.

There are no events on this day.

April 15

All day

There are no events on this day.

There are no events on this day.

April 22

April 22 @ 9:30 am - 4:30 pm

There are no events on this day.

There are no events on this day.

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.

Choose your centre

Your details

Course details

Course subjects

Courses by title

Diploma subjects

Diplomas by title

SQL for Data Analysts