SkillsLab 4B Implementeren

• Applicatie- en mediaontwikkelaar
• MBO
• Studiejaar 1

Welkom 👋

Kennisclip gezien? 👀

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

Kennisclip gezien? 👀

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

Wat heb je onthouden
van de kennisclip?

Wat is een goed voorbeeld van een domeinnaam?

1. http://student.nl/projectfifa
2. FTP
3. DigitalOcean
4. curio.nl

Hostingbedrijf

Domeinnaam

FTP

VPS

TransIP

curio.nl

Bestanden oversturen

Moeilijker dan shared hosting

Online zetten is verplichting bij einde project.

Kijk tegen die tijd eens terug in de Kennisbank.

Kennisclip gezien? 👀

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

ON

JOIN

FROM

klassen

SELECT ... AS ...

FROM tabel1

INNER JOIN tabel2

ON tabel1.foreign_key = tabel2.pk

SELECT ... AS ...

FROM tabel1

LEFT  JOIN tabel2

ON tabel1.foreign_key = tabel2.pk

SELECT

AS

FROM

JOIN

ON

WHERE

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

SELECT ________________________, ________________________

FROM teams
INNER JOIN -------------------
ON ------------------.creator_id =

1. teams.name AS team, players.name AS creator
2. teams.id AS team, players.id AS creator
3. players.id AS team, teams.name AS creator

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

1. teams
2. players

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

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

SELECT teams.name AS team, players.name AS creator

FROM teams

INNER JOIN players

ON teams.creator_id = players.id

Afsluiting

📃 Opdracht: lever in wat je hebt

📹 Houd je schoolmail in de gaten

👀 Zie ook 0 SkillsLab > 003 Kennisbank

❓ Stel je vragen!

📃 Opdracht in Itslearning

https://sqltest.amo.rocks/student/tests/9/

(gebruik de kennisbank / kennisclip hierbij)