SQLServer

Tutorial of SQLServer & Database for beginner..

Here We would discuss about…

•What is database ?
•What is relational database ?

DATABASE :-

•Database is collection of logically related information.
•Databases are an integral part of any organization.
•Database provide relevant information to the user.
•Database management is task of maintaining database so that information is readily available.

Relational DATABASE :-

•Relational database is attempt to simplify database structure. 

•Relational database represents all data in the Database as simple table format.

•Relational database can be defined as a Database where all data is organized strictly as tables of data values and where all database operation take place. 

SQL :-

•SQL is defined as Structured Query Language. 

•SQL is a query language that allows user to specify a condition. 

•SQL is a core language used to Store Data, Modify Data, Retrieve and Manipulate Data.

SQL command can be categorized as..

•DATA DEFINITION LANGUAGE

 1-Create 2-Alter 3-Drop

•DATA MANIPULATION LANGUAGE 

1- Insert 2-Update 3-Delete

•DATA CONTROL LANGUAGE

 1-Grant 2-Revoke

•DATA QUERY LANGUAGE

 1-Select

Some Data Types in SQL:-

•Char
•Varchar
•Date time
•Int
•Money
•Float
•Text
•Binary

 for more Information read next post...............................