https:// ajawatanawonglab.me

Ajawatanawong's Lab
Ajawatanawong's Lab

https:// ajawatanawonglab.me

  • Home
  • Publications
  • Teach-n-Talk
  • Blogs
  • Photos
  • Contact

SIRE512 Data Management and Database

Course Description

We cannot deny that the data flows through us every day, from when we wake up in the morning until we go to bed and from birth until we die. Those massive data become more complicated in patterns and formats, even in a single student’s thesis. Molecular biology and omics technologies have been dramatically improved in the last two decades. Consequently, a massive of data was generated from laboratories around the world. Data management, analysis, and sharing became severe problems for almost all biologists, including bioinformaticians and computational biologists. If we do not have a good way to store that can facilitate the downstream analysis, it affects the speed and accuracy of the analysis results. Therefore, this course was designed for Master's students in the medical bioinformatics program, biomedicine, and other bioscience programs to easily work with massive amounts of data. The course mainly focuses on the broad concepts of databases, including database design, programming, data retrieving, and analysis. Although the depth of knowledge from this course is at the intermediate level, students should be able to continue to acquire knowledge in the future.


I took over this course in 2003 and rearranged the course to emphasize database design and construction for bioinformatic students and other non-computer science students who plan to use databases to manipulate their data. The course is run by the master’s degree program in Medical Bioinformatics (International Program) of the Faculty of Medicine Siriraj Hospital. It is a two-credit course comprising 21 lectures and six computer practices. The course is regularly open to enroll in the first semester of every academic year, around October to November. Please keep an eye on the announcement on this web or Facebook of the lab to confirm the seat if you are not a student.

Topics

  1. Introduction to Databases
  2. Basics in Database Management Systems (DBMS)
  3. Data, Data Models, and Database Architecture
  4. Relational Database Model
  5. Conceptual Database Design
  6. Logical Database Design
  7. Data Dependencies
  8. Normalization
  9. Physical Database Design
  10. Basic in Structural Query Language (SQL)
  11. SQL Commands
  12. Data Integrity Rules and Data Dictionary
  13. Views and Indexes
  14. NoSQL Database
  15. Applications of Databases

SIRE514 Molecular Evolution

Course Description

under construction

Topics

  1. DNA, Genes, and Genomes
  2. Replication, Transcription, and Translation
  3. Mutations and Codon Evolution
  4. Biodatabases
  5. Pairwise Sequence Alignment
  6. Basic Local Alignment Search Tools (BLAST)
  7. Multiple Sequence Alignment
  8. Evidence of Evolution
  9. Species and Speciation
  10. Measurement of Variation and Genetic Diversity
  11. Mechanism of Evolution
  12. Natural Selection
  13. Drift
  14. Changes in Amino Acid Sequences
  15. Changes in Nucleotide Sequences
  16. DNA Substitution
  17. Molecular Phylogenetics
  18. Distance Methods
  19. Maximum Parsimony Methods
  20. Maximum Likelihood Methods
  21. Bayesian Inferrence Phylogeny
  22. Concepts of Phylogenomics
  23. Evolution in Health and Diseases

Copyright © 2019 Ajawatanawong's Lab - All Rights Reserved.

  • Home
  • Publications
  • Teach-n-Talk
  • Blogs
  • Photos
  • Contact

ขับเคลื่อนโดย