SQL Server Tutorial

Introduction

  • SQL server is a Relational Database Management System (RDBMS) developed by Microsoft.
  • It is used to store and retrieve data as requested by the other software applications that may be running on same computer or other computers through the network.
  • SQL server is a client / server database management system opposite to a desktop system (For example: Assess).
  • SQL server setup is easily available on Microsoft's website.

Advantages of SQL

1. High Speed
SQL queries play an important role in retrieving large amounts of records from a database efficiently at a faster rate.

2. Well Defined Standards Exist
SQL databases use long-established standard, which is being adopted by ANSI & ISO. On the contrary, NO- SQL databases do not cling to the use of any specific standard.

3. No Coding Required
Without writing substantial amount of code, standard SQL has a provision to mange the databases systems easily.

4. Emergence of ORDBMS
Due to growth of Object Oriented DBMS, object storage capabilities are extended to relational databases.

Disadvantages of SQL

1. Difficulty in Interfacing
Interfacing an SQL database is more complex than adding a few lines of code.

2. More Features Implemented in Proprietary way
Though SQL databases follow ANSI & ISO standards, some databases adhere to proprietary extensions to standard SQL to ensure vendor lock-in mechanism.