Advanced Database

BIT704

Level 7
20 Credits
0.1667 EFTS
Delivery type:

Online
Course duration: 16 weeks
Course Duration
The course duration, or enrolment period, is the number of weeks from the course start to the course end date.

When you start your course, you will have a study guide to follow that outlines what topics to aim to work on each week.

For many courses the study guide will be based on teaching weeks, which is shorter than course duration. This is to allow time at the end of the course for assessment marking, extensions and exams.

Withdrawal dates are based on the course duration. Learn more about withdrawals and course transfers.
Course cost:

$890 NZ Domestic

Course Cost

This is an approximate cost for fees only.

It does not any include costs that some courses may have, such as for textbooks, software, external exam fees, or travel to noho marae, practicum, workshop, lab or exams.. If your course has any of these, information will be included below.

More about Fees and funding

$2,748 NZ International
Workload - Approximately 13 hours per
week
Workload

Workload is an estimate of how many hours you need to study each week for the course. A course’s workload is calculated using:

Number of credits times 10 divided by the number of teaching weeks for the course.

The hours are rounded up to the nearest whole number.

Workload is only a guide – you may need more or less time each week. You might also need to allow more time when you have assessments due or exams.

Check our time information and calculator to help you decide if you can fit study into your life:

How much time will you need?
Prerequisites
- BIT604 Database
Contact us to check your prerequisites

Availability

Monthly course availability for upcoming periods
October enrolment dates Enrol by - Course starts - Course ends - 6 Oct 2026 19 Oct 2026 7 Feb 2027	November enrolment dates Enrol by - Course starts - Course ends - 3 Nov 2026 16 Nov 2026 7 Mar 2027	December enrolment dates Enrol by - Course starts - Course ends - 8 Dec 2026 21 Dec 2026 11 Apr 2027	2027 January enrolment dates Enrol by - Course starts - Course ends - 12 Jan 2027 25 Jan 2027 16 May 2027	February enrolment dates Enrol by - Course starts - Course ends - 9 Feb 2027 22 Feb 2027 13 Jun 2027	March enrolment dates Enrol by - Course starts - Course ends - 9 Mar 2027 22 Mar 2027 11 Jul 2027	April enrolment dates Enrol by - Course starts - Course ends - 6 Apr 2027 19 Apr 2027 8 Aug 2027	May enrolment dates Enrol by - Course starts - Course ends - 4 May 2027 17 May 2027 5 Sep 2027	June enrolment dates Enrol by - Course starts - Course ends - 8 Jun 2027 21 Jun 2027 10 Oct 2027	July enrolment dates Enrol by - Course starts - Course ends - 6 Jul 2027 19 Jul 2027 7 Nov 2027	August enrolment dates Enrol by - Course starts - Course ends - 3 Aug 2027 16 Aug 2027 5 Dec 2027	September enrolment dates Enrol by - Course starts - Course ends - 7 Sep 2027 20 Sep 2027 9 Jan 2028

This online course will give you an in-depth knowledge of relational databases and the skills required for developing a database to meet specified requirements. You will undertake a variety of practical exercises enabling them to apply the concepts and techniques associated with designing, building and managing databases.

For more information watch the course introduction video below.

What you will learn

When you successfully complete this course you will be able to:

Apply advanced Structured Query Language (SQL) to create a database solution that suits given information requirements
Apply procedural SQL to create a database solution
Discuss and apply data management principles to resolve issues in a multi-user database environment
Analyse the influence of database organisation on database performance issues
Evaluate components and different types of distributed database management systems
Discuss data administration and database administration issues.

Assessment

This course is 100% internally assessed.

Textbooks

No textbooks are needed for this course.

Computer and internet requirements

This course is delivered online, so you will access your course material and submit assessments online. Our online courses may include reading, videos, quizzes or activities, and you may need to download content.

For online learning you need:

Access to a laptop or desktop computer
Reliable internet and data plan.

If you are unsure if your current computer, Windows or internet access will allow you to study online, please contact us before applying to enrol.

Find out more about online learning

How to enrol

Before enrolling in this course you need to:

choose the qualification you will study the course under
check the order that courses in the qualification should be studied in the Qualification Structure table. This is in the Choose courses and apply tab on the qualification page.

How to apply

Apply to study a programme

You can study this course as part of any of the programmes listed below.

Click on a tile to go the programme information, including the entry requirements and how many courses you'll need to do to complete the programme.

From there you click 'Apply now' and start your study journey.

Fees free study

Micro-credentials

Who are our learners?