List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.
ELEMENT | PERFORMANCE CRITERIA |
Elements describe the essential outcomes. | Performance criteria describe the performance needed to demonstrate achievement of the element. |
1. Identify SQL requirements from the specification documentation | 1.1 Determine the information to be used from the database 1.2 Identify the tables that hold this information 1.3 Identify the primary keys in these tables 1.4 Identify the relationships between these tables, including foreign keys |
2. Create a relational database | 2.1 Create tables in a database, using SQL statements 2.2 Identify the primary and foreign keys for database table 2.3 Manipulate the data in a database, using SQL statements 2.4 Query the database, using SQL statements 2.5 Write SQL statements to retrieve information from the database |
3. Test SQL results | 3.1 Construct test data to test SQL statements 3.2 Determine the expected results in order to verify SQL statements 3.3 Verify the result of the constructed SQL statements, against the expected results |
Evidence of the ability to:
identify structured query language (SQL) requirements
create the databases and tables
generate queries for one or more tables, to provide the required data
add, modify and delete records from the database tables
test and verify SQL statements.
Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.
To complete the unit requirements safely and effectively, the individual must:
explain the features and application of the following aggregate functions:
MIN
MAX
SUM
AVG
COUNT
COUNT(*)
explain the features and application of the following clause functions:
GROUP BY
HAVING
ORDER BY
dates and times
SQL data types
numbers
text
SQL syntax:
SELECT
FROM
WHERE
LIKE
DISTINCT
CREATE
ALTER TABLE
INSERT INTO
UPDATE
DELETE
DROP
describe the principles of "combining and/or condition" in SQL statements and Boolean operators:
IN and BETWEEN conditional operators
mathematical operators
table joins (relationships).
Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the website technologies field of work, and include access to:
a development environment
a database server.
Assessors must satisfy NVR/AQTF assessor requirements.