Session 2 BIZ (3).pptx - Data Resources Management Lecturer Yong Liu Contact me at [email protected] Messenger • Soyoung Kim Juustovaara mailto

Session 2 BIZ (3).pptx - Data Resources Management Lecturer...

This preview shows page 1 - 15 out of 62 pages.

Data Resources Management Lecturer: Yong Liu Contact me at: [email protected]
Image of page 1

Subscribe to view the full document.

Messenger Soyoung Kim Juustovaara - mailto: [email protected] - Tel: +358 0449894294 If you have any comment on the course, please share with Soyoung Kim or me. 11/15/2019 2
Image of page 2
Exam registration All the course participants automatically register for the first exam. However, you need to make a separated registration for the second exam (or re-exam) via WebOodi by yourself. 11/15/2019 3
Image of page 3

Subscribe to view the full document.

About Task 5.2 - kill a process Very often that a command takes hours to operate when using a big data. MySQL server will operate the command [e.g. create a new table] from you, irrespective of whether you closed HeidiSQL (or MySQL) from your own computer or not. A very useful function to free your server from a resource- consuming command sent by you or by other users (if you are a administrator). You can “tell” a server to cancel the query from anywhere via your MySQL account. We have some (10+) free seats for hands-on sessions. 11/15/2019 4
Image of page 4
Tips MySQL command is NOT case-sensitive . The names of database, table, columns are not case-sensitive in Windows, but case- sensitive in most varieties of Unix. 11/15/2019 5
Image of page 5

Subscribe to view the full document.

Tips for HeidiSQL (1) HeidiSQL provides “Query history”. Remember to use this function! 11/15/2019 6
Image of page 6
Tips for HeidiSQL(2) In HeidiSQL, you can have several query- windows! 11/15/2019 7
Image of page 7

Subscribe to view the full document.

Objectives for class 2 - Difference between remote and local server - Exporting data to be a .csv file (Tips) - Writing comments (annotations) for query - Create, drop and change (default) database - Create and drop table in a database - Understanding data types - Key and index (if we have time) - presemo.aalto.fi/drm will be used for in-course QA 8
Image of page 8
11/15/2019 9 Remote server Local server Main work station—super computer (Hostname : kennedy.org.aalto.fi) Your data is normally hosted and operated by a super computer The speed of data manipulation could be very fast Main work station—your own laptop (Hostname: 127.0.0.1) Your data is hosted and operated locally. The speed of data manipulation is determined by the capability of your own laptop Network is required! Can only be used in student network in our case Network is not necessary! Can be used everywhere with your own laptop Permission Restricted user right E.g. cannot create database Permission Full user right Security of data Your data is secure even if your own computer collapses. Security of data You may lose your data if your system collapses. Section 1
Image of page 9

Subscribe to view the full document.

Section 2: export data to be a csv file Select the table that you want to export. Activate the data windows Tool export grid rows 11/15/2019 10
Image of page 10
HeidiSQL Tips (1): showing more records 11/15/2019 11
Image of page 11

Subscribe to view the full document.

HeidiSQL Tips (2): showing more records Solution 1: - Tools Preferences Grid formatting Solution 2: - Fast key: ctrl + End 11/15/2019 12
Image of page 12
Section 3: Adding comments 11/15/2019 13
Image of page 13

Subscribe to view the full document.

Adding comments: methods # ” [ hashtag ] character to the end of the line.
Image of page 14
Image of page 15
  • Fall '19

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes