DH3J 34: SQL: Introduction
This Unit is designed to develop a broad knowledge of the concepts, principles, boundaries and scope of relational databases using a query language. These will be reinforced by developing the practical skills required in using the structures and features of a query language in order to maintain and interrogate a relational database management system. The SQL constructs used adhere to the current standards, so will be applicable in all SQL-based platforms. It forms part of an HN group award programme, although it can also be used as a stand-alone Unit by candidates wishing to acquire and develop skills using a query language. On completion of the Unit the candidate should be able to:1. Create and maintain a data storage system
2. Manipulate data stored within a table structure
3. Produce formatted reports
1 HN Credits at SCQF level 7: (8 SCQF credit points at SCQF level 7)
Recommended Prior Knowledge and Skills
Access to this Unit will be at the discretion of the Centre. However it is recommended that candidates should have basic practical PC skills, and an understanding of the role and application of databases. This can be evidenced by having achieved Units such as HN Unit DH33 34: Computer Operating Systems 1, HN Unit DH3F 34: Systems Development: Introduction and also HN Unit D75X 34: Information Technology: Applications Software 1. Alternatively, the Unit can be delivered on a stand-alone basis to candidates interested in learning and using a query language. In these cases, candidates should have practical work experience and some appreciation of the role and application of relational database management systems.