F1VY 34: Manage Database Systems using SQL
This Unit is designed to develop an understanding of, and practical experience in the two key fundamental areas involved in using a Structured Query Language (SQL) to manage a database system. Firstly, it is designed to develop an understanding of the fundamentals behind the efficient and effective organisation of data and data relationships, and secondly it is designed to develop, by means of practical examples, the skills involved in using the SQL to create a database system and also how to manage and interrogate the information contained within the system.
The Unit forms part of an HN group award programme, and is intended for candidates in the Computing and IT sector. It may be used, however, in a wide range of other areas where skills in managing a database are involved using the SQL language. The Unit is also capable of being delivered on its own and will be of interest to candidates with appropriate work and IT experience, who wish to broaden their knowledge and/or skills in this area.
On completion of the Unit the candidate should be able to:1. Explain the fundamentals of database design.
2. Create a database structure using SQL commands.
3. Develop SQL commands to manage database information.
4. Troubleshoot SQL commands used in the management of a database.
Credit points and level
1 HN Credit at SCQF level 7: (8 SCQF credit points at SCQF level 7)
Recommended prior Knowledge and/or Skills
Access to this Unit will be at the discretion of the Centre.