SQL (Structured Query Language) is a programming language that is used for managing and interrogating data stored in relational database systems. It is most useful for managing large datasets where the data are held in multiple linked tables. There are a wide range of free and proprietary SQL user interfaces.
SQLite and MySQL are both open source software packages that can be downloaded and used for free. SQLite can run on your own device whereas MySQL requires a server to run. You can download DB Broswer for SQLite from: https://sqlitebrowser.org and MySQL from here: https://dev.mysql.com/downloads/windows/installer/8.0.html. If you need guidance on choosing and installing an SQL user interface you can contact your local IT supporter.
Please note that O'Reilly deletes content in December and June. If you are linking to courses on this platform we advise that you check that they are still running in January and July of each year.
You can search for more courses and resources for learning SQL on O'Reilly Learning. Enter 'SQL' into the search bar on the home page. We recommend that you filter the results:
If you cannot see 'Learning Path' and 'Video' as an option under the Format filter you should delete the site cookies and refresh the page.
These courses are suitable for researchers who are completely new to using SQL. Courses that require you to install SQL interface software will go through the steps to install the relevant programme. If you are using a University-managed PC please see the access information at the top of this page.
This is short introductory Learning Path course that covers:
This is a video course for those new to SQL. However, much of the teaching is on SQL Server rather than one of the free downloadable platforms. Nevertheless, the course is clearly taught and will take you through the basic syntax needed for you to get started with using SQL for your research. The course covers:
This is a learning path course which teaches using SQLite (SQLIte Studio). This is a getting started learning path course covers the following topics:
This is a video course for those who already have access to an SQL programme. We would recommend this as a second 'getting started' course, or one that you dip into to learn to use specific commands as you might not need to use all of the skills presented within this course. The course using the MySQL software that you can download from: https://dev.mysql.com/downloads/windows/installer/8.0.html. You will need to ask your IT supporter to load this onto your device if you are using a University manager PC or laptop. The course covers:
For those who already have a basic understanding of SQL there are a range of learning path and video courses to expand your skills and knowledge of SQL. Many of these are quite ‘techy’ in nature and some concentrate more on database design and management than on using SQL for manipulating data. The courses below provide you with some hands-on skills for using SQL for your research and you can search for other learning path and video courses using the search function on the platform.
SQL for Analytics – Expanding Analytics in Relational Databases. This learning path course will expand your use of SQL and covers:
This video course assumes a basic knowledge of SQL and will increase your knowledge and skills base to improve your SQL programming. The course covers:
This is an intermediate to advanced course for experienced users of SQL. It has a strong focus on working with data from multiple tables with a variety of different join statements. The course covers: