Linguaggio SQL
Presentation
•
Computers
•
12th Grade
•
Medium
DANILO SANTORO
Used 3+ times
FREE Resource
5 Slides • 2 Questions
1
Database
Linguaggio SQL
2
SQL
originariamente "Structured Query Language", ora "nome proprio"
linguaggio con varie funzionalità: contiene sia il DDL sia il DML
ne esistono varie versioni
3
Definizione dei dati in SQL
Istruzione CREATE DATABASE:
Crea un nuovo database, che potrà contenere tabelle, viste, trigger o altri tipi di oggetti
Esempio: CREATE DATABASE SCUOLA
4
CREATE TABLE ESEMPIO
CREATE TABLE Impiegato(
_Matricola CHAR(6) PRIMARY KEY,
_Nome CHAR(20) NOT NULL,
_Cognome CHAR(20) NOT NULL,
_Dipart CHAR(15),
_Stipendio NUMERIC(9) DEFAULT 0, FOREIGN KEY(Dipart) REFERENCES Dipartimento(NomeDip),
UNIQUE (Cognome,Nome)
)
5
6
Fill in the Blanks
DDL means
Type answer...
7
Multiple Choice
SQL is
Structured Query Language
Simple Query Language
Structured Question Language
Structure Quality Language
Database
Linguaggio SQL
Show answer
Auto Play
Slide 1 / 7
SLIDE
Similar Resources on Wayground
6 questions
Likes & Dislikes - Lesson 1
Presentation
•
12th Grade
6 questions
Procedure Text
Presentation
•
12th Grade
9 questions
Database Normalization
Presentation
•
12th Grade - University
7 questions
BIOMETRIA
Presentation
•
12th Grade
8 questions
Tie Breaker
Presentation
•
University
6 questions
SDLC
Presentation
•
KG - University
5 questions
PDA Software - Analysis PHP Processing
Presentation
•
12th Grade
6 questions
FORMAS EDUCAÇÃO INFANTIL
Presentation
•
KG
Popular Resources on Wayground
10 questions
Safety Day 2026 – Student Review
Quiz
•
9th Grade
21 questions
Continents and Oceans
Quiz
•
6th Grade
20 questions
Parts of Speech
Quiz
•
5th Grade
16 questions
Subject & Predicate
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
12 questions
Map Skills
Quiz
•
3rd Grade
22 questions
Continents and Oceans
Quiz
•
5th Grade
15 questions
Rounding Decimals
Quiz
•
5th Grade