Competency 1: Query the relational model
Key Dispositions: Meticulous, Self-Directed, Purpose-driven
Knowledge-Skill Pairs:
| Knowledge Element | Skill Level (Bloom cognitive level) |
| Relations, tuples, and fields Model data using tables, rows, columns, keys |
3- Apply
|
| User stories and business requirements 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) |
6 – Create
|
Suggestions Accepted for consideration for the next Edition:
Please provide your suggestions about this knowledge unit. All submitted comments will be reviewed at the end of the month. Comments accepted for inclusion will be listed above.