Events

The SQL Boot Camp is a three-day intensive boot camp of seminars and hands-on programming sessions to provide an overview on the design of relational databases and querying data from existing data sources using the SQL programming language.  This three-day intensive boot camp covers the fundamentals of relational databases, including database design, and writing queries using the SQL language. The boot camp will integrate seminar lectures with extensive hands-on sessions using the commonly available database software program MySQL. The first half of the boot camp will cover building databases with proper design to maintain data integrity, while the second half will focus on retrieval and manipulation using SQL (Structured Query Language). During this workshop, participants will: Learn the pitfalls of using Excel for data storage Build small relational databases in MySQL Formulate SQL queries to 1) create and modify database objects, and 2) populate and retrieve data from database tables Optimize SQL queries for best performance Audience and Requirements Investigators from any institution and any career stage are welcome to attend. This workshop will particularly benefit those who will be actively involved in research data management. There are two requirements to attend this training: Basic experience working with data (e.g., data cleaning or analysis) is beneficial, but not required. Each participant must have a laptop with Zoom installed. To get the most out of breakout groups, we also recommend a working microphone and webcam. Participants may also wish to share their screen with instructors during one-on-one questions. Instructors Debra D'Angelo, Assistant Director, Biostatistics Services, Weill Cornell Medicine. Evan Sholle, Assistant Director, Research Informatics Data Science Services, Weill Cornell Medicine. Monica Gierada, Director, Healthcare Data Science, Aetion. Additional Information Subscribe for updates on SQL Boot Camp details or registration deadlines. Contact the SQL team. Capacity is limited. Paid registration is required to attend.

Register Here (Registration is required. Please note this program is in-person only and will not be recorded.) Sponsored by: the CUIMC Virigina Kneeland Frantz Society for Women Faculty and the CUIMC Women in Science Planning Committee. This program is open to all CUIMC faculty. Please join us for an energizing and interactive speed-mentoring event designed to connect faculty across ranks, disciplines, and career stages. This forum will facilitate a unique opportunity to build peer-networks, share insights and strategies, and engage in meaningful discussions with other faculty. This session will facilitate a collaborative space for developing mentorship relationships, building community, and developing actionable strategies to support career advancement. Table topics include: Strategies for building your mentoring network Balancing it all - wellness and work-life balance          Strategies for enhancing your leadership profile          Strategies for building a national reputation Plus: Topics submitted by registrants  

TBD

The SQL Boot Camp is a three-day intensive boot camp of seminars and hands-on programming sessions to provide an overview on the design of relational databases and querying data from existing data sources using the SQL programming language.  This three-day intensive boot camp covers the fundamentals of relational databases, including database design, and writing queries using the SQL language. The boot camp will integrate seminar lectures with extensive hands-on sessions using the commonly available database software program MySQL. The first half of the boot camp will cover building databases with proper design to maintain data integrity, while the second half will focus on retrieval and manipulation using SQL (Structured Query Language). During this workshop, participants will: Learn the pitfalls of using Excel for data storage Build small relational databases in MySQL Formulate SQL queries to 1) create and modify database objects, and 2) populate and retrieve data from database tables Optimize SQL queries for best performance Audience and Requirements Investigators from any institution and any career stage are welcome to attend. This workshop will particularly benefit those who will be actively involved in research data management. There are two requirements to attend this training: Basic experience working with data (e.g., data cleaning or analysis) is beneficial, but not required. Each participant must have a laptop with Zoom installed. To get the most out of breakout groups, we also recommend a working microphone and webcam. Participants may also wish to share their screen with instructors during one-on-one questions. Instructors Debra D'Angelo, Assistant Director, Biostatistics Services, Weill Cornell Medicine. Evan Sholle, Assistant Director, Research Informatics Data Science Services, Weill Cornell Medicine. Monica Gierada, Director, Healthcare Data Science, Aetion. Additional Information Subscribe for updates on SQL Boot Camp details or registration deadlines. Contact the SQL team. Capacity is limited. Paid registration is required to attend.