| |
|
What is SQL? Structured Query Langauge.
SQL is a globally accepted standard language that is used to handle database related activities
for creating database schemas, updating/inserting/deleting of data, retrievieng data, and managing user roles
and databases activities.
It stands for Structured Query Language
SQL is packaged and marketed by several companies. A few popuplar versions of SQL are Oracle SQL (7,8,9i,10g,11i),
Microsoft SQL Server (7,2000,2005,2008), IBM DB2, MySQL, Microsoft Access, Postgres SQL, Sybase etc.
SQL Queries
SQL
Create Table
DDL, Create, Alter, Drop commands
DML, Select, Insert, Update, Delete
Create Database
ACID Rules
Dual Table
NULL
Join, Inner, Outer, Left, Right, Full, Cartesian, Natural, Equi
Table, View and a Synonym?
Execute
Function
Stored Procedure
Syntax Stored Proc
Stored Procedure Vs. Function
| |