10A SQL

Source: http://www.w3schools.com/sql/default.asp

Database Management Sotwares: MySQL, SQL Server, Access, Oracle, Sybase, DB2

Standard Query Language

Quiz: http://www.w3schools.com/sql/sql_quiz.asp

• 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

SQL SELECT Syntax

 SELECT column_name(s) FROM table_name

 SELECT DISTINCT column_name(s) FROM table_name

 SELECT column_name(s) FROM table_name WHERE column_name operator value

=	Equal
<>	Not equal
>	Greater than
<	Less than
>=	Greater than or equal
<=	Less than or equal
BETWEEN	Between an inclusive range
LIKE	Search for a pattern
IN	To specify multiple possible values for a column

SELECT * FROM Persons WHERE LastName='Svendson' AND (FirstName='Tove' OR FirstName='Ola')

SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC

DELETE FROM Persons WHERE LastName='Tjessem' AND FirstName='Jakob'

UPDATE Persons SET Address='Nissestien 67', City='Sandnes' WHERE LastName='Tjessem' AND FirstName='Jakob'

INSERT INTO Persons (P_Id, LastName, FirstName) VALUES (5, 'Tjessem', 'Jakob')