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.

Policy

GDATAMART.COM is optimized for learning & job information; The users try to improve your knowledge and practical experience through this site but we cannot warrant full correctness of all content... Learn More → | Sitemap →

© 2020 GDATAMART | All Rights Reserved