ITM 220SQL

Brigham Young University-Idaho · 3.00 credits · UGRD

Catalog

This course focuses on learning how to write Structured Query Language (SQL) to interact with databases for various data retrieval and reporting needs. Students will create tables, constraints, indexes, and views; insert, update, delete, and query data. SQL activities examine how to write cross joins inner joins, outer joins, common table expressions (CTEs), subqueries, and composite queries that use set operators. SQL statements explore built-in database functions, data fabrication, hierarchical queries, pivot operations, and conditional logic.

Recent sections

Fall 2026 · 6 sections

Sep 14 – Dec 16

SectionDays & timeLocationInstructor
01Class #2026;FA-ITM 220-01Mo We Fr · 3:15 – 4:15 PMScience & Technology Ctr 341Miller, David Keith
01 notes: Instructional method: In-Person
02Class #2026;FA-ITM 220-02Mo We Fr · 9:00 – 10:00 AMScience & Technology Ctr 356Warner, James
02 notes: Instructional method: In-Person
03Class #2026;FA-ITM 220-03Mo We Fr · 10:15 – 11:15 AMScience & Technology Ctr 221Godfrey, Kory Wendel
03 notes: Instructional method: In-Person
A1Class #2026;FA-ITM 220-A1Time not publishedWEB - Online Class WEBStevic, Donald K.
A1 notes: Instructional method: Online
A2Class #2026;FA-ITM 220-A2Time not publishedWEB - Online Class WEBKirkland, M Earl
A2 notes: Instructional method: Online
A3Class #2026;FA-ITM 220-A3Time not publishedWEB - Online Class WEBTo Be Announced
A3 notes: Instructional method: Online