SQL Databases
SQL RDBMS Databases
In this tutorial we discuss - what are databases? How many types of databases are there? Many popular Relational Database Management System (RDBMS) are available to work with like:
- MySQL Database
- MS SQL Server
- Oracle Database
- MS Access
MySQL Database
MySQL was developed by Michael Widenius and David Axmark in 1994 but the present time MySQL is maintained by Oracle. MySQL is an open-source SQL database, which is developed by a Swedish company – MySQL AB. MySQL is pronounced as "my ess-cue-ell," in contrast with SQL, pronounced "sequel".
MySQL Features
- MySQL is supporting many different platforms including Microsoft Windows, the major Linux distributions, UNIX, and Mac OS X.
- MySQL has free and paid versions, depending on its usage of commercial/non-commercial and features.
- MySQL comes with a very fast, multi-threaded, multi-user and robust SQL database server.
- High Performance, High Availability, Scalability and Flexibility Run anything, Robust Transactional Support, Web and Data Warehouse Strengths & Strong Data Protection.
MySQL Version Released
| VERSION |
DATE |
| First internal release |
23rd May 1995 |
| Windows Version was released |
8th January 1998 |
| Version 3.23: beta |
June 2000, production release January 2001 |
| Version 4.0: beta |
August 2002, production release March 2003 |
| Version 4.01: beta |
August 2003 |
| Version 4.1: beta |
June 2004, production release October 2004 |
| Version 5.0: beta |
March 2005, production release October 2005 |
| MySQL AB |
26th February 2008 |
| Version 5.1 |
27th November 2008 |
MySQL supported third-party tools
- Drivers - ODBC, JDBC, .NET and C++
- Languages - C, C++, C#, Java, Delphi, Visual Basic, Perl, Python, and PHP
- Tools - Microsoft Visual Studio, Borland Delphi and JBuilder, Eclipse and NetBeans
MS SQL Server
MS SQL Server is a Relational Database Management System (RDBMS) developed by Microsoft Inc. Its primary query languages are T-SQL, ANSI SQL
MS SQL Version Released
| VERSION |
DATE |
| Sybase releases SQL Server for UNIX |
1987 |
| Microsoft, Sybase, and Aston-Tate port SQL Server to OS/2 |
1988 |
| SQL Server 1.0 for OS/2 |
1989 |
| SQL Server 1.1 is released with support for Windows 3.0 clients |
1990 |
| SQL Server 2000 |
2000 |
| XML for SQL Server Web |
2001 |
| SQLXML 2.0 / SQLXML 3.0 |
2002 |
| SQL Server 2005 |
2005 |
Oracle Database
Oracle is a relational database management system developed by 'Oracle Corporation'. Oracle supports all major operating systems for both clients and servers, including MSDOS, NetWare, UnixWare, OS/2 and most UNIX flavors.
Oracle Version Released
| VERSION |
DATE |
| Oracle began |
1977 |
| Version 2.0 |
1979 |
| Oracle released version 3.0 |
1983 |
| Oracle version 4.0 was released |
1984 |
| Oracle released Oracle11g |
2007 |
Oracle Features
- Oracle is an excellent database server choice for client/server computing.
- Oracle works to efficiently manage its resources, a database of information among the multiple clients requesting and sending data in the network.
- Quiesce Database, Portability, Self-managing database, SQL*Plus, ASM, Scheduler, Resource Manager, Data Warehousing, Materialized views, Bitmap indexes, Table compression, etc.
MS Access
MS Access means that Microsoft Access; Microsoft Access is one of the most popular Microsoft products. Microsoft Access is an entry-level database management software. MS Access database is not only inexpensive but also a powerful database for small-scale projects.
MS Access Features
- Importing and exporting the data to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc.
- Users can create tables, queries, forms, and reports and connect them together with macros.