Guided Learning hours: 60
Unit level (MQF) : 4
Credits: 6
Unit description
Today, every business and organization need to have some form of IT system in order to function efficiently and be able to cope with competition. Databases are therefore a necessity in order to persist the data generated on daily basis. Data retrieval from these data sources is a core component in every type of information system.
Relational Databases is a unit which is relevant to learners wishing to develop the skills required to carry out different database operations through the use of Structured Query Language (SQL). SQL is considered as the official language used by database and information system developers to manage and interrogate the information held in Relational Database Systems. The unit will introduce a number of different querying techniques to add, update, remove and retrieve data. The content of the unit is practical in nature and provides the knowledge and skills to create reliable, efficient and effective SQL commands. The learner should be able to generate reports which output all the information indicated by the user, in order to meet the business requirements.
This unit will not require the learner to have any previous knowledge of SQL. It is designed to be delivered as a continuation of Database Concepts & Design as part of the Extended Diploma in IT (Software Development) although it may also be delivered as a standalone unit.
On completion of this unit, learners will be familiar with the majority of the basic querying concepts. Learners will be able to make use of different querying techniques to handle data stored in a DBMS.
Reading List
Books
- SQL Hacks, Andrew Cummings, 1st Edition, November 2006
- MTA Database Administration Fundamentals by Microsoft Official Academic Course, Published 2011 by John Wiley & Sons 978-0470889169
- Sams Teach Yourself SQL in 10 Minutes, Ben Forta, Sams; Fourth Edition October 2012
Websites