Introduction to SQL


Training

Introduction to SQL

1. Introduction

Exegetic Analytics is a Data Science consultancy specialising in data acquisition and augmentation, data preparation, predictive analytics and machine learning. Our services are used by a range of industries from Education to Security, Food Delivery to Politics. Our consultants are based in Durban and Cape Town and we engage with clients all over the world. Our products and services are used by a multitude of industries including Aerospace, Education, Finance, Food and Transport.

Exegetic Analytics also offers training, with experienced and knowledgeable facilitators. Our courses focus on practical applications, working through examples and exercises based on real-world datasets.

All of our training packages include access to:

  • our online development environment and
  • detailed course material which participants will have continued access to even once the training has concluded.

For more information about what we do, you can refer to our website.

These are some of the companies who have benefitted from our trainning:

Take a look at our full list of courses to see what other training we have on offer.

Contact Us

If this proposal is of interest to you or you would like to hear more about what we do you can get in touch on training@exegetic.biz or +27 (0)73 805 7439.

2. Course Description

If you want to build a successful career in Data Science, you’ll need to learn the basics of SQL.

Details

Duration 1 day
Who should attend? The course is suitable for anybody who needs to work with data in a relational database.
Objectives In this course you’ll learn how to perform CRUD (Create, Read, Update and Delete) operations on a relational database.
Outcomes Participants will be able to create and populate tables, perform moderately complex queries, update and delete records on a relational database.
Requirements Familiarity with spreadsheets will be helpful but not essential.
Setup

Return to our list of courses.

Course Outline

3. Course Outline

Data Query

Using SQL to execute queries against a Relational Database.

  • What is SQL?
  • SQL syntax
    • Code layout
    • Comments
  • Retrieving data using SELECT
    • Grabbing all the fields
    • Selecting specific fields
    • Aliases
  • Selecting specific records
    • Just the first few results
    • WHERE for filtering
    • Logical predicates
    • Matching portions of strings with LIKE
    • Checking for set membership with IN
    • DISTINCT
    • CASE
    • Working with missing (NULL) data
  • Sorting with ORDER BY
  • Aggregation
    • GROUP BY
    • Selected functions for aggregations: MIN, MAX, COUNT, SUM and AVG
    • Filtering after aggregation with HAVING
  • Join
    • Why normalise?
    • INNER JOIN
    • LEFT JOIN, RIGHT JOIN and FULL JOIN

Data Definition

Using SQL to create the structure of a Relational Database.

  • CREATE a database
  • Tables
    • CREATE a table
    • Column types
    • Constraints
      • NOT NULL
      • UNIQUE
      • CHECK
    • Index
    • Primary and Foreign keys
    • Auto increment
    • Default values
  • Cleaning up
    • Dropping a table
    • Dropping a database

Data Manipulation

Using SQL to manipulate data in a Relational Database.

  • INSERT - Putting data into tables
  • UPDATE - Changing existing data
  • DELETE - Removing data

Book now!

Training Philosophy

Our training emphasises practical skills. So, although you'll be learning concepts and theory, you'll see how everything is applied in the real world. We will work through examples and exercises based on real datasets.

Requirements

All you'll need is a computer with a browser and a decent internet connection. We'll be using an online development environment. This means that you can focus on learning and not on solving technical problems.

Of course, we are happy to help you get your local environment set up too! You can start by following these instructions.

Package

The training package includes access to
  • our online development environment and
  • detailed course material (slides and scripts).

Return to our list of courses.