Here’s a list with a feature comparison of the three most popular DB products (imho). Please let me know if you have any additional information, especially on the Oracle topic.
Product / Feature Microsoft SQL Oracle RDBMS MySQL
Typical Applications SharePoint, SCOM, SCCM, WSUS OBI, SAP Joomla, WordPress, MyBB, phpBB, Drupal, many open-source
Current Version SQL Server 2012 11g 5.5.x
History First release in 1989, Based on Ingress (1974) / Sybase (1987) 1979 1995
Operating System Windows Server, Windows Client Windows, Unix, Linux Windows, Unix, Linux, Mac and many more
Licensing Closed-source, proprietary Closed-source, proprietary Open-source GNU-GPL
Drivers ODBC, JDBC, ADO.NET, OLEDB, Microsoft Visual Studio ? ODBC, JDBC, ADO.NET, Microsoft Visual Studio
Standardized ANSI-SQL ANSI-SQL
Transactions Yes Yes Using InnoDB storage engine
Schema Yes Yes No
Partial Index Yes Yes No
Computed columns Yes Yes No
Failure Using MyISAM: UPS required, uninterrupted operation assumed
Active/Active clustering Read-only on second node Yes (RAC) No
Graphical Management Tools Yes: Management Studio and BI Studio Enterprise Manager MySQL Workbench. Toad.
Maintenance Plan Wizard Yes No
Job Scheduling Yes (Agent) Yes (Oracle Scheduler) v5.1 (Event Scheduler)
References
- http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems
- http://en.wikipedia.org/wiki/Microsoft_SQL_Server
- http://en.wikipedia.org/wiki/MySQL
- http://en.wikipedia.org/wiki/Oracle_RDBMS
Vey useful points to know about these differences.Learn sql basics from https://www.youtube.com/watch?v=7Vtl2WggqOg