SQL Select, Select distinct
Select Distinct Clause
SQL Where Clause
SQL And, Or, Not
SQL Aliases
SQL Like
SQL In
SQL Between
Order By Clause
Aggregate Functions (Min, Max, Avg, Sum, Count)
Count
AVG() Syntax
SUM
MIN
MAX
Group By
HAVING Clause
SQL Insert Into
SQL Create Table
SQL Drop Table
SQL Alter Table
SQL Constraints
SQL Not Null
SQL Unique
SQL Primary Key
SQL Foreign Key
SQL Default
IBM sequel (Structured English Query Language) language developed as part of the system R project at the IBM San Jose Research laboratory. Renamed as Structured Query Language (SQL)
A joint effort by ANSI (American National Standard Institute) and ISO (International organization of Standardization) has led to standard versions of SQL such as
SQL-86
SQL-89
SQL-92
SQL-1999
SQL-2003
SQL is used to manipulate the data in the database.
What is Database?
The database contains information about a particular enterprise.
It is a convenient and effective way to use the data.
It has a collection of interrelated data.
SQL helps to access, create, update, modify, and delete the data quickly from the database.
SQL is widely in use commercial language, considered as the primary reason for the success of a relational database (RDBMS- Relational Database Management System).
SQL is not Turing Machine equivalent language, which cannot solve all the problem, it needs to embed with other high-level languages (Eg. C, C++)
Don't miss out!
Study Material