Skip to content

INFO601 – Database Modelling and SQL

Module code
Module title
Database Modelling and SQL
To enable students to apply an indepth understanding of database modelling, database design and SQL concepts.
  • BI1601
  • BI1804
NZQA Level
Level 6
NZQA Credits
Delivery method
  • Web-Supported
Learning hours
Total learning hours
Resources required
Learning Outcomes
1. Apply advance database design and modelling techniques.
2. Apply advance Structured Query Language (SQL) techniques.
3. Apply database programming techniques.
- Database modelling and database design concepts:
- Database design techniques
- Producing data models
- Applying data modelling to a given scenario
- Boolean Algebra
- Data dictionaries
-Structured Query Language (SQL)
- Data definition languages (DDL), data manipulation language (DML)
- Implement integrity constraints including
- Check constraints
- Triggers
- Queries
- Natural Joins
- Inner Joins
- Outer Joins
- Nested Queries
- Functions
- Apply advanced techniques in SQL with programming techniques
- Explaining procedures, functions and packages for manageability and efficiency
- Programmable logic statements in SQL statements
- Implement procedures,functions or packages
Teaching and Learning Strategy
Teaching methods will involve theoretical and practical classes which may include but not limited to lectures, tutorials, computer laboratory work, group activities, face-to-face, online, and assignments.
Assessment Criteria
In order to receive a passing grade, students must achieve a minimum 40% average over all supervised tests and achieve 50% overall for the module.

Learning and Teaching Resource
Wintec Learning Management Systems, Computer Laboratory
Required Textbooks
An extended reading list will be supplied by the tutor at commencement of the module. This will be updated annually.

Wintec is part of Te Pūkenga - New Zealand Institute of Skills and Technology Learn More

Learn with purpose

Explore Te Pūkenga

Te Kāwanatanga o Aotearoa - New Zealand Government

Te Kāwanatanga o Aotearoa - New Zealand Government

Copyright © 2022 Wintec