GKsea.com image

Serving the world with Accurate GK and Current Affairs

Advertisements

Welcome @ SQL Home


Introduction to SQL
SQL stands for Structured Query Language. It is a standard structured query based language for accessing and manipulating databases like MySQL, SQL Server, Oracle, Sybase, DB2 etc. SQL is an ANSI (American National Standards Institute) standard which is followed by all of the database systems written above although some of syntax may differ while handelling all database systems but mostly the fundamentals remain same.

First of all what is a database?
A database is a collection of one or more tables containing data. Each table is referred by a unique name.

Some of The Most Commonly Used SQL Commands

  • SELECT - for retrieving data from a database that is to see the data of a table.
  • UPDATE - for updating data in a database.
  • DELETE - for deleting data from a database.
  • INSERT INTO - for inserting new data into a database.
  • CREATE DATABASE - for creating a new database.
  • ALTER DATABASE - for modifying a database.
  • CREATE TABLE - for creating a new table.
  • ALTER TABLE - for modifying a table structure.
  • DROP TABLE - for deleting a table object.
  • CREATE INDEX - for creating an index (search key).
  • DROP INDEX - for deleting an index.

Click for More

Must Check


Advertisements

footer

Advertisements

Copyright© 2013-2015 Gksea.com. Powered by dataNcode | Disclaimer and Terms

Contact Us Mail Us