SQL for TMS Users

Gallery Systems has been helping the finest museums and cultural institutions become more efficient and streamline their daily workflows since 1981. We provide fully integrated solutions for collections management, web publishing, conservation documentation, and digital asset management. Gallery Systems serves more than 800 clients worldwide, from private collections and museums, to corporate and university archives.

Gallery Systems

Become proficient in Structured Query Language (SQL) and speed up your TMS work. Learn how to create queries and navigate your TMS database.

SQL for TMS UsersThe SQL for TMS Users course is currently offered to TMS for Windows and TMS Collections users. Please see Upcoming Dates for more details. <h3>Upcoming Dates</h3><ul><li>October 20, 2026 | 9:30 am – 4:30 pm ET</li></ul>*Registration closes 10 days before the training date. <h3>Description</h3>Structured Query Language (SQL) is the query workhorse behind every TMS search, and can be used to manage data at the database level. This 1-day course is an all-in-one guide to becoming proficient in SQL and learning the basic functions that will speed up your TMS work. This is a hands-on class; participants are provided with their own fully configured workstation to use during training.Get the most from your SQL for TMS Users course and save on traveling by also signing up for SQL Server Reporting Services (SSRS) Report Design class, held on the following day. <h3>Audience</h3>The 1-day SQL for TMS Users course is recommended for Registrars, TMS database managers, TMS database administrators, and all users who utilize advanced search features in TMS for Windows or TMS Collections. This can include:<ul><li>New users (e.g., new staff members, students in college/masters programs, soon-to-be job seekers, etc.)</li><li>Existing users (who want to refresh their TMS knowledge or learn about the new advancements from a recent upgrade)</li></ul> <h3>Prerequisites</h3>This course assumes the user has little to no SQL experience. However, experienced SQL users who wish to expand their understanding or learn additional functionality will also benefit from taking part in this course. <h3>Course Objectives</h3>Give the user a working understanding of SQL and the ability to create simple queries, build on queries, and navigate the TMS database. <h3>Training Location</h3>Online <h3>Recommended Setup</h3>The online version of this course has been designed with a hands-on approach. For an optimal learning experience, we strongly recommend the following setup:<ul><li>A strong internet connection</li><li>1 monitor for viewing the training (a computer or a large tablet)</li><li>1 computer monitor for working in your TMS database</li><li>A hands-free phone or a headset</li><li>Ability to use remote desktop (MAC users will need app from Mac App Store)</li></ul>*Each participant receives a unique demo database login. <h3>Fee</h3>$650 USD*Please Note: Each attendee must register individually.Are you a student interested in taking an online training? Gallery Systems offers special discounts for students with a valid school ID or proof of enrollment. <a href="https://www.gallerysystems.com/contact/" title="https://www.gallerysystems.com/contact/" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">Contact us</a> to request more information.<h3> </h3><h3>Payment Options</h3>We accept payment by Credit Card. Please reach out to us at events@gallerysystems.com if you need further assistance.<h3> </h3><h3>Refund Policy</h3>Attendees are eligible for a full refund up until 2 weeks prior to the training start date. Registrations can be rescheduled as space permits.

SQL for TMS Users

More events from Gallery Systems

Follow organizers to get events picked for you

SQL for TMS Users

More events from Gallery Systems

Follow organizers to get events picked for you

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.