SQL

What is SQL?


  • SQL stands for Structured Query Language
  • SQL lets you access and manipulate databases
  • SQL is an ANSI (American National Standards Institute) standard


SQL helps us to do follwing things..


  • It can execute queries against a database
  • It can retrieve data from a database
  • It can insert records in a database
  • It can update records in a database
  • It can delete records from a database
  • It can create new databases
  • It can create new tables in a database
  • It can create stored procedures in a database
  • It  can create views in a database
  • It can set permissions on tables, procedures, and views

Few SQL Commands

  • SELECT - extracts data from a database
  • UPDATE - updates data in a database
  • DELETE - deletes data from a database
  • INSERT INTO - inserts new data into a database
  • CREATE DATABASE - creates a new database
  • ALTER DATABASE - modifies a database
  • CREATE TABLE - creates a new table
  • ALTER TABLE - modifies a table
  • DROP TABLE - deletes a table
  • CREATE INDEX - creates an index (search key)
  • DROP INDEX - deletes an index



No comments:

Post a Comment