Before introducing SQL Server lets discuss on SQL. SQL (Structured Query Language) is a standard language for accessing and manipulating databases. SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

So What SQL can do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

SQL is standard?

If you know more than one databases then this question may be flash in your mind that if SQL is standard then why every databases having their own syntaxes? Although SQL is an ANSI/ISO standard, there are different versions of the SQL languages. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner. So, most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!

What is RDBMS

RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.

SQL Server

Micosoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. This product is built to achieve basic functionality (mentioned above for SQL) for storing and retrieving data as required by other applications. It can be run either on the same computer or on another across a network (Client-Server).