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

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

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

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.

Advertise With Us

We offer sponsored posts and guest posts with do-follow links, back-links, and other advertising services, To advertise email us at ""

© 2021 GDATAMART.COM (All Rights Reserved)