What is SQL Server? Uses of SQL Server & History of SQL Server Database

  Total Views : 647
  Comments : 0
 
  Keywords : SQL Server introduction, SQL Server overview, What is the use of sql server?, Why we need sql server?, What is sql server database

Introduction to SQL

SQL stands for structured query language. SQL Server is relational database management system (RDBMS)

What is SQL Server?

Its relational database management system (RDBMS) developed by Microsoft. By using SQL Server we can store and retrieve data from one place called database and use that data whenever it required in other programming applications. SQL also same as other relational database management systems like Sybase, mysql, pl/sql etc… covered

Uses of SQL Server

   - It will allow us to access data in database and perform different operations on data

   - We can create databases, tables and stored procedures to access data in required format

   -  We can do insert, update, delete, select etc… to communicate with data stored in databases.

   - We can create views, functions, indexes, keys etc… in database to get data in efficient way

   - In SQL we can create roles and user level permissions to access data in databases

   -  We can access SQL database data from other languages using SQL modules, libraries

History of SQL Server

The journey of SQL started from 1989 originally code base for this SQL sold by Sybase SQL Server to Microsoft. They launched this product as competitor for IBM, Oracle, etc… Overall Microsoft has launched more than 12 versions check below table for more information.

 

Version

Release Name

Year

1.0

SQL Server 1.0

1989

1.1

SQL Server 1.1

1991

4.21

SQL Server 4.21

1993

6.0

SQL Server 6.0

1995

6.5

SQL Server 6.5

1996

7.0

SQL Server 7.0

1998

8.0

SQL Server 2000

2000

8.0

SQL Server 2000 (64 Bit Version)

2003

9.0

SQL Server 2005

2005

10.0

SQL Server 2008

2008

10.25

Azure SQL DB

2010

10.50

SQL Server 2008 R2

2010

11.0

SQL Server 2012

2012

12.0

SQL Server 2014

2014

 

 Comments (0)

Be the first to give your valuable feedback

Leave a comment

  • Default Tutlane User