Database Concepts




Specification Reference

  • understand the basic concepts of a relational database as a data store
  • be able to explain the terms record, fi eld, table, query, primary key, relationship, index and search criteria
Supporting Resources

Introduction to Databases

databaseIntro

Learning Cycle Objectives:

  • Understand what a database is
  • Know how to design a table

Resources

Creating Tables

tables

Learning Cycle Objectives:

  • Know how to access MySQL
  • Understand how to create a table and set the correct datatypes

Resources

Relationships

relationships

Learning Cycle Objectives:

  • Know how to create a relationship in a database
  • Understand the need for relationships, and data redundancy

Resources

Querying

queries

Learning Cycle Objectives:

  • Understand that querying asks questions of the database
  • Know how to run Select, Insert, Update & Delete queries.

Resources

Reports/Interfaces

queries

Learning Cycle Objectives:

  • Understand how the data returns from a database
  • Know how to use the data in a user friendly way

Resources