Course Details

Full Course Name:
Diploma in Relational Database

Course Dates

Next Course Commencing:
29th April 2020
Duration:
12 weeks, 1 evening per week from 6.30 to 9.30pm

Course Award

Award:
The College of Progressive Education Diploma

Course Fee

Classroom:
€1,095 (€1,195 if paying in instalments)
Online:
€695 (€795 if paying in instalments)
International/Non-EU:
Call +353 1 4160034

Course Overview

Relational databases are the bedrock of transactional processes and are used extensively in almost all businesses. A standard set of methodologies has been developed to help architects and data modellers to structure data at rest and identify the relationships between data elements e.g.; entity relationship diagrams. Further approaches like ‘data flow diagrams’ have been developed to identify when data needs to be moved from one location to another or from one state to another e.g.; the data is moved to the processor so that it is converted to a human readable form rather than a binary form used internally in the computer.

Learning Outcomes

The student will understand and be able to design and use data fields, records, tables and databases. They will be able to create databases and tables and know how to create, read, update or delete data. They will be able to use and manipulate data types like characters, strings, numerical, dates and time.  They will also be able to connect applications to databases, process data and disconnect applications from the databases. The student will understand the basics of data access controls and the granularity of controls available.  Students will understand the use of single and multi-field indexes for performance and sorting purposes.

Assessment

This course will be assessed through continuous assessment.

Enrol Now

MENU