Search
Search type

Cathie Marsh Institute for Social Research (CMI)

SQL Essential Skills

Date: 21 November 2019 and 14 May 2020
Time: 1pm - 4pm
Instructor: Peter Smyth
Level: Introductory
Fee: £60 

Humanities PGR students at The University of Manchester can apply for a methods@manchester bursary to help cover their costs. All applications will be considered on a case-by-case basis and applicants will be required to provide a supporting statement from their supervisor. Applications for bursaries must be submitted at least two weeks in advance of the course date; applications submitted after this time will not be accepted. Retrospective applications cannot be made if courses have already taken place or payment has already been made.

Please click here to make a booking. For queries about methods@manchester bursaries, contact methods@manchester.ac.uk (please note, you must have a confirmed place on the course before requesting a bursary application form). For any other queries about short courses, please contact cmi-shortcourses@manchester.ac.uk.

Please note: this is not guaranteed and is considered on a case by case basis. Please contact us for more information.

Outline

This SQL Essential Skills workshop is for any researcher who has a larger amount of data they want to pre-process (clean, reduce, summarise),  before further analysis. No prior computational experience is required. This hands-on workshop provides an introduction to SQL using the DB Browser for SQL environment as well as illustrating how SQL and Relational databases can be used directly from a programming environment such as Python or R.

Course objectives

On completion of this workshop, the participants will be able to;

  • Install the DB Browser environment on their own machine
  • Understand what a database is
  • Know what the key components of a relational database are
  • Use basic SQL commands to retrieve data from database tables
  • Perform basic data analysis using SQL commands
  • Perform joins on two or more tables and understand the results
  • Access a database table directly from Python or R

After completion of this workshop, the participant will be in a position to create their own Relational databases by importing simple csv files of data. Perform basic data cleaning, manipulation, reduction and summaries of their data using SQL statements.  Prepare large datasets for use in other programming environments.

Prerequisites

None

Recommended reading

None

About the instructor

Peter Smyth is a Research Associate at the University of Manchester, based in the Cathie Marsh Institute. He has spent 35 years working in IT at various large and small commercial organisations before taking an MSc in Big Data Analytics at Sheffield Hallam University and moving into academia. In his previous roles, he used any convenient programming environment to hand to solve problems. Now he teaches a variety of programming languages to help others to do the same.

He is a qualified Data and Software Carpentry instructor.

Apply