Higher National Computing: E-Learning Materials

Table of Contents

1. Higher National Computing: E-Learning Materials
2. DH2T 34: Computer Architecture 1
3. D75X 34: Information Technology: Applications Software 1
4. DH3E 35: Software Development: Structured Programming
5. DH35 34: Computing: Planning
6. DH33 34: Computer Operating Systems 1
7. DH21 34: Working within a Project Team
8. DH30 35: Software Development: Applications Development
9. DV6E 34: Database Design Fundamentals
10. DV6L 34: PC: First Line Support
11. F0N0 34: Professional Issues in Computing
12. DM2X 35: Computer Operating Systems 2
13. D75V 35: Computer Networks: Network Technology and Data Communications
14. DF9M 34: Client Operating System
15. DF9N 34: Network Server Operating System
16. DM31 35: Software Development: Array Data Structures
17. DM32 35: Software Development: Linked Data Structures
18. DH3D 35: Software Development: Relational Database Systems
19. D77F 35: Systems Development: Structured Design Methods
20. DX43 35: Information Technology: Legislation and Codes of Practice
21. DX42 35: Internet: Web Technology and Security
22. F1VS 34: Interactive Media: Planning
23. F1VT 34: Interactive Media: Authoring
24. F1VV 34: User Interface Design
25. F1YX 34: Digital Imaging: Bitmap and Vector
26. F1VW 34: Client Side Scripting for Web Applications
27. F1VY 34: Manage Database Systems using SQL
28. F1VX 34: Internet: Web Development Standards and Legislation
29. F1W0 34: Project Management for IT
30. DH39 34: Internet: Introducing E-Commerce
31. DF9T 34: Internetworking Concepts 1: Development and Delivery Concepts
32. DF9V 34: Internetworking Concepts 2: Security and Business Concepts
33. DF9R 35: Network Infrastructure 1: Implementation and Management
34. DG00 35: Network Infrastructure 2: Planning and Maintenance
35. DV6F 34: E-Commerce: Introduction
36. F1XA 34: Computing: PC Hardware and Operating Systems Essentials
37. F1X9 34: Computing: PC Hardware and Operating Systems Support
38. DH3J 34: SQL: Introduction
39. DE1N 34: IT in Business - Databases
40. DE1M 34: IT in Business - Spreadsheets

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.