Venue

Allan Rosenfield Building
722 W. 168 St., New York, NY 10032
Category

TICKETS/REGISTER LINK

Read More

Date

Jun 26 - 28 2024
Expired!

Time

10:00 am - 5:00 pm

Formats (virtual, in person, hybrid)

Hybrid

SQL Boot Camp

June 26-28, 2024 | Hybrid training

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:

  1. Basic experience working with data (e.g., data cleaning or analysis) is beneficial, but not required.
  2. 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

Capacity is limited. Paid registration is required to attend.

Event Contact Information:
SQL Boot Camp
ColumbiaSHARP.SQL@gmail.com