View Competency

Term identifier

Query the relational model (WT Version)

Prose Task Statement

The process of using Structured Query Language (SQL) to retrieve and manipulate data stored in relational databases.

Applied Dispositions

Meticulous, Self-Directed, Purpose-driven

Knowledge Skill Pairs

Relational Algebra and Skill Level: 2 - Understanding

Model data using tables, rows, columns, keys and Skill Level: 3 - Applying

User stories and business requirements and Skill Level: 3 - Applying

Translate user stories to SQL statements using (SELECT, FROM, WHERE, ORDER BY, DISTINCT, LIKE, BETWEEN, IN, JOIN, GROUP BY, HAVING, sub-queries, ANY, ALL, UNION) and Skill Level: 5 - Evaluating

Relations, tuples, and fields and Skill Level: 3 - Applying