How to create SQL like composite key

You can create a unique composite by concatenating values. The steps would be:

1. Create a unique Text field.
2. Create a Workflow Field Update to concatenate the fields whose composite you want to be unique and populate into the above field.
3. Create a Workflow Rule that uses the field update above if any of the source fields have changed.