Database Week 2-2

Week 2-2

 - download DBMS

 MySQL






Download Link

 Install

 Step 1



















Step 2





















Step 3





















Step 4





















Step 5





















Step 6

Comments

Post a Comment

Popular posts from this blog

Database Week 2

Image
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/
Read more

Database Week 3

Image
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
Read more

Database Week 1

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
Read more