2 - Administration → 2.5 - Data Analytics

Queries in VisualVault (290-VV-ADMIN)


Description
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.
Learning Objectives
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

Lessons
  1. Introduction

  2. Queries

  3. Database Connections

  4. SQL Query Basics

  5. SQL Joins

  6. Review
Content
  • Queries in VisualVault
Completion rules
  • All units must be completed