- Introduction to SQL
What is SQL?
===========SQL is a standard language for accessing databases.
- SQL stands for Structured Query Language
- SQL lets you access and manipulate databases
- SQL is an ANSI (American National Standards Institute) standard
========================You can use WAMP server .The link is WAMP , or can download SQL from here .
RDBMS is the basis for SQL, and for all modern database systems (Refer the link
Introduction to DBMS / RDBMS )
without SQL or any other knid of Databases, we can't store informations.
Quick reference Useful Commmands at a glance
(SQL - Quick reference)
(SQL - Quick reference)
(A) Some basics of SQL
- SQL-create Database & Table
- SQL-Statements
- Starting SQL Commands
- SQL "SELECT" STATEMENT
- SQL " SELECT DISTINCT " STATEMENT
- SQL "WHERE" Clause
- SQL " AND & OR "Operators
- SQL "ORDER BY" Keyword
- SQL "INSERT INTO" Statement
- SQL "UPDATE" Statement
- SQL "UPDATE" Statement
(B) Advanced SQL