SQL Resources

Introduction

In this module we will introduce you to Structured Query Language (SQL) to help you organise and query databases in your role.

Learning Objectives

• Understand basic logic commands in SQL
• Demonstrate how to perform multi-step aggregations or filtering within one query
• Understand how to apply SQL functions

Files to Download

• PostGres Details
• SQL Operators
• Joins
• Joins Practice
• MissionImposSQL
• Presentation Strategies
• Choosing the Right Visualisation
• Leveraging Colour
• DIY Database

SQL Server

Slides

Solutions

• Applying SQL Functions
• Data Cleaning in SQL
• Filtering and Aggregation
• Joins and Unions
• Multiple Joins
• Mission ImposSQL
• Fundamental Queries
• Subqueries Practice
• Subqueries Demos
• Business Case Exercise

Session Attendance Logs

Session 1

Session 2

Session 3

Session 4

Additional Resources

• Chinook Database
• Practice Questions
• Solutions