SkillsLab 4B Implementeren

Welkom 👋
Kennisclip gezien? 👀


Log ook vast in via http://lessonup.app/ en de code

1 / 21
suivant
Slide 1: Diapositive
Applicatie- en mediaontwikkelaarMBOStudiejaar 1

Cette leçon contient 21 diapositives, avec quiz interactifs et diapositives de texte.

Éléments de cette leçon

Welkom 👋
Kennisclip gezien? 👀


Log ook vast in via http://lessonup.app/ en de code

Slide 1 - Diapositive

Kennisclip gezien? 👀


Log ook vast in via http://lessonup.app/ en de code

Slide 2 - Diapositive

Wat heb je onthouden
van de kennisclip?

Slide 3 - Carte mentale



Wat is een goed voorbeeld van een domeinnaam?
A
http://student.nl/projectfifa
B
FTP
C
DigitalOcean
D
curio.nl

Slide 4 - Quiz

Hostingbedrijf
Domeinnaam
FTP
VPS
TransIP
curio.nl
Bestanden oversturen
Moeilijker dan shared hosting

Slide 5 - Question de remorquage

Online zetten is verplichting bij einde project.

Kijk tegen die tijd eens terug in de Kennisbank.

Slide 6 - Diapositive

Kennisclip gezien? 👀


Log ook vast in via http://lessonup.app/ en de code

Slide 7 - Diapositive

Slide 8 - Diapositive

ON
JOIN
FROM
klassen

Slide 9 - Question de remorquage

SELECT ... AS ...
FROM tabel1
INNER JOIN tabel2
ON tabel1.foreign_key = tabel2.pk

Slide 10 - Diapositive

SELECT ... AS ...
FROM tabel1
LEFT  JOIN tabel2
ON tabel1.foreign_key = tabel2.pk

Slide 11 - Diapositive

SELECT
AS
FROM
JOIN
ON
WHERE

Slide 12 - Diapositive

SELECT name                       // kolommen
AS team_name                      // alias
FROM teams                        // tabel 1
JOIN players                      // tabel 2
ON teams.creator_id = players.id  // FK = PK
WHERE teams.id = :id              //voowaarde

Slide 13 - Diapositive

Slide 14 - Diapositive

SELECT ________________________, ________________________

FROM teams
INNER JOIN -------------------
ON ------------------.creator_id =
A
teams.name AS team, players.name AS creator
B
teams.id AS team, players.id AS creator
C
players.id AS team, teams.name AS creator

Slide 15 - Quiz

SELECT teams.name AS team, players.name AS creator
FROM teams
INNER JOIN ____________
ON ----------------.creator_id = ----------------
A
teams
B
players

Slide 16 - Quiz

SELECT teams.name AS team, players.name AS creator
FROM teams
INNER JOIN players
ON ____________.creator_id = ----------------

Slide 17 - Question ouverte

SELECT teams.name AS team, players.name AS creator
FROM teams
INNER JOIN players
ON teams.creator_id = ____________

Slide 18 - Question ouverte

SELECT teams.name AS team, players.name AS creator
FROM teams
INNER JOIN players
ON teams.creator_id = players.id

Slide 19 - Diapositive

Afsluiting
📃 Opdracht: lever in wat je hebt
📹 Houd je schoolmail in de gaten
👀 Zie ook 0 SkillsLab > 003 Kennisbank
❓ Stel je vragen!

Slide 20 - Diapositive

📃 Opdracht in Itslearning
https://sqltest.amo.rocks/student/tests/9/

(gebruik de kennisbank / kennisclip hierbij)

Slide 21 - Diapositive