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
| Section | Days & time | Location | Instructor |
|---|---|---|---|
| 01Class #2026;FA-ITM 220-01 | Mo We Fr · 3:15 – 4:15 PM | Science & Technology Ctr 341 | Miller, David Keith |
| 01 notes: Instructional method: In-Person | |||
| 02Class #2026;FA-ITM 220-02 | Mo We Fr · 9:00 – 10:00 AM | Science & Technology Ctr 356 | Warner, James |
| 02 notes: Instructional method: In-Person | |||
| 03Class #2026;FA-ITM 220-03 | Mo We Fr · 10:15 – 11:15 AM | Science & Technology Ctr 221 | Godfrey, Kory Wendel |
| 03 notes: Instructional method: In-Person | |||
| A1Class #2026;FA-ITM 220-A1 | Time not published | WEB - Online Class WEB | Stevic, Donald K. |
| A1 notes: Instructional method: Online | |||
| A2Class #2026;FA-ITM 220-A2 | Time not published | WEB - Online Class WEB | Kirkland, M Earl |
| A2 notes: Instructional method: Online | |||
| A3Class #2026;FA-ITM 220-A3 | Time not published | WEB - Online Class WEB | To Be Announced |
| A3 notes: Instructional method: Online | |||