Skip to main content

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

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

Credit Value

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.