Cornell University

Scientific Computing Training Series - Using Relational Databases for Research

Tuesday, June 20, 2023 at 9:00am to 10:00am

Virtual Event

Cornell University’s Center for Advanced Computing together with Weill Cornell Medicine's Scientific Computing Unit, ITS, and Clinical and Translational Science Center are pleased to offer the 2023 Scientific Computing Training Series. 

An introduction to the use of relational (SQL) databases, with a brief overview of database structure then covering SQL queries, some information on best practices, and development tools. We will mostly deal with ANSI SQL which will run on most Relational Database Management Systems (RDBMs), noting some important inter-RDBMS differences. Covered will be SQL queries for data retrieval, insertion and deletion, correlated subqueries and how to construct a complicated query. We will also discuss the interface between the database and the code, including the use of Object-Relational Model tools and stored procedures. Level: Introductory/Intermediate. Prereqs: This session does not require having knowledge of how to write SQL queries for data extraction, insertion, and deletion, but is a convenient companion to such a workshop or pre-existing knowledge.

Dial-In Information

Register for Zoom Meeting and instructions will be sent to you: https://cornell.zoom.us/meeting/register/tJwrf-msrjspHN1tqB11pZ0Z6X7zXJpyt5Am

 

Subscribe
Google Calendar iCal Outlook
Event Type

Seminar

Departments

CAC: Cornell Center for Advanced Computing

University Themes

Research

Website

https://its.weill.cornell.edu/scienti...

Cost

Free

Hashtag

#Training

Contact E-Mail

paul.redfern@cornell.edu

Contact Name

Paul Redfern

Contact Phone

607-227-1865

Speaker

Adam Brazier

Speaker Affiliation

Cornell University Center for Advanced Computing (CAC)

Speaker Web Site

https://www.cac.cornell.edu/brazier/

Dept. Web Site

https://www.cac.cornell.edu/

Open To

Training sessions are open to all workforce members and students of Cornell University, WCM, WCM-Q, and Cornell Tech. They are free of charge.

Recent Activity