SQL & MYSQL learning notes

10000 cute sms in 33 different categories and all mobile stuff for free please support us by visiting our sponsor website replysms.com

Learning Sql from admin of this Websie

SQL Intro	SQL Delete	SQL Union
SQL Tables	SQL Order By	SQL Create
SQL Select	SQL AND & OR	SQL Drop
SQL Where	SQL In	SQL Alter
SQL Like	SQL Between	SQL Functions
SQL Insert	SQL Aliases	SQL Group By
SQL Update	SQL Join	SQL Select Into
SQL Create View

What is SQL?

SQL stands for Structured Query Language

SQL allows you to access a database

SQL is an ANSI standard computer language

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert new records in a database

SQL can delete records from a database

SQL can update records in a database

SQL is easy to learn

SQL is a Standard - BUT....

SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL statements are used to retrieve and update data in a database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc.

Unfortunately, there are many different versions of the SQL language, but to be in compliance with the ANSI standard, they must support the same major keywords in a similar manner (such as SELECT, UPDATE, DELETE, INSERT, WHERE, and others).

Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!