SQL intro, SELECT-FROM-WHERE, projections Download
LIKE, ORDER BY Download
Ambiguity, variables, set operations (UNION, INTERSECT, EXCEPT), subqueries Download
Joins, aggregate functions Download
Aggregation with GROUP BY and HAVING, many excersizes Download
Risposte alla provetta, DML: INSERT, UPDATE, DELETE, DDL: domini, CREATE TABLE Download
Vincoli, ALTER, DROP, Viste, Indici Download
Asserzioni, Trigger, Transazioni, JDBC Download
Esami gedli anni precedenti Download
Allenamento all'esame Download
CREATE TABLE Movie (
title VARCHAR(255),
year INTEGER,
length INTEGER,
inColor BIT(1),
studioName CHAR(50),
producerC# INTEGER,
PRIMARY KEY (title, year)
);
CREATE TABLE StarsIn (
movieTitle VARCHAR(255),
movieYear INTEGER,
starName CHAR(30)
);
CREATE TABLE MovieExec (
name CHAR(30),
address VARCHAR(255),
cert# INTEGER PRIMARY KEY,
netWorth INTEGER
);
CREATE TABLE MovieStar (
name CHAR(30),
address VARCHAR(255),
gender char(1),
birthday date
);
CREATE TABLE Studio (
name CHAR(50) PRIMARY KEY,
address VARCHAR(255),
presC# INTEGER
);
INSERT INTO "Movie" VALUES ('Logan''s run', 1976, NULL, 1, '', '888');
INSERT INTO "Movie" VALUES ('Star Wars', 1977, 124, 1, 'Fox', '555');
INSERT INTO "Movie" VALUES ('Empire Strikes Back', 1980, 111, 1, 'Fox', '555');
INSERT INTO "Movie" VALUES ('Star Trek', 1979, 132, 1, 'Paramount', '444');
INSERT INTO "Movie" VALUES ('Star Trek: Nemesis', 2002, 116, 1, 'Paramount', '321');
INSERT INTO "Movie" VALUES ('Terms of Endearment', 1983, 132, 1, 'MGM', '123');
INSERT INTO "Movie" VALUES ('The Usual Suspects', 1995, 106, 1, 'MGM', '999');
INSERT INTO "Movie" VALUES ('Gone With the Wind', 1938, 238, 1, 'MGM', '123');
INSERT INTO "Movie" VALUES ('The Man Who Wasn''t There', 2001, 116, 0, 'USA Entertainm.','777');
INSERT INTO "Movie" VALUES ('Pretty Woman', 1990, 119, 1, 'Disney','999');
INSERT INTO "Movie" VALUES ('Mighty Ducks', 1991, 104, 1, 'Disney', '67890');
INSERT INTO "Movie" VALUES ('Wayne''s world', 1972, 95, 0, 'Paramaunt', 234);
INSERT INTO "MovieExec" VALUES ('George Lucas', 'Oak Rd.', 555, 200000000);
INSERT INTO "MovieExec" VALUES ('Ted Turner', 'Turner Av.', 333, 125000000);
INSERT INTO "MovieExec" VALUES ('Stephen Spielberg', '123 ET road', 222, 100000000);
INSERT INTO "MovieExec" VALUES ('Merv Griffin', 'Riot Rd.', 199, 112000000);
INSERT INTO "MovieExec" VALUES ('Calvin Coolidge', 'Fast Lane', 123, 20000000);
INSERT INTO "MovieStar" VALUES ('Jane Fonda', 'Turner Av.', 'F', '7/7/77');
INSERT INTO "MovieStar" VALUES ('Alec Baldwin', 'Baldwin Av.', 'M', '6/7/77');
INSERT INTO "MovieStar" VALUES ('Kim Basinger', 'Baldwin Av.', 'F', '5/7/79');
INSERT INTO "MovieStar" VALUES ('Harrison Ford', '789 Palm Dr., Beverly Hills', 'M', '7/7/77');
INSERT INTO "MovieStar" VALUES ('Carrie Fisher', 123 Maple Str., Hollywood', 'F', '9/9/99');
INSERT INTO "MovieStar" VALUES ('Mark Hamill', '456 Oak Rd., Brentwood', 'M', '8/8/88');
INSERT INTO "MovieStar" VALUES ('Debra Winger', 'A way', 'F', '5/6/78');
INSERT INTO "MovieStar" VALUES ('Jack Nicholson', 'X path', 'M', '5/5/49');
INSERT INTO "MovieStar" VALUES('Julia Roberts', '123 Billings Rd.', 'F', '23-Feb-1963');
INSERT INTO "MovieStar" VALUES('Robert de Niro', '34 Cambridge Blvd', 'M', '3-Jan-1950');
INSERT INTO "MovieStar" VALUES('Melany Griffin', '34 Boston Blvd', 'F', '3-Jan-1950');
INSERT INTO "StarsIn" VALUES ('Star Wars', 1977, 'Carrie Fisher');
INSERT INTO "StarsIn" VALUES ('Star Wars', 1977, 'Mark Hamill');
INSERT INTO "StarsIn" VALUES ('Star Wars', 1977, 'Harrison Ford');
INSERT INTO "StarsIn" VALUES ('Empire Strikes Back', 1980, 'Harrison Ford');
INSERT INTO "StarsIn" VALUES ('The Usual Suspects', 1995, 'Kevin Spacey');
INSERT INTO "StarsIn" VALUES ('Terms of Endearment', 1983, 'Debra Winger');
INSERT INTO "StarsIn" VALUES ('Terms of Endearment', 1983, 'Jack Nicholson');
INSERT INTO Studio VALUES ('Disney', 'Drive Rd.', 1)
INSERT INTO Studio VALUES ('Paramount', 'Drive Way', 2)
INSERT INTO Studio VALUES ('MGM','MGM Boulevard', 123);