Unit Outline
The Online e-Learning course will address the following units of
Competence from the National ICA11 Information and Communications
Technology Training Package. All of these competencies must be
successfully completed to gain The Diploma of Database Design and
Development.
The program is broken into 4 logical clusters of training within
the broad category of ICT systems: 1/ Core
Infrastructure; 2/ Continuity &
Security; 3/Continuous Improvement;
and 4/ Service Delivery &
Governance.
Core Units
Unit Codes
|
Core Units
|
Cluster
|
| ICAPRG425A |
Use structured query language |
Core Infrastructure |
| ICAPRG509A |
Build using rapid application development |
Continuity & Security |
| ICASAD501A |
Model data objects |
Continuity & Security |
| ICASAD502A |
Model data processes |
Continuity & Security |
| ICADBS502A |
Design a database |
Core Infrastructure |
| ICAICT502A |
Develop detailed component specifications from project
specifications |
Continuous Improvement |
| ICANWK514A |
Model preferred system solutions |
Continuous Improvement |
| ICTSUS6233A |
Integrate sustainability in ICT planning and design
projects |
Continuous Improvement |
| ICAICT418A |
Contribute to copyright, ethics and privacy in an IT
environment |
Continuous Improvement |
Elective Units
Unit Codes
|
Elective Units
|
Cluster
|
| ICADBS504A |
Integrate database with a website |
Continuity & Security |
| ICASAS505A |
Review and update disaster recovery and contingency plans |
Continuity & Security |
| ICAPRG511A |
Monitor and support data conversion |
Continuity & Security |
| ICAPRG523A |
Apply advanced programming skills in another language |
Continuity & Security |
| ICAPRG528A |
Perform IT data conversion |
Continuity & Security |
| ICAICT509A |
Gather data to identify business requirements |
Continuous Improvement |
| ICAICT511A |
Match IT needs with the strategic direction of the
enterprise |
Continuous Improvement |
| ICASAD506A |
Produce a feasibility report |
Continuous Improvement |
| ICAPMG501A |
Manage IT projects |
Continuous Improvement |
| ICAPMG606A |
Manage IT project quality |
Continuous Improvement |
| ICASAS502A |
Establish and maintain client user liaison |
Service Delivery & Governance |
Cluster 1 - Core Infrastructure
Infrastructure implementation is the starting point for business
seeking to enable their business through utilising IT systems. The
workplace skills provided in this cluster cover a broad range of
key systems and services. The cluster has both server and
workstation platforms at its heart to ensure a holistic knowledge
base for Systems Administrators. The depth of knowledge transfer is
based on Microsoft SQL Server 2008 and Windows. This cluster
delivers outcomes that are broad in systems implementation and are
relevant to many platforms like Microsoft, Oracle, Interbase, DB2
and MySQL.
Broad concepts covered
- Scripting
- Writing queries
- Transaction logs
- Join data from multiple tables
- Install and configure server software
- Basic backup and restore principles
- Storage technologies
|
- Import and export of data
- Database replication
- Create databases
- Database integrity using constraints and triggers
- Stored procedures
- Transactions and locks
- Functions
- Views
|
Units of Competency for this qualification have a higher
relevance in other clusters delivered. As such there are no Units
of Competency for Core Infrastructure.
Cluster 2 - Continuity & Security
Systems Administrators must have the skills and knowledge to
ensure that business systems are ready, available and capable for
the purpose they were designed. The workplace skills provided in
this cluster cover a broad range of concepts for business
continuity. Identifying key systems and services is paramount to
ensure that business can continue to function effectively. This
cluster delivers outcomes that are broad and transferable across
many different systems such as MS SQL, MySQL, Oracle, Gupta SQL,
Interbase, Send Mail, Pegasus mail, Lotus Notes GroupWise and many
more running on various platforms.
Broad concepts covered
- Transaction log shipping
- Database Mirroring
- Database consistency checking
- Defragmentation
- Database mobility
- Corporate virus management
|
- Secure remote access
- Monitor databases
- Modify data in tables
- Database security
- Automation of admin tasks
- Disaster recovery
|
Cluster 3 - Continuous Improvement
Systems Administrators play a key role in business improvement and
must have the skills to offer solutions and alternatives to
business managers to address problems and increase productivity and
in turn, revenue. This cluster delivers outcomes that are broad in
project methodology, systems design, and business needs analysis
and are transferrable across multiple industries, systems and
platforms.
Broad concepts covered
- Project lifecycle
- Identification and definition of Stakeholders
- Feasibility analysis
- Project Charters
- Project team roles
- Project Scope
- Risk impact and mitigation
- Cost and time estimate
- Communications matrix
- Quality management
- Qualitative and quantitative analysis
- Closeout process
|
- Analysis of business need
- Budget management - top-down - bottom-up
- Relationship management
- Project Implementation
- Scope creep
- Delivery and signoff
- Project Debrief
- Systems Design
- Systems consolidation - Green IT concepts
- Systems optimisation
- Change management
|
Cluster 4 - Service Delivery & Governance
Being able to communicate with customers at all levels will ensure
positive business support outcomes. The workplace skills provided
in this cluster cover a broad range of concepts for systems support
and maintenance. At the core of this cluster is ITIL, the "de facto
standard", of service management. Included are soft skills units
that prepare the student for client interaction that focus on
communication skills through activities and simulations. Many of
the skills learned are applicable across many job roles and
industry sectors.
This cluster provides the framework and skills set that are
platform and systems independent and vital to ensure that Support
staff have the procedures, systems and policies in place to support
correct, unbiased decision making in times of extreme stress. These
will also extend to preventative maintenance and proactive problem
management to reduce system incidents.
Broad concepts covered
- Active Listening
- Call handling
- Service metrics
- Change Management
- Problem solving - deductive/inductive
- Incident and problem management
- Information gathering
|
- Call ownership - perceived and real
- Quality Assurance
- Consistency of support
- Maintenance
- SLA/OLA/UC management
- Service Strategy, Design, Transition, operation and continual
improvement
|