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