Unit of competency Outline

Date retreived
22/07/2026 9:26 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 game

Integrate database with online game

Unit of competency
National Code
ICTGAM527
State Code
AUT98
TGA Status
Replaced
DTWD Status
Replaced
Current Release Number
1.00
Current Release Date
25/03/2015
View on TGA
State Implementation and Classification
Approved Date
16/09/2015
Field of Education
020303 - Database Management
Original Release Date
16/09/2015
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.It applies to individuals 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 (APIs) suitable to the game’s data source provider
  • 1.1 Research the appropriate application programming interfaces (APIs)
  • 1.2 Identify the specific APIs suitable for the game architecture and the data source provider
  • 1.3 Install the nominated APIs on game development computers
2. Define and use a connection to the data source
  • 2.1 Define the game data source connection parameters
  • 2.2 Store the connection parameters in an external text-based configuration file
  • 2.3 Open and close the connection to the game data source
3. Configure and use the connection pooling
  • 3.1 Configure connection pooling in the database management system
  • 3.2 Define the connection pool parameters for minimum connections, maximum connections, and idle connections
  • 3.3 Minimise the use of database resources through the use of connection pooling
  • 3.4 Test and verify the use of connection pooling
4. Pass embedded structured query language (SQL) to the database
  • 4.1 Define the database connection property
  • 4.2 Compose a structured query language (SQL) statement or command to be passed to the database
  • 4.3 Test, debug and execute the SQL statement
5. Execute a stored procedure on a database
  • 5.1 Call a stored procedure on the database, using a command callable statement
  • 5.2 Define and pass the parameters to the stored procedure
  • 5.3 Test, debug and execute the database stored procedure
6. Modify database data
  • 6.1 Retrieve multi-row multi-column result sets from the database into the game application domain
  • 6.2 Insert new records into the database
  • 6.3 Update existing database records
  • 6.4 Delete existing database records
7. Integrate data from the database with the game application domain
  • 7.1 Integrate data from a forward-only and read-only cursor into the game application domain
  • 7.2 Incorporate the data from an updateable cursor into the game application domain
8. Test and debug database integration code
  • 8.1 Test the database integration code
  • 8.2 Document the test results
  • 8.3 Determine the errors and exceptions, and document the solutions
  • 8.4 Debug all errors and exceptions
  • 8.5 Assess all data modifications in the database, and document any errors
  • 8.6 Correct all causes to data modification errors
No information
No information
Replaces
State Code National Code Title Type
D7830 ICAGAM527A Integrate database with online game Unit of competency
Replaced By
State Code National Code Title Type
OBU44 ICTGAM553 Integrate database with online games Unit of competency