1.

SQL (M) B. (vpapaliakos@gmail.com)

2.

SQL ???

SQL ;

;

;

SQL (.DML )

SQL

DML

3.

SQL;

Structured Query Language

( )

???

SQL:

-++ (;)

Keywords+Whitespace +semicolon (;)

-!SQL !

4.

videoClub

5.

6.

SelectQuery

:

SELECT- ( )

FROM ( )

WHERE = ... ; ( ...) ;

7.

SELECT FROM WHERE (1)

SELECT () FROM () WHERE( ) Redford: SELECTvideotitle FROMvideoclub_table WHEREartist=Redford;

!

videoclub_table

8.

SELECT FROM WHERE (2)

SELECT ( ) FROM () WHERE( ) , Redford: SELECTvideotitle ,copynumber, datedue FROMvideoclub_table WHEREartist=Redford;

9.

SELECT FROM WHERE ( 3 )

SELECT () FROM () WHERE( ) , Redford Jim Jones : SELECTvideotitle ,copynumber, datedue FROMvideoclub_table WHERE (( artist=Redford )and (borrower=Jim Jones));

()

10.

. ! ! !!!

11.

. 3 .

12.

SELECT () FROM () WHERE( ) SELECT videotitle FROM videoclubtable WHEREartist=Redford;

13.

...

: ( )

N SQL . 14. SELECT-FROM-WHERE .

15.

...

& Joins 16. Group by / order by / having 17. Queries Data Manipulation Language (update, delete, insert)

18.

... ( homework )

dropbox

(& ppt). 19. ! 20. 2 ( queries ) 21. ...

22.

SQL ;