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.