Introduction to SQL
Date:
25/02/2020
Organised by:
Cathie Marsh Institute
Presenter:
Peter Smyth
Level:
Entry (no or almost no prior knowledge)
Contact:
Laura Swift
0161 275 1980
cmi-shortcourses@manchester.ac.uk
Map:
View in Google Maps (M13 9PL)
Venue:
Humanities Bridgeford Street
University of Manchester
Oxford Road
Manchester
Description:
Outline
Part of Social Data Science Week, a collaboration between the Cathie Marsh Institute and methods@manchester. These courses have been designed for postgraduate researchers, giving you the tools to make use of free and open-source software, and techniques from the cutting-edge new discipline of social data science.
This ‘Introduction to SQL’ workshop is for any researcher who has a larger amount of data they want to pre-process (store, clean, reduce, summarise), before further analysis. No prior computational experience is required. This hands-on workshop provides an introduction to SQL using MySQL and the MySQL Workbench environment, both freely available. As well as illustrating how SQL and Relational databases can be used directly, we will also illustrate how to access the data from a programming environment such as Python or R or an application such as Excel.
Course objectives
On completion of this workshop, the participants will be able to:
- Install MySQl and the MySQL workbench environment on their own machine
- Understand what a database is
- Know what the key components of a relational database are
- Create their own database tables and load data into them
- Use SQL queries to retrieve data from database tables
- Use SQL queries summarise or aggregate data from database tables
- Perform basic data analysis using SQL commands
- Perform joins on two or more tables and understand the results
- Understand different storage approaches used in databases
- Access a database table directly from Python, R or Excel
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.
Cost:
£120/£60
Website and registration:
https://www.cmi.manchester.ac.uk/study/short/introductory/introduction-to-sql
Region:
North West
Keywords:
Quantitative Software, Excel, Python, R
Related publications and presentations:
Quantitative Software
Excel
Python
R