SQL Training Resources for Developing Queries for the LDP Analytics Repository
The following links provide some helpful training resources for learning to write SQL queries to contribute to the LDP Analytics SQL report repository on GitHub. These queries are written for use with the implementation of the FOLIO Library Data Platform (LDP) at any institution using the FOLIO application software as its ILS/LMS (Integrated Library System or Library Management System). If you have developed a report prototype and you are ready to start writing queries, please follow the steps in the Report Prototypes and Contributing report queries to ldp-analytics pages in the Reporting SIG wiki for guidance on structure, naming, and posting to the report repository.
| Training Resource | Description | Link |
|---|---|---|
| Relational Algebra | This course in relational algebra provides an introduction to the algebraic query language that provides the formal foundations of SQL (Structured Query Language). | https://lagunita.stanford.edu/courses/DB/RA/SelfPaced/about |
| Introduction to SQL | This course is a basic introduction to SQL (Structured Query Language). | https://lagunita.stanford.edu/courses/DB/RA/SelfPaced/about |
| Datacamp | This site provides good introductory SQL courses for a modest fee. | 4 courses on SQL: https://www.datacamp.com/tracks/sql-fundamentals pricing page: https://www.datacamp.com/pricing |
| Linked In Learning | Linked In Learning provides access to several courses on SQL at many levels of expertise. | https://www.linkedin.com/learning/ |
| Collections Use Query Walkthrough | In this video, LDP Developer Angela Zoss walks through the process of writing the Circ Item Detail report query. | https://drive.google.com/open?id=1DtRVguXW-OG90tVi2SikH9MVALcJY46b |
| Using the LDP-Analytics GitHub Repository Walkthrough | In this video LDP Developer Angela Zoss walks through the process of using GitHub to develop and share SQL queries for the LDP-Analytics repository. | Forward video to start at 22 minutes: https://drive.google.com/open?id=1PntzWZ8hWtE5xiA2dtQq3vFYgn3jv9Sb |
| CodeAcademy Learn SQL course and SQL Commands | A course called Learn SQL and a list of SQL Commands | |
SQL Murder Mystery | The SQL Murder Mystery is designed to be both a self-directed lesson to learn SQL concepts and commands and a fun game for experienced SQL users to solve an intriguing crime. | https://github.com/NUKnightLab/sql-mysteries |
| Select Star SQL | "This is an interactive book which aims to be the best place on the internet for learning SQL." | https://selectstarsql.com/ |
| SQL for Non-Technical People | https://datapractices.org/courseware/2_7.html | |
| Library Carpentry | introduction to SQL | https://librarycarpentry.org/lc-sql/ |