Physical Database Design
Covers database design from a performance perspective. Presents a complete view of the Database Design process from Requirements Analysis to Database Deployment on an actual Database server. Issues such as Data Storage, Security, Concurrency Control, Query Optimisation, Access Paths, Application Tuning and Data Warehousing are covered in depth. Overall, the course develops the ability to deal with the technical aspects of database administration in an enterprise scale database system.

IT Project Management
Provides students with the core competencies of project management in an information technology context. A range of IT project management methodologies and approaches are compared. Some proven practices and supporting tools and techniques are further investigated, particularly with regard to planning, monitoring, estimating and implementing. Expected standards of professionalism and ethics will be highlighted.

Logical Database Design
Produce a conceptual data model for a given set of requirements. Develop a logical database design for a given set of requirements and for a given conceptual design. Implement a physical database design from a given logical design. Build and test a database application containing forms and reports that demonstrates understanding of how business needs can be met by interaction with a given database. Database design and development: taking unstructured data normalising it, creating and implementing a database design. Advanced SQL using MySQL Concepts associated with multi-user databases will be covered, including distributed database architectures, transaction management, concurrency control, security and back-up and recovery.

Introduction to Programming and Database
To provide students with the basic and intermediate knowledge of programming and database. Basic understanding of concepts and application of Object Oriented Programming techniques, the software development life-cycle, principles of software engineering, development of software solutions for business applications including fi le handling and graphical interface applications, concepts and organization of databases, design and creation of simple relational databases, SQL.

ICT in Business
To provide students with an understanding of how information systems are used to support business. Students will learn about the legal, and ethical issues that impact on the provision of Information Technology services and systems. Internet services and methods for protecting organisational data and systems together with practices for ensuring business continuity will be covered. Students will apply design principles in the creation of media and websites.

Program Design and Construction
An introduction to the design and construction of Object-Oriented software. It will extend individual design and programming skills developed in earlier programming courses, with an emphasis on the quality, modularity, and re-usability of the software developed. The course will introduce current techniques used in software development that allow the goals of software development projects to be realised.

Business and Process Modelling
Provides an insight into the Object Oriented paradigm and methods of data and process modelling. Building on the broader context of Software, Information and Systems Engineering, contemporary methods used in analysis and design are covered and the techniques used to produce optimised models of data and processes are detailed.

ICT Technical Infrastructure
Provides an introduction to IT infrastructure concepts in order to enable students to understand computer systems architecture for effective configuration and use. Concepts of single user, multi-user, and centralised operating systems are covered, along with applications and end-user computing.

ICT in Society
Provides a wide-ranging, multidisciplinary introduction to the evolution and application of increasingly complex and powerful computer systems (and other forms of digital technology) with particular emphasis on their impact on society.

Software Development Practice
Extends individual software development skills into a team environment. Students are exposed to common and emergent practices in the fi eld and introduced to a range of tools that support development processes and practices.

Software Testing
Students will apply testing and quality assurance methods and techniques in the development of ICT solutions.

Programming 1
An introduction to the basics of computer programming to equip students for a career in any branch of IT, the sciences, data analysis or engineering. The fundamentals of writing, designing and testing programs will be developed.

IT Service Provision
Provides an introduction to IT Service Science and its role in the development and provision of high quality IT services. The foundations of high quality services are covered, including standard procedures, techniques and tools. Students will gain IT service and operations orientated skills.

Programming 2
Introduces the process of program design and implementation using object-oriented programming, with particular emphasis on applications from Computer Science and engineering technology.

Optional: Mobile and App Development
Investigates the design and implementation of distributed systems, including contemporary technologies such as Java Enterprise Edition and .NET, as well as the development of mobile systems.

University Pathway Strand Course: Mathematical Concepts
New Zealand Diploma in Software Development (Level 6)

Optional: Game Programming
A practical foundation in game programming, using a variety of game development tools and programming libraries, and deploying games on a variety of platforms.

University Pathway Strand Course: Communication Skills
New Zealand Diploma in Software Development (Level 6)

Interface Design and User Experience
Provides students with the understanding of the principles involved in designing interfaces that are attractive, easy to use and meet the needs of different users.

University Pathway Strand Course: Computer Network Principles
New Zealand Diploma in Software Development (Level 6)