Use SQL to create database structures and manipulate data



From the official document ICAB4136A:
 * "This unit defines the competency required to use a structured query language (SQL) to define, create and manipulate database structures and associated data in a relational database."

Basically, that means ... (translate above into plain english)

You can read more about this unit on the National Training Information Systems Official document for ICAB4136A.

This unit forms part of the following qualifications:
 * Cert IV Websites Qualification in Australia

How this unit will help you
After learning and applying the skills required by this unit you'll be able to demonstrate your skills in:


 * translate the above elements and performance criteria into plain English and summaries here...

To find the 2nd max salary from your table -

1> Select Top 1* from table-name where salary < ( select max(salary) from table-name );

--

...

Ideas for demonstrating this unit
The best way to demonstrate these skills is ...

Grading
If you are demonstrating this unit as part of a formal course, you might find that the unit is graded (meaning you can not only demonstrate your competence, but can also gain a credit or distinction). Your facilitator may already have set criteria that your college uses. If not, here are some ideas for possible credit/distinction activities that you can discuss with your facilitator: