Database 2559

What have you done? Learn some SQL syntax from w3school website Query Result Any problem / solution ? Problem : New to MySQL workbench Solution : Search on internet Decision ? Use example database for Query Related info/Link/Reference ? Question : http://db2559.blogspot.com/ Learninng Website :  http://www.w3schools.com/sql/default.asp Post SQL : Structed Query Language is use to communicate with database

Week 2-2 - download DBMS MySQL Download Link Install Step 1 Step 2 Step 3 Step 4 Step 5 Step 6

Week 2 - export your grades/data from spreadsheet  to .csv format - write a program to read the . csv file  and calculate your GPA What have you done? Program for Calculate GPA CLICK HERE !! Any problem / solution ? Problem :  First spread sheet format not suit with python Solution : Create a new format Problem : Thai Language not support with python Solution : Change to English Word Decision ? Make new Column which tell year that register this subject Related info/Link/Reference ? Question http://db2559.blogspot.com/ Information http://klogic2.kmutnb.ac.th:8080/kris/index.jsp Web to run code https://c9.io/

Week 1 Enter your grades/transcript in a spreadsheet then calculate your GPA - Use google spreadsheet - with your email.kmutnb.ac.th account (by google) What have you done? Link => CLICK HERE !! Any problem / solution ? Problem : Grade Letter can't use for calculation Solution : Use VLOOKUP Problem : too many function use Solution : add another column for grade x weight Decision ? Make Hard Code for GPA Related info/Link/Reference ? Question http://db2559.blogspot.com/ Information http://klogic2.kmutnb.ac.th:8080/kris/index.jsp Vloopup https://www.youtube.com/watch?v=QGeXH5r6o6c