Learning Objectives

0 results forUnknown Login

ID	Skill_name	RAG
3.7	Relational Databases and SQL
3.7.1	Relational databases
R76	I can explain the concept of a database	NRAG
R76	I can explain the concept of a relational database	NRAG
R76	I can understand the concept of a table in a database	NRAG
R76	I can understand the concept of a record in a database	NRAG
R76	I can understand the concept of a field in a database	NRAG
R76	I can understand the concept of a primary key in a database	NRAG
R76	I can understand the concept of a foreign key in a database	NRAG
R76	I can understand that the use of a relational database facilitates the elimination of data inconsistency and data redundancy.	NRAG
3.7.2	Structured query language (SQL)
R77	I can use SQL to retrieve data from a relational database, using the commands: SELECT FROM, WHERE, ORDER BY, ASC / DESC	NRAG
R77	I can use SQL to insert data into a relational database using the commands. INSERT INTO, VALUES	NRAG
R77	I can use SQL to update data in a relational database using the commands. UPDATE, SET, WHERE	NRAG
R77	I can use SQL to delete data in a relational database using the commands. DELETE FROM, WHERE	NRAG

Assessment Scores

Click on name for Lesson link

R74 : Legislation

0%

R75 : Ethics, Culture & the Environment

0%

---

---

0 results forUnknown Login