Nestled within the structure of the Polaris database there is an unassuming folder that may confound and confuse someone new to Polaris SQL. The Polaris views can be a strange place, with some oddities built right into the code. But this folder is of fantastic tools that can help make your life easier whenever you find yourself writing a query. We'll dive deep into these views and discover what they do, how they can help you, and how (and why) you can make your own.
This presentation is aimed at beginning and intermediate Polaris SQL users, but everyone is welcome!
Denver Public Library had been watching Leap functionality evolve from the sidelines for several years. In 2023, we decided the time was right to jump in and teach hundreds of front line staff at our 26 branch system to swim these new waters. Why not? We were only in the midst of a major reorg and several large-scale building renovations.
Come learn our approach to leveraging circumstances and timing to help Denver Public Library Leap forward.
Messy metadata. We've all got it. (In fact, if you don't, please come to this session and tell us how you reached that pinnacle of perfection!) In this panel, cataloging and metadata enthusiasts will discuss how we clean-up and maintain our Polaris database through monthly tasks, SQL searches, and even soliciting help outside of tech services. We'll discuss how to plan, prepare and tackle bigger projects like changing the classification of an entire collection or subject heading changes. And, of course, how to do it all while the librarians keep ordering and the materials keep arriving. Panelists will include members from hosted and unhosted sites, as well as consortia and stand-alone libraries.
This presentation aims to share training strategies to make SQL Searching in the Find Tool more accessible for more library staff. In-house training on this powerful Polaris tool can be engaging and helpful. However, several pitfalls often seem to plague 101 Trainings: not directed at front line staff, don't reduce the intimidation associated with 'coding,' or struggle to convey how it can be useful. Our library held a session on Find Tool SQL for our annual Staff Education Day, which is transitioning to regularly available training due to staff interest. These trainings, along with redesigning our circ training modules, have provided insight into more effectively introducing complex information to a wide staff audience.
Dive into SQL with Our Beginner’s Guide! Discover the essentials of SQL, explore the Polaris database structure, access key documentation, and learn a basic query.