In this one-day introductory course, participants will learn the basic SQL syntax for data extraction, filtering and insertion.
About this Event

The Structured Query Language (SQL) defines a standard for communicating with a relational database. In this one-day introductory course, participants will learn the basic SQL syntax for data extraction, filtering and insertion. We will start by querying a local database before connecting to a remote database held on an AWS server. Here, we will stress important considerations when working with shared databases in the cloud.

This is an online course and will take place, from 13:30 - 17:00 (UK time), on the 12th & 13th of February. The closing date for enrollment is February 7th.

Learning outcomes

Session 1:

By the end of session 1 participants will…

understand the concepts of relational database management.
be introduced to the PostgreSQL dialect.
be comfortable working in the VS Code integrated environment.
understand how to form a connection and view the database schema.
have learned basic SQL syntax for data extraction, filtering and organising, and data creation.

Session 2:

By the end of session 2 participants will…

be familiar with database services on AWS.
understand the basic considerations for cloud storage and sharing.
have worked with both local and remote connections.
have learned how to join tables by matching variables.

This course does not include:

S3 and data warehouse services on AWS.
Connecting to databases through programming languages like R and Python, see our Intro to SQL with R and Intro to SQL with Python courses for this.

Prior knowledge

There are no pre-requisites for this course.

Attendee feedback