Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Connect to the database
   • Identify site data needs from the technical requirements
   • Connect to the database from a web application using a web development language
2. Retrieve data from database and display on web pages
   • Retrieve data using structured query language (SQL)
   • Display the data in the most appropriate control
   • Format the data so that it is displayed in the most effective way
3. Update the database data from user input
   • Update the existing data stored in the database with user-supplied input
   • Insert the data in the database with user-supplied input
   • Delete the data stored in the database
   • Validate the data and check for errors

Performance Evidence

Evidence of the ability to:

access database using a web development language

retrieve and display web-based data

update web-based data.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

---

Knowledge Evidence

To complete the unit requirements safely and effectively, the individual must:

describe a database structure

outline internet technology as it relates to the use of databases

identify and apply programming control structures, including object-oriented programming and structured query language (SQL)

explain web programming concepts, including:

authentication and web security

hypertext transfer protocol (HTTP)

session management

defining the principles of stateless programming.

---