View Competency

Term identifier

Query the relational model

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

Model data using tables, rows, columns, keys 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: 6 - Creating

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

User stories and business requirements and Skill Level: 6 - Creating