Free

Databases and SQL at USYD Online

Event Information

Share this event

Date and Time

Location

Location

USYD Online

Via Zoom

The University of Sydney

Australia

View Map

Event description

Description

The course will start at 9:30 am with optional technical support on setting up Zoom or SQL database manager starting at 9 am.

Please note that due to the limited number of available tickets, priority is given to USYD researchers and staff. Registrants who are not from USYD may be removed. Thanks for your understanding. Please keep an eye on our website for the upcoming schedule on your home institution.

Please register ASAP to secure your spots!

Why do this course?

A relational database is an extremely efficient, fast and widespread means of storing structured data, and Structured Query Language (SQL) is the standard means for reading from and writing to databases. Databases use multiple tables, linked by well-defined relationships, to store large amounts of data without needless repetition while maintaining the integrity of your data.

Moving from spreadsheets and text documents to a structured relational database can be a steep learning curve, but one that will reward you many times over in speed, efficiency and power.

Developed using the researcher-focused training modules from the highly regarded Software Carpentry Foundation (software-carpentry.org).

You’ll learn how to:

  • Understand and compose a query using SQL

  • Use the SQL syntax to select, sort and filter data

  • Calculate new values from existing data

  • Aggregate data into sums, averages, and other operations

  • Combine data from multiple tables

  • Design and build your own relational databases

The Intersect approach to training

At Intersect, we work closely with our member universities to develop and deliver training that targets the day-to-day software and technology problems that researchers face. We deliver hands-on courses in a relaxed setting with knowledgeable, helpful trainers who are themselves researchers and who know how researchers work.

For more information about this course and others, see our course catalogue, or visit Learn.intersect.org.au


Date and Time

Location

USYD Online

Via Zoom

The University of Sydney

Australia

View Map

Save This Event

Event Saved