Interested in R package validation? Learn about Litmus
items

Introduction to SQL

Course Level: Foundation (3 hours)

The Structured Query Language (SQL) defines a standard for communicating with a relational database. In this half-day introductory course, participants will learn the basic SQL syntax for data extraction, filtering and insertion. We will then discuss some considerations for working with databases on the cloud, and finish by learning basic techniques for joining tables.

The course can be taken either independently or as a precursor to our Intro to SQL with R and Intro to SQL with Python courses.

Download course details

Book: Introduction to SQL

Start Date:
Price:
Venue Details:
Time:
Duration:
Add course to cart Add all courses in this series to cart Ask for more details about this course

No Events Currently Scheduled

Sorry, there are no upcoming events for this course, but please get in touch if you would like to be kept informed when events are scheduled in the future.

Request on-site training details Request online training details View all training courses

Course Details

Outline

  • Introduction to SQL: An introduction to relational databases that implement the SQL standard and establishing database connections.
  • Data Extraction: Using SELECT statements to extract filtered data and organising the output.
  • Database Modification: Creating tables and inserting data.
  • Cloud Deployment: An introduction to database services on AWS and setting up remote, shared access.
  • Multiple Tables: Dealing with and joining data that resides in multiple tables that share common variables.

Learning outcomes

By the end of the session 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:
    • extracting data with SELECT statements
    • filtering and organising data
    • creating tables and inserting data
  • be familiar with database services on AWS.
  • understand the basic considerations for cloud storage and sharing.
  • have learned how to join tables by matching variables.

This course does not include:

Prior knowledge

There are no pre-requisites for this course.

Attendee Feedback

  • “Environment was easy to access and set up, course materials were easy to follow and the instructor was knowledgeable & responsive to questions.”