What is Table in SQL and Syntax

 A relational database system contains one or more objects called tables. The data or information for the database are stored in these tables.

Syntax :

Create table tablename

(

rowname and data types 

     col1 is row name

     varchar2(10) is data types.

);

 example : 

Create table Employee

(

   Employe_id  varchar2(10) not null,

  First_Name  varchar2(10) not null,

  Middle_Name  varchar2(10) not null,

  Lost_Name  varchar2(10) not null

) ;

Please write the select statement.

select * form Employee

Result :-

 | Employe_id | First_Name | Middle_Name | Lost_Name|

the result will look above .

What is SQL?

SQL is one most wonted language for data base activities.
 
SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.

Some common relational database management systems that

 Use SQL for :
     Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system.

Impotent  SQL Commands.
1. DDL
       Create", and "Drop"

2. DML

         "Select", "Insert", "Update", "Delete"

The above SQL commands are very use full for all type of data base programmers.  This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter.