Microsoft SQL Server Overview

Introduction

SQL stands for Structured Query Language which is  database computer language designed for the retrieval and management of data in relational database MS Sql rely on RDBMS. Relational Database Management Systems like MySQL, MS Access, Oracle, Sybase, Informix, postgres and SQL Server use SQL as standard database language.

Wkipedia says “ As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on another computer across a network (including the Internet)” .

SQL Release History

SQL- Query Syntax

All the SQL statements start with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW. and ends with semicolon(;).

Using Sql

1. User can access data in relational database management systems.

2. User can define the data in database and manipulate that data. 

3. User can create and drop databases and tables.

4. User can create view, stored procedure, functions in a database.

5. User can set permissions on tables, procedures, and views

SQL Commands

SQL commands can be divided into three subgroups, DDL, DML and DCL.

DDL stands for Data Definition Language which is useful in database schemas and descriptions, of how the data should reside in the database. Create ,Alter ,Drop ,Truncate queries used by DDL .

DML stands for Data Manipulation Language which is useful in data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE.

DCL stands for Data Control Language which includes commands such as Revoke, GRANT, and mostly concerned with rights, permissions and other controls of the database system.