SQL

t

r

u

c

t

u

r

e

d

u

e

r

y

a

n

g

u

a

g

e

This is Turing Bootcamp.

Today

+ Life with King's Day 

+ Your progress and mentor sessions

+ Feedback 

+ Hello SQL and Databases 

+ Algorithms 

This is Turing Bootcamp.

This Week

You are here.

King's Day

Venture Cafe

Rotterdam

Weekend

No coding hours.

This is Turing Bootcamp.

Progress

Front End 

Challenge

Back End

Challenge

This is Turing Bootcamp.

Full Stack

Challenge

That's you.

next 2 weeks: bit.ly/turingmeet

Feedback

This is Turing Bootcamp.

anonymous.

www.suggestionox.com/r/turing

This is Turing Bootcamp.

SLANG OF TODAY

SQL

NoSQL

Relational Database

ERD

entities

attributes

primary key

foreign keys

relationships

one to one

many

many to many

normalization

data types

This is Turing Bootcamp.

What you should know:

> SQL: tables holding data 

> Tables are usually related to each other

> ERD helps you visualize your database

> Watch the DEMOs :-)

This is Turing Bootcamp.

Algorithm Time

MAGIC

SQUARES

This is Turing Bootcamp.

4 9 2

3 5 7

8 1 6

 Input: Numbers between 1-9 

2 7 6

9 5 1

4 3 8

This is Turing Bootcamp.

[8, 1, 6, 3, 5, 7, 4, 9, 2] => true
[2, 7, 6, 9, 5, 1, 4, 3, 8] => true
[3, 5, 7, 8, 1, 6, 4, 9, 2] => false
[8, 1, 6, 7, 5, 3, 4, 9, 2] => false

Example Input/Output