To choose which DB

Hello everybody,


I have some basic question about choosing a right database.
I'm new in database world and also in these days i read "Database System Concepet" by Abraham Silberschatz Henry F. Korth S. Sudarshan.
So i want to learn a database system like "MySQL" or "Oracle" or "MS SQL Server" after learning database system concepts.
But i'm in doubt and i dont know which one is better.
I want to learn a database system which support large and medium project.
Of course some frindes suggest "Oracle" but i'd rather know your suggestion too.
and which one works with "ASP.NET" perfectly?


Thank you

 

ASP.NET is Microsoft's stuff so I would guess it works best with MsSQL.

 

OLE is the name of the library that manages ASP.NET database connections. It supports connections to a lot of different databases (access, mssql, oracle, and I believe mySQL as well).

You can have your pick. Since you're just getting started, why not download a copy of SQL Server Express? It's free from Microsoft.

 

MS SQL Server will work best with an ASP.NET site and will be the easiest to intergrate, but .NET is perfectly capable of connecting to other databases such as MySQL.

Which database you use will probably come down to personal preference and you should probably just try them to see which one you prefer, though Oracle is quite expensive, however you can try MySQL and SQL Server for free.

 

mysql is good and it runs on many platforms.

 

If you start with MySQL then you'll have a powerful, free tool that can be used for both small and medium sized projects. Having said that, MS SQL Server is normally used with ASP.NET because Microsoft build both of them.

 

go with MSSQL, its good for MS technologies