Banner Default Image


Data Analysis with SQL Queries - 1 Day Workshop

Monday, 29 July 2019

11:00 to 17:00

PCWorkshops Manchester, Peter House, Oxford Street, M1 5AN


Provides the knowledge and skills needed to retrieve and analyse data held in a database.  

Who Should Attend

Anyone who needs to understand and use SQL to manipulate a database. There are no formal pre-requisites for this course, although an understanding of databases and exposure to information technology in general would be useful.  

Course Outline

Relational Database Concepts

  • What is a Relational Database?
  • Tables, Rows and Columns
  • Indexes, Primary Keys and Foreign Keys
  • Data Types
  • The Data Dictionary
  • Getting Started

SQL Language Essentials

  • The Select Statement
  • The Select and From Clauses
  • Conditions and the Where Clause
  • The Order By Clause
  • Arithmetic Operations
  • Column Aliases
  • Practical Exercises

Summarizing and Grouping Data

  • Aggregate Functions
  • The Group By Clause
  • The Having Clause
  • Practical Exercises

Querying Multiple Tables

  • Joining Tables with Inner Joins
  • Column Qualification and Table Aliases
  • Outer Joins, Self Joins, Alternative Join Syntax
  • Practical Exercises

Additional SQL Features

  • Combining Queries
  • The Union, Intersect and Minus Operators
  • Basic Subqueries
  • Practical Exercises


What can/can't I bring to the event? 

You can bring your own Laptop,  data and examples, but let us know beforehand

Refreshments: Tees, coffees but no lunch

Certificates:  Certificates included

Included: Notes. Query examples and exercises. 

After course support: 1-hours online revision session

Click the link below for costs and to book your place!