Instructor: Adam Brazier
Description: 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.
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.
Register for Zoom Meeting https://cornell.zoom.us/meeting/register/tJwrf-msrjspHN1tqB11pZ0Z6X7zXJpyt5Am
Tuesday, June 20 at 9:00am to 10:00amVirtual Event