SQL for Data Analysts

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.

SQL for Data Analysts

Your details

Training Centre

Hidden
Hidden
Hidden
Hidden
Hidden
Hidden

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.

Event Series Speedwriting

Speedwriting

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

This course is ideal for anyone involved in taking notes at all levels in both work and personal life. The course is particularly beneficial to those for whom taking minutes...

Event Series Power BI Introduction

Power BI Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

Learn how you can leverage Power BI to easily build reports and dashboards with interactive visualizations. Connect to and visualize any data using the unified, scalable platform for self-service and...

Event Series Telephone Techniques

Telephone Techniques

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

This 1-day workshop has been developed for people who would like to improve their telephone communication skills. It is particularly aimed at those who use the telephone as an important...

Event Series Leadership Skills

Leadership Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For managers who are developing into senior leaders. You are even less involved in the day-to-day delivery of the work; your success depends on your ability to manage your managers...

Event Series Meetings and Minutes

Meetings and Minutes

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

For anyone who organizes and takes minutes at meetings and those who would like to do this role to a professional standard. What you will learn: The difference between formal...

Adobe Photoshop

For individuals who are new to Photoshop or have only used Photoshop for limited tasks. During the course you will learn the fundamentals of the Adobe Photoshop Creative Cloud from...

Event Series PowerPoint Introduction

PowerPoint Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For Individuals who have never used PowerPoint or have only used it for limited tasks. At the end of the course, you will be able to create professional-looking presentations. What...

Event Series Word Intermediate

Word Intermediate

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For Individuals who are already using Word to an introductory level – this course will streamline and perfect your Word skills by teaching you intermediate features available within the Word...

Testimonials

Upcoming Events

Calendar of Events

M Mon

T Tue

W Wed

T Thu

F Fri

S Sat

S Sun

1 event,

2 events,

2 events,

3 events,

0 events,

0 events,

2 events,

3 events,

Adobe Photoshop

Event Series

2 events,

2 events,

1 event,

0 events,

0 events,

3 events,

Adobe Illustrator

Event Series

2 events,

1 event,

2 events,

1 event,

0 events,

0 events,

0 events,

2 events,

2 events,

1 event,

0 events,

0 events,

0 events,

0 events,

1 event,

- Event Series

Speedwriting

1 event,

1 event,

0 events,

0 events,