SQL for TMS Users

The SQL for TMS Users workshop is currently offered to TMS for Windows and TMS Collections users. Please see Upcoming Dates for more details.

Upcoming Dates

October 11, 2024 | 9:30 am – 4:30 pm ET (in-person, NYC office)

* Registration closes on September 29, 2024

Description

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.

Audience

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:

New users (e.g., new staff members, students in college/masters programs, soon-to-be job seekers, etc.)
Existing users (who want to refresh their TMS knowledge or learn about the new advancements from a recent upgrade)

Prerequisites

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 workshop.

Course Objectives

Give the user a working understanding of SQL and the ability to create simple queries, build on queries, and navigate the TMS database.

Training Location

The October 11, 2024 session will take place in-person at our New York City office.

Requirements for In Person Training

The in person version of this training will require a laptop computer with power cord and additional desired hardware (e.g. mouse).

Fee

$650 USD

*Each participant receives a unique demo database login.

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. Contact us to request more information.

Payment Options

To pay by credit card, select PayPal as the payment method. The next window will give you the option to pay by PayPal or by credit card.

Refund Policy

Attendees are eligible for a full refund up until 2 weeks prior to the training start date. Registrations can be rescheduled as space permits.