Need Help for beginnning Database application

[peep2k]

Hello,
I m new to this forum and this is my first post.
I have been learning Database Designing (basic concepts,ER diagram,Normalization) for a while now but i was wondering which platform to choose for my database designs.
There are lots options available like orcale,sql server,ms access which creates lot of confusion for my decision
Please Help me,i have some experience with java which i m willing to use as my front end(for both web and windows based application)
Also what is the difference between p-sql t-sql , should i need to learn both of them?

[WingedPanther]

It depends HEAVILY on what you're going to do with your application. If you're just doing a small project, I would stick with a free database such as MySQL, PostGRESQL, or SQL Server Express.

Access is garbage. I would avoid that as much as possible.

Oracle is also nice, but I'm not sure if they have a free testing version.

p-sql, t-sql, etc are just different flavors of SQL for specific databases.

Finally, in business, you are likely to have to support a variety of different types of databases. My company works with Oracle, SQL Server, and Firebird (another free one), which allows us to server almost all of our commercial customers' needs/wishes.

[Donovan]

WingedPanther is right.. Stick with MYSQL and use SQLYOG to access your database server.. Worked perfect for me.. I used to code private servers so I have a LOT of experience in this area... I spent almost 3 years using MYSQL and it has never failed me.