Training Session: SQL Fundamentals

Time: 8:00am – 12:00pm

TRAINING TOPICS

Participants will be introduced to Structured Query Language, ANGEL SQL Query Manager and an introduction to the ANGEL database schema. Specific topics and activities include:

• Introduction to Database Concepts
• Retrieve data from the ANGEL database
• Limiting the Search
• Filtering and Ordering Results
• Using Aliases
• Selecting Data From More Than One Table
• Answers to common questions
• How can I determine how tables are related?
• Where are different types of data stored?
• How can I export query response data?
• How should I approach writing a new query?
• How can I deconstruct and reuse existing queries?

DELIVERABLES

Participants receive a copy of the ANGEL Database Schema Guide during the training.