Monday, February 2, 2015

SQL Beginner

Sql is a standard language for accessing database eg: MySQL, SQL Server, Access, Oracle, Sybase, DB2.
SQL stands for structured query language.
Let us access database.
Is used for querying the database,
Insert,Update,Delete,create and manipulate database.

RDBMS
Relational Database Management System.
It is the basis of all database system
The data in RDBMS is stored in a db Object called Table
Table contains related data , it consists of columns and rows.
Following is a table customer in Database
CustomerId CustomerName
1 sunny
2 shekhar


Select * from customer 
 o/p
CustomerId CustomerName
1 sunny
2 shekhar





No comments: