Databases: Part 1: A step-by-step tutorial guide

ABOUT THIS RESOURCE

This resources takes the absolute beginner step-by-step through learning relating to the following learning outcomes:

Databases

• I can explain the concept of a database.
• I can use the SQL commands SELECT, FROM, WHERE and ORDER BY to retrieve data from a relational database.
• I understand the need for a dedicated language to enable communication between SQL clients and SQL servers
• I understand the database concept of a foreign key.
  I can select a suitable primary key for a table for the design of a single-table database given a set of data management requirements.
• I can use the SQL operators <, >, =, <=, >=, <>, AND, OR, LIKE and BETWEEN to retrieve data from a relational database.
• I can demonstrate that I understand the concept of CONSTRAINTS in the context of SQL
• I can use the SQL commands UPDATE, SET and WHERE to retrieve data from a relational database.
• I can choose appropriate field types and lengths for the design of a database given a set of data management requirements.
• I can use the SQL commands INSERT INTO and VALUES to insert data into a relational database.
• I understand the database concepts: table, record, field and primary key.
• I can evaluate a database solution in terms of accuracy of output and fitness for purpose.
• I can explain the concept of a relational database.