Queries provide a way to access data that is stored in your database. With a basic understanding of SQL query syntax, you can write and manage queries to be used throughout your VisualVault customer database.
By the end of this course, you will be able to:
- Locate the Database Connections page in VisualVault
- Differentiate between the VisualVault database and VisualVault Forms database
- Utilize the VisualVault Forms database connection to create a new query
- Select columns in a query
- Filter form records to be returned in a query
- Join tables in a query
- Introduction
- Queries
- Database Connections
- SQL Query Basics
- SQL Joins
- Review