SQL Cheatsheet: Simple SQL for TMS Users
Date and time
Location
Gallery Systems Inc.
5 Hanover Square #1900 New York, NY 10004Refund Policy
Description
SQL Cheatsheet: Simple SQL for TMS Users
Thursday, April 21, 2016 | 9:30 am - 12:30 pm
Fee: $300
Speaker: Brian Jennings, Support Specialist, Gallery Systems
This course takes you from SQL newbie to a SQL “do”-bie in one half day. Learn the basic SQL functions that will help speed up your TMS work.
Structured Query Language (SQL) is the query workhorse behind every TMS search, and can be used to manage data at the database level. This course is for those with little to no SQL experience.
Note that this course uses SQL Server. Oracle databases may differ.
After this course, you will be able to:
• Create simple queries
• Build upon queries
• Navigate the TMS Database
A laptop is required for this course. You may use your own laptop, provided:
-
TMS is installed on your machine.
-
You have local administrators' rights on your laptop.
-
Your laptop is equipped with an up-to-date web browser (IE9+, Chrome, Firefox, Safari, Opera, etc.)
Or, you may request a laptop rental when registering.
Organized by
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.