With softer palettes, and a smart logo that can easily be transferred to print, the look is now more professional and sophisticated.  Since this was a home mortgage/real estate office,  I decided on a color palette that was similar to colors used in homes (I though it was clever).
thumbnail1

Course Summary:

WinRDBI: Rocked out some relational algebra database concepts using WinRDBI, which sounds harder than it really is.  WinRDBI is free to download, mostly used for educational purposes, offers a nice interface for testing scripts in various db languages.

MySQL 2005: Then we jumped right into basic MySQL query programming, mostly covered information retrieval(Select, From, Where) statements.  Once we got some queries rockin, we learned how to design database system using industry standards, including communication strategies, logical designs, illustration models and relations.

Design & Security: Then we built databases from the ground up using MySQL.  Once we got query scripting down, and database designing complete, we jumped into administration.  We covered writing scripts for users, including dynamic scripts that would allow users to input there own values to retrieve data.  This method of scripting allows the administrator to provide the designated user with data they need without giving the user access to modify or view other contents of the database.  We then built Stored Procedures, which is basically much larger and more complex query that is used to pull granular data from a database.  This sections of the course was more about best practices and security.

Java: Then we hit up some Java, i dont know there is soooo much Java programming in this IT curriculum, anyhow with java we built an applet that would proved user authentication.  Basically the app would request user name, password, and database name from a user, if all is well, a connection is established with a MySQL database.  From here the app asks the user for various values, and plugs those values into queries that were hard coded into the app via Java.  This allows a user to access a database through authentication, and pull data from the database with no SQL experience.  I was hoping to spend a bit more time with the Java programming sections, even though I am not a fan of Java programming, this section really offered some powerful material.

Advice: If you are considering on taking this course with Prabu, I recommend that you go to every class.  He gives you 20 points for class participation, which he dictates based on your attendance.  Say hi to him quite often and make sure he knows who are.  Every once in a while send him an email with a question or post it in his forum (he uses Moodle).  His lectures are written well, and he is very knowledge with this material.  He follows the syllabus and goes directly by the book, so buy the book.  His class assignment are only worth 1% of your final grade, which is harsh, given that they are challenging and long as hell, but his quizzes carry a lot of weight on your final grade, and I can most certainly guarantee that your exams will have a portion exactly like the homework, so do your assignments, it will help you pass the exams.  His quizzes have a lot multiple choice questions(~90%) do the review questions at the end of every chapter including key words and you will ace the quizzes, quizzes are design by the chapter review questions.  Midterm was mostly multiple choice, handful of fill in the blanks, and 4 scripts.  Final was a lot of multiple choice(~50), and fill in the blanks(~30) and some stored procedure goodness, no java.  For the final i recommend reading the designated chapters in the book, review his slides, and answer the chapter questions, and you should be fine.