This unit standard is intended to provide advanced knowledge of the areas covered for those working in or entering the workplace in Computer Operations.

This unit standard is intended to provide advanced knowledge of the areas covered for those working in or entering the workplace in Computer Operations. People credited with this unit standard can review requirements for database access for a computer application using SQL. Design database access for a computer application using SQL. Write program code for database access for a computer application using SQL. Test programs for a computer application that accesses a database using SQL. Document programs for a computer application that accesses a database using SQL. The performance of all elements is to a standard expected in a professional environment.

Course Content

  • The review identifies and explains the feasibility of the requirements
  • The review identifies the database access objectives and critical performance factors
  • The review estimates the development effort required so that the cost may be estimated
  • A review procedure is adopted, which ensures that the outcomes meet the database access requirements
  • The design implements user requirements 
  • The design of the database structure resembles the output from the data analysis 
  • The methods of accessing data are identified
  • The key relationships between the tables within the database are identified
  • The data types for primary and foreign keys are consistent throughout the database
 
  • The program code implements the program design 
  • The program code uses language constructs that facilitate the understanding of the code
  • The program code utilises the optimising features of the languages being used 
  • The program code uses language instructions that facilitate the understanding of the code
  • The program code uses language constructs that facilitate the understanding of the code
  • Tables joined in a query are essential to its outcome
  • The program code uses constructs that preserve the integrity of the data being accessed by multiple users and processes
  • Global data sharing is minimised to enable weak coupling, and modules exhibit functional cohesion
  • The testing checks all program logic paths
  • The testing corrects program code to eliminate errors identified through testing
  • The testing verifies that the database access functions in the required environment
  • The testing verifies that the database access performs according to the design requirements
  • The testing verifies that the database access functions according to the design requirements
  • The documentation enhances the understanding of the program code
  • The documentation complements the self-documenting attributes of the program code
  • Non-accredited: Short course only  
  • Duration: 1h 30m
  • Delivery: Classroom/Online/Blended
  • Access Period: 12 Months 
Print Button
Scroll to Top