Print this page

Diploma of Information Technology
(Database Design and Development)

Course 19017

CRICOS Code 059110G
National Code ICA50505

Apply now for this course

APPLY

Duration

1.5 years full-time

Locations, tuition fees and intakes

Additional costs for uniforms, equipment, textbooks and materials (if applicable) range from A$300 - A$1,000 per course.


Campuses in Sydney
2010
2011
Intakes*
Fees^
Intakes*
Fees^
Nothern Beaches Feb A$15,255    
St George Feb, Jul A$15,255    

*Intakes shown in red have already been filled
^Fees per course

> View locations map

Description

This Diploma is designed for people who wish to pursue a career in IT with a focus on the effective design and development of information and communication technology (ICT) database systems. Graduates will have detailed knowledge of the technical intricacies of database development and design, but will also be well rounded in a range of other competencies such as process re-engineering, quality assurance, business needs analysis and client expectations.

Career Opportunities

Business Intelligence / Data Warehousing consultants, CRM Database Designer, Data Warehousing and Business Intelligence Manager, Database Designer, Database Developer, Database Specialist, Developer, Senior Database Administrator.

Entry Requirements

  • Year 12 or equivalent
  • Academic IELTS 6.0 or TOEFL (iBT) 68 or Certificate 3 in English for Further Study at TAFE NSW or equivalent

Exit Points

N/A

Course Structure

This course includes:

  • Certificate 4 in Information Technology (Support) (Database Administration) (19006)

OR

  • Certificate 4 in Information Technology (Programming) (19010)

To receive the Diploma of Information Technology (Database Design and Development), students must complete 26 core units and a range of elective modules.

Core Units

  • Follow workplace safety procedures
  • Manage project quality
  • Determine and confirm client business expectations and needs
  • Determine and apply appropriate development methodologies
  • Model preferred system solutions
  • Develop detailed component specifications from project specifications
  • Validate quality and completeness of system design specifications
  • Prepare disaster recovery and contingency plans
  • Design a database
  • Gather data to identify business requirements
  • Model data objects
  • Model data processes
  • Translate business needs into technical requirements
  • Build using rapid application development
  • Design organisational documents using computing packages
  • Match the IT needs with the strategic direction of the enterprise
  • Establish and maintain client user liaison
  • Ensure privacy for users
  • Operate a personal computer
  • Operate computer hardware
  • Operate computing packages
  • Integrate commercial computing packages
  • Use computer operating system
  • Work effectively in an IT environment
  • Communicate in the workplace
  • Manage complex projects

Elective Units

The full range of elective units is listed below. Elective units actually offered may vary between each semester and campus, and will depend on a number of considerations including the packaging rules for the qualification and demand for the unit.

  • Technical tutorial support
  • Tutorial support
  • Determine best-fit topology for a local network
  • Develop website information architecture
  • Develop detailed technical design
  • Identify physical database requirements
  • Use SQL to create database structures and manipulate data
  • Create a common gateway interface script
  • Build a database
  • Apply introductory programming skills in another language
  • Automate processes
  • Create dynamic pages
  • Integrate a database with a website
  • Maintain functionality of legacy code programs
  • Maintain custom software
  • Analyse information and assign meta-tags
  • Connect hardware peripherals
  • Provide basic system administration
  • Action and complete change requests
  • Manage resolution of system faults on a live system
  • Complete database backup and recovery
  • Identify and resolve common database performance problems
  • Monitor and administer a database
  • Run standard diagnostic tests
  • Locate equipment, system and software faults
  • Operate a word processing application
  • Operate a spreadsheet application
  • Operate database application
  • Send and retrieve information using web browsers and email
  • IT work placement AQF 5
  • IT portfolio AQF 5

Additional Information

Click here for further general information about qualifications, articulation, facilities and equipment, assessment methods and Recognition of Prior Learning (RPL).

 

Course information and offerings are subject to change at any time.

ASK A QUESTION

Need advice about studying at TAFE NSW? Ask questions and get fast answers!

> What's this?

FIND A COURSE

Select a course area for more details: