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

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	https://www.codecademy.com/learn/learn-sql https://www.codecademy.com/articles/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/