SQL SERVER -- Introduction to SQL -- Part-1

What is SQL Server?

1.    SQL Stands for Structured Query Language.

2.     It is the secret of instructions used to interact with a relational database.

3.     In fact SQL is the only language that most databases actually understand.

4.     SQL is a computer language for storing, manipulating and retrieving the data from relational database.

5.     Product of Microsoft

6.     Enables user to write queries and other SQL statements and execute them

Why SQL?

1.     Allows users to access data in relational database management systems.

2.     Describe the data.

3.     Define the data in database and manipulate that data.

4.     Allows embedding within other languages using SQL modules, libraries &  pre-compilers.

5.     Create and Drop databases and tables.

6.     Create View, Stored Procedure, and Functions in a database.