Overview

• Basic of computer
• How programming work with computer
• Learn Golang, Nodejs
• Workshop create OWN elk stack
• Build web application (database design)

Today 8/9/2019

• Overview basic of computer & programming
• Overview Workshop project

Overview of web application

1. key Url (input) === request to server ===>
2. receieve request and processing (process) (read data from database)
3. send response (output) eg.

School web application

1. student data
2. class data
3. student register to class
4. student schedule class
5. grade of student

log of school application

1. response status

database design

• id (1,2,3,4)
• name
• student_id
• image
• date_of_birth
• username
• password
• created_date
• updated_date

• id
• subject_id
• name
• created_date
• updated_date

• id
• class_id
• start_date
• end_date
• created_date
• updated_date

class => class_schedule (1 => many)

• id
• class_id
• day
• time_start
• time_end
• created_date
• updated_date

• id
• student_id
• course_id
• grade
• point
• created_date
• updated_date student => register <= course 1 => M <= 1 (many to many)

Data example

id name 1 thai language

id class_id start_date end_date 1 1 1/5/2019 1/11/2019

id course_id day time_start time_end
1 1 Monday 10:00 12:00
2 1 Tuesday 9:00 11:00

• design database

• collect employee detail

• separate by employee section

• collect Leave information of employee