Training Session: SQL Topics and Techniques

Time: 1:00pm – 5:00pm

TRAINING TOPICS

Participants will discuss and learn ANGEL/SQL database topics and techniques including:

• ANGEL Subject Areas, Table Structures and Relationships
• Account, Course and Enrollment
• Lesson Content
• Lesson Submissions, Tracking & Grades
• Course Gradebook
• Course Mail
• ANGEL Database Tools
• SQL Query Manager, Text Import Wizard & ODBC Import Wizard
• Batch Enrollment/Account Creation
• Archive/Deletion Tools
• Common Query Scenarios

DELIVERABLES

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

PREREQUISITE

Prior to taking this training session, participants must have completed the “Introduction to Structured Query Language and ANGEL SQL Query Manager” course or have relevant work experience using intermediate level SQL to perform queries against multiple database tables.