Program Title: SQL Basics for Polaris: Querying Data with the Polaris Find Tool
Track: Polaris
Program Description: This hands-on workshop introduces SQL concepts specifically tailored to the Leap/Polaris Find Tool, helping users move beyond canned reports and pre-built searches to create their own customized queries. Designed for staff who regularly work with Polaris data, this session demystifies SQL by connecting basic theory with real-world examples from the Polaris database.
Participants will learn how data is structured in Polaris, how SQL statements are built, and how to use them directly within the Find Tool. Through guided exercises and examples, attendees will practice writing and refining queries to identify records, uncover data patterns, and find potential data-cleanup opportunities. By the end of the workshop, attendees will have a clearer understanding of SQL fundamentals and the confidence to use it effectively within Leap.
No prior experience with SQL is required - just familiarity with using Leap/Polaris for everyday tasks.
Speaker/ Information: Matt Hammermeister. Director, Pinnacle Library Cooperative
Example Queries - WITH ANSWERS.docx (25.6 KB)
SQL Basics for Polaris - Workshop Slides.pptx (8.2 MB)
Additional Practice Queries.docx (27.5 KB)
Example Queries.docx (23.2 KB)