Award in Database Development – Intermediate

Unit Description

Relational Databases aims to develop the skills involved in using Structured Query Language (SQL) to manage and interrogate the information held in a Relational Database System. The content of the unit is practical in nature and provides the knowledge and skills to create reliable, efficient and effective SQL commands. The purpose is to produce output according to user requirements and to meet business needs.

Learning Outcomes

On completion of this course the learner is able to

1. Create Basic Queries using the SELECT statement

2. Use Functions within SQL

3. Create Advanced Queries

Unit Content

1. Create Basic Queries using the SELECT statement

·retrieving all columns and rows

·retrieving specific columns

· specifying a column alias

· retrieving rows from tables according to specific and non-specific criteria

· using comparative and logical operators

· use of NULL

· use of DISTINCT

· use of LIMIT

· sorting data

2. Use Functions within SQL

· character functions

· calculation functions

· date functions

· multiple row functions (GROUP BY, HAVING)

3. Create Advanced Queries

· sub-queries

· joins (INNER, OUTER)

· set operations (UNION)

· views