Unit of competency Outline

Date retreived
22/07/2026 11:09 AM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Integrate database with online games

Integrate database with online games

Unit of competency
National Code
ICTGAM553
State Code
OBU44
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
21/07/2020
View on TGA
State Implementation and Classification
Approved Date
15/01/2021
Field of Education
020303 - Database Management
Original Release Date
15/01/2021
Nominal Hours
30
Description
This unit describes the skills and knowledge required to integrate a database with an online game, where the relationship between the game server and the database server is also considered a client-server relationship on a local area network.The unit applies to those with high-level technical and problem-solving skills working as programmers, analyst programmers and game programmers responsible for the development of code to connect a computer game to a database.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Install application programming interfaces
  • 1.1 Research application programming interfaces (APIs) according to client requirements
  • 1.2 Identify specific APIs required for game architecture and data source provider
  • 1.3 Install nominated APIs on game development computers according to technical specifications
2. Define and use connection to data source
  • 2.1 Define required game data source connection parameters
  • 2.2 Store connection parameters in required external text-based configuration file
  • 2.3 Open and close connection to game data source
3. Configure and use connection pooling
  • 3.1 Configure connection pooling in the database management system
  • 3.2 Define connection pool parameters for minimum connections, maximum connections, and idle connections
  • 3.3 Minimise use of database resources through connection pooling
  • 3.4 Test and verify use of connection pooling according to organisational requirements
4. Pass embedded non/structured query language (SQL) to a database
  • 4.1 Define database connection property
  • 4.2 Compose structured query language (SQL) or non-SQL statement to be passed to database
  • 4.3 Test, debug and execute the statement according to organisational requirements
5. Execute stored procedures
  • 5.1 Call stored procedure on database and use command callable statement
  • 5.2 Define and pass parameters to stored procedure
  • 5.3 Test, debug and execute database stored procedure according to organisational requirements
6. Modify database data
  • 6.1 Retrieve result sets from the database into game application domain
  • 6.2 Insert new records into database
  • 6.3 Update existing database records
  • 6.4 Integrate data from forward-only and read-only cursor into game application domain
  • 6.5 Incorporate data from updateable cursor into game application domain
7. Test and debug database integration code
  • 7.1 Test database integration code and document results according to organisational requirements
  • 7.2 Determine errors and exceptions and document solutions
  • 7.3 Debug all errors and exceptions
  • 7.4 Assess data modifications, identify and fix errors
  • 7.5 Submit all documentation to required personnel and seek and respond to feedback
No information
No information
Replaces
State Code National Code Title Type
AUT98 ICTGAM527 Integrate database with online game Unit of competency
State Code National Code Title Type
BFG0 ICT50120 Diploma of Information Technology Qualification
BGJ4 ICT50220 Diploma of Information Technology Qualification