The SQL Query Tab, accessed via Tools >> SQL Query, in GoldMine Premium Edition allows GoldMine users to write SQL Statements to display information contained in your GoldMine databases. SQL Queries can be used to display lists of contact related information regardless of where the information is stored in the GoldMine database. Filters and Groups are great for building lists but there are times when SQL Queries are better or the only option. For instance exporting Primary and Additional Email Addresses, Creating a list of contacts based on History items, Scheduled activities, and Details. Not to mention exporting a list from a SQL Query is much easier then using the GoldMine export wizard.
This class will cover the following:
In chapaters 1-6 we will review the table structures in GoldMine. We’ll discuss these tables and how the contact information contained in them are related to one another. This is an import first step before being able to create/write SQL Queries. In the remaining chapters we will review the SQL SELECT statement and how you can generate lists of contacts and contact related information from the GoldMine database. Examples will be provided each step of the way.
- What is a Database?
- What is SQL?
- Intro to SQL Database Tables
- Understanding SQL Table Relationships
- Understanding The GoldMine Database Table Structure
- The SQL Select Statement
- Sorting/Ordering Data and SQL Aliases
- Filtering Data using WHERE, AND, OR, IN, NOT, LIKE
- Selecting Data from Multiple Database Tables
- Summarizing and Grouping Data
- Subqueries, Unions & Using Multiple Instances of the Same Database Table
- SQL Functions
- Useful GoldMine SQL Queries