find and solve || findandsolve.com
Please wait.....

Microsoft SQL Sever Management Studio Tutorial

In the article, you will learn ms SQL server. Structured Query Language (SQL), which is a computer language for storing, searching, manipulating, and retrieving data stored in a relational database. This is a simple Microsoft SQL server tutorial.

The SQL became a standard of the American National Standards Institute (ANSI) in 1986 and the International Organization for Standardization (ISO) in 1987. The SQL tutorial provides basic and advanced concepts of SQL Server. We use SQL tutorials designed for both database beginners and professionals or DBA and developers. Structured Query Language (SQL) is used to perform operations on the records stored in the database Server which is updating records, getting record lists, inserting records, deleting records, creating and modifying database tables, views, etc.

RDBMS (All the Relational Database Management Systems) like   MS Access, MySQL, Oracle, Sybase, Informix, Postgres, and SQL Server use SQL as their standard database language.


MS SQL Tutorial for beginners

  • 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


Learn MS SQL History

  • 1970 − Dr. Edgar F. "Ted" Codd of IBM is known as the father of relational databases. He described a relational model for databases.
  • 1974 − Structured Query Language appeared.   
  • 1978 − IBM worked to develop Codd's ideas and released a product named System/R.
  • 1986 − IBM developed the prototype of relational database and standardized by ANSI. The first relational database was released by Relational Software which later came to be known as Oracle.


RDBMS        

We know well RDBMS means  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 consists of columns and rows.

Example
SELECT * FROM EmployeeInfo;
Description
  • SELECT: 
  • * :
  • FROM: 
  • EmployeeInfo: