Database Design Practical Tasks

Database Design & Development Practical Tasks:

Topic 1 - Database Creation

From Design to Database

Validation Rules

Lookups

Populating a Database

Topic 2 - SQL Queries

You will need to download the fully populated database below before attempting these tasks:

SELECT and FROM

Exact Match Queries

Partial Match Queries

Other Comparison Operators

Complex Queries

Sorting

Queries Using Two Tables

Adding Records to a Database

Deleting Records from a Database

Editing Records in a Database

Topic 3 - Extra Practice and Revision

Extra Practice: SQL

Extra Practice: Database Creation

Extra Practice: Old CWAs