Non-SOT Event: SQL Boot Camp: Building and Querying Databases

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.

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

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.

Prerequisites and Requirements: 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.

Capacity is limited. Paid registration is required to attend.

Additional Information:
- See website for more details: https://www.publichealth.columbia.edu/academics/non-degree-special-programs/professional-non-degree-programs/skills-health-research-professionals-sharp-training/trainings/sql
- Email us with any questions: ColumbiaSHARP.SQL@gmail.com