How to give the search option for website?

Hello Friends,
I am working in a website where one search box is available, this website is for online training provider, so it has different pages for different courses. If anyone want to search by giving any course name the related course list or that particular course page should open. If anyone have any idea regarding this please help me and what are the different ways to achieve this means I have to maintain database or I can use xml also for this.

Regards,
Premashish

use google custom search on your site … thats the cheap way out

or ask your host if he can put all your data in a mysqlhost

Properly manage the action of search form that it can hold search string and course string entered in the course field (if any).
At the server end receive query data; if course string is found then write correct mysql query to find related topics.
Otherwise write a general search query to find result.

Use wordpress :X