Indexing,Stored procedure,Crystal reports Views,Triggers

Question

Hi everybody can some one please tell me what are the following thing. Why do they use.

1. Stored procedure
2. Crystal reports
3. Views
4. Triggers

Please give me the example of these things. How can i create it???.............
                                                                Thanks in advance.