Data Management

Subjects:
516 722 Research Data Management
516 913 Health Database Management 
516 914 Selected Topics in Programming in Health Informatics

Resources:
Practical guide for clinical data management
Common MySQL Qreries
https://www.citiprogram.org
Joining data in Stata 
Cleaning data in Stata [1], [2]

*******************************************************

516 913 Health Database Management: 2(1-3-3)
Knowledge of health informatics and health information systems, key standards in health informatics, data warehousing and data mining for health care, knowledge management in health service, decision making support system, health information-related ethics, guidelines, and regulations

Aims: After completion of the course, participants should be able to:

• Describe principle of health informatics and health information systems
• Conduct research by using the context of existing health databases
• Master the use of MySQL to manage database

Course schedule [15 weeks]:

Week-1 
A. Introduction      

15 January: Orientation

09.00 - 10.30: Course orientation
10.45 - 12.00: Describe course outline
13.00 - 14.30: Get use to key standards in health informatics; participants will be assigned to self-study the standard for each (เลือก key standards ที่สนใจ พร้อมหา article ที่เกี่ยวข้องกับ standard กับตัวแปรที่อยู่ใน 43 แฟ้ม)
                           - HL7 (http://www.hl7.org),
                           - SNOMED-CT(http://www.ihtsdo.org),
                           - ICD-10, ICD-9-CM, ICD-O (For international: http://www.who.int/classifications/icd/en; for Thai: http://www.this.or.th),

           - LOINC, etc,.

           - Introduce 43-File database

14.45 - 15.30: Install and introduce prerequisite programs; Stata, Navicat, ODBC, XAMPP
15.30 - 16.00: Understanding fundamental of data management

Week-2 
B. Health informatics and health information systems    

29   January

09.00 - 16.00: Presentation & discussion on key standards in health informatics

Week-3

5  February [Dr.Wilaiphorn & Team] (1)

9.00 – 16.00: Research Project management

         -  Design essential documents based on protocol;

- Case Report Form (CRF),

- Log,

- Informed Consent Form (ICF),

- Standard Operating Procedure (SOP),

- ect.

         -   Ethical issues; ICH – GCP training

         -   Develop guideline for data ownership/ data retrieval guideline

Week-4 
12 February [Dr.Wilaiphorn & Team] (2)

9.00 – 16.00: Research Project management

         -  Design essential documents based on protocol;

- Case Report Form (CRF),

- Log,

- Informed Consent Form (ICF),

- Standard Operating Procedure (SOP),

- ect.

         -   Ethical issues; ICH – GCP training

         -   Develop guideline for data ownership/ data retrieval guideline

Week-5 
19 February [Dr.Kavin & Team]

09.00 – 16.00: Design Module in Thai Care Cloud

         -   Design CRFs, Log, ICF in Module

Week-6

26 February [Dr.Kavin & Team]

09.00 – 16.00: Design Module in Thai Care Cloud

                                  - Archive essential documents in Module

                                  - Create dynamic report in Module

Week-7 
5 March [Mr.Panuwat & Team]

09.00 – 16.00:
                    - Communication across multidisciplinary and advanced report form: jQuery, Structure query language (SQL)
                    - Angular & Stata
                    - Present working Modules [4 students]

Week-8
12 March [Mr.Chaiwat & Team]

09.00 – 16.00: How to handle complex data (1)

      -  Data cleaning and query management [query and resolution]

      -  Handling complex data using Purify [Purify] [ICF]

      -  Relational database implemented by SQL [Link 1, Link 2, Link 3]

      -  Assignment (1)

     - Present working Modules [3 students]

Week-9 
19 March [Dr. Bandit & TA Team]

09.00 – 16.00: How to handle complex data (2)

      -  Data cleaning and query management [query and resolution]

      -  Handling complex data using Purify

      -  Relational database implemented by SQL

      -  Assignment (2)

     - Present working Modules [3 students]

Week-10 
26 March [Dr. Bandit & TA Team]

09.00 – 16.00: Present Assignment 1 & 2

Week-11 
2 April [TA Team]

09.00 – 12.00: Big data mining

03.00 – 16.00: Present final working Modules [10 students]

Week-12 
9 April [Dr. Wilaiphorn and TA Team]

09.00 – 16.00: Interested article on data management

Week-13 
23 April [Dr. Bandit & TA Team]

09.00 – 16.00: Present interested article (1)

Week-14 
30 April  [TA Team]

09.00 – 16.00: Present interested article (2)

Week-15
7 May  [Dr. Bandit & TA Team]

Course evaluation