Update concerning COVID-19 – Distance Learning (home study) courses are still available. Find out more about distance learning at Pitman Training

Update concerning COVID-19 – Distance Learning (home study) courses are still available. Find out more about distance learning at Pitman Training

SQL for Data Analysts

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 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.

Award and Associated Qualifications

Awarded 44 CPD points upon successful completion

Start Date

Flexible

Study Type

in centre, Online, or a combination

Training Type

course

Duration

44 hours

Request your Course Factsheet

For further information and pricing please fill in your details below and we will get back to you as soon as we can. Or, call the team on +254 (0)743144753.

    About this 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 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

    Aims and Objectives

    Pre-Requisites

    Finance Options

    Career Path

    Request a Course Factsheet Now!

    Simply enter your details below to receive a copy of the course details.

      Please enter your email address


      What's the difference?

      We offer a range of training packages in a range of subject areas and can offer blended learning opportunities to best meet your needs

      Course

      Our courses are practical in nature and focus on a single subject and can last anywhere from a few hours to a few days.

      Diploma

      Diplomas are designed to give you a complete skillset mapped to a specific career path and contain a number of core and elective courses