The UCLA ATLAS Precision Health Biobank integrates genetic information and de-identified medical records to enable precision health research. This introductory workshop will cover the basics of extracting health-related phenotypes from the electronic health record. Topics covered include introductory SQL, medical record concepts and organization, and best practices. No prior experience with SQL nor health records are assumed.
W33: Accessing Clinical Databases
December 3 @ 1:30 pm - December 6 @ 4:30 pm
Details
- Start:
- December 3 @ 1:30 pm
- End:
- December 6 @ 4:30 pm
- Event Categories:
- Workshops, Interactive Workshop
- Event Tags:
- Phenotypes, Records, SQL, OHIA, Health, Biobank, ATLAS, DDR
- Website:
- https://qcb.ucla.edu/collaboratory/workshops/w33-ohia-ddr-computing/
Organizer
- QCB Collaboratory
- Phone
- 310-825-2917
- collaboratory@ucla.edu
- View Organizer Website
Venue
- 529 Boyer Hall
-
611 Charles E Young Dr E,
Los Angeles, CA 90095 United States + Google Map - Phone
- 3108252917
Details
- Start:
- December 3 @ 1:30 pm
- End:
- December 6 @ 4:30 pm
- Event Categories:
- Workshops, Interactive Workshop
- Event Tags:
- Phenotypes, Records, SQL, OHIA, Health, Biobank, ATLAS, DDR
- Website:
- https://qcb.ucla.edu/collaboratory/workshops/w33-ohia-ddr-computing/
Organizer
- QCB Collaboratory
- Phone
- 310-825-2917
- collaboratory@ucla.edu
- View Organizer Website
Venue
- 529 Boyer Hall
-
611 Charles E Young Dr E,
Los Angeles, CA 90095 United States + Google Map - Phone
- 3108252917
Event Navigation
Interesting links
Here are some interesting links for you! Enjoy your stay :)Pages
- #5439 (no title)
- 2019 Retreat Gallery
- 2020 Retreat Gallery
- 2021 Retreat Gallery
- 2022 Retreat Gallery
- 2023 Retreat Gallery
- 2024 BIG Summer Schedule of Collaboratory Workshops
- Alumni
- ATest
- B.I.G. SUMMER
- BIG Summer Letter of Recommendation Submission Form
- Biomathematics
- Career Panel and Networking Event
- Committees
- Computational Biosciences Undergraduate Research Portal
- Diversity, Equity, & Inclusion
- ERGR Bioinformatics Toolbox
- Faculty
- Frontpage
- Frontpage
- Frontpage
- GATK Workshop Slide Sets: March 2016
- Graduate Program Navigator
- Graduate Programs
- Hoffman2 Cluster User Guide
- Journal Clubs
- News Archive
- Overview
- Professor Takashi Suzuki
- Prominent Publications by QCBio-Affiliated Faculty
- Publications
- QBio-EDGE
- Software Tools
- The Collaboratory
- Trainees
- Trainees
- Undergraduate Programs
- Videos
- W24: MERFISH/seqFISH
- Applied Bioinfo Course
- B.I.G. Summer 2023
- B.I.G. Summer 2024
- B.I.G. Summer Application
- Bioinformatics PhD
- Bruins-In-Genomics (B.I.G.) Summer Program
- Core Faculty
- Home
- Research Prep Course
- The Collaboratory – People
- About
- Application for Conference Travel Funds
- B.I.G. Summer 2021
- B.I.G. Summer 2022
- Bioinformatics BSc
- Major Projects
- Partners
- Seminar Series
- Workshops
- Advisory Board
- Archived Workshops
- B.I.G. Summer 2020
- Comp Sys Bio BSc
- Events
- Research Meetings
- Schedule of Workshops
- Support/Facilities
- W1a: Unix command line I
- B.I.G. Summer 2019
- Opportunities
- Python Hackathon
- W1b: Unix Command Line II
- W2: Using NGS Analysis Tools
- Workshops
- B.I.G. Summer 2018
- Research
- Services
- Symposium
- W3: Intro to R and Data Visualization
- Annual QCBio Retreats
- B.I.G. Summer 2017
- Careers in Biotechnology for Bachelor’s and Master’s students
- Events Archive
- W4: Galaxy for NGS Data Analysis
- B.I.G. Summer 2016
- Education
- Fellow Award Opportunities
- UCLA Galaxy
- W5a: RNA-seq I Analysis – Measuring gene expressions from RNA-seq data
- B.I.G. Summer 2015
- Recent Publications
- W5b: RNA-Seq II Analysis – Differential gene expression and pathway analysis
- Resources
- FAQ
- RNA-seq III Analysis – De novo transcriptome assembly using Trinity
- W6: BS-Seq DNA Methylation Analysis with Hoffman2 and R
- W7: ChIP-seq Analysis
- W8: Variant Calling with GATK
- W9: Intro to Python
- Intro to Hi-C
- W10: Mathematical Modeling of Cell Signaling
- W11: Metagenomics Analysis with Python and R
- W12: Intro to MATLAB
- Intro to Phylogenetics
- W13: Genetic Analysis (VCF-Plink)
- W14: Intro to Modern Statistics with R
- W15: Bacterial Genomics
- W16: Library Prep for NGS
- W17: Machine Learning with Python
- W18: Advanced Python
- W19: Statistical Rigor in Genomics Data Analysis
- W20: Single-Cell RNA-Seq Analysis with R
- PATRIC Bioinformatics Resource Center Workshop
- W21: Image Processing for Microscopy
- W22: Intro to Cytoscape
- UCSC Genome Browser
- W23: Advanced Cytoscape
- W24: Cancer Genomics
- W25: UCSC Genome Browser
- W26: Protein Structure with AlphaFold
- BS-Sequencing
- RAD-Seq Analysis
- W27: Systems biology of metabolism – workflows and resources for multi-omics data integration
- W28: Advanced Data Visualization w/ ggplot2
- W29: Demultiplexing QC/Good Practices — Hidden Surprises and Illumina Sequencing
- W30: Statistical Methods for Enhancing the Rigor in Single-cell RNA-seq Data Analysis
- W31: Spatial Transcriptomics
- W32: GitHub/Docker
- W33: Analysis of Electronic Health Records
- W34: Automated Machine Learning
- W35: Advanced Statistics: Regression Models and Statistical Rigor
- W36: Multi-Omics Integration and Network/Pathway Analysis using Mergeomics
- W37: Applications of Large Language Models
Categories
Archive
- April 2024
- March 2024
- February 2024
- October 2023
- June 2023
- May 2023
- April 2023
- March 2023
- February 2023
- January 2023
- November 2022
- October 2022
- June 2022
- May 2022
- March 2022
- October 2021
- September 2021
- June 2021
- May 2021
- April 2021
- March 2021
- February 2021
- January 2021
- November 2020
- October 2020
- September 2020
- August 2020
- March 2020
- November 2019
- July 2019
- April 2019
- December 2018
- November 2018
- August 2018
- June 2018
- April 2018
- February 2018
- December 2017
- November 2017
- October 2017
- August 2017
- June 2017
- May 2017
- April 2017
- March 2017
- February 2017
- December 2016
- November 2016
- October 2016
- September 2016
- August 2016
- July 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- December 2015
- November 2015
- October 2015
- July 2015
- May 2015
- April 2015
- December 2014
- June 2014
- April 2014
- February 2013
- December 2012
- April 2012
- June 2011
- May 2011
- March 2011
- October 2010