Skip to content

DisplayAtWorkshop.md

Latest commit

 

History

History
29 lines (24 loc) · 1.29 KB

DisplayAtWorkshop.md

File metadata and controls

29 lines (24 loc) · 1.29 KB
Raw

Welcome to the Writing SQL Workshop!

Beginner Workshop: Basic SQL Statements

By the end of this section, you will be able to:

  1. Describe the structure of a SQL query
  2. Query a table to retrieve existing data
  3. Filter data in a query using basic operators, including:
    • SELECT, FROM, WHERE, AND, BETWEEN, NOT BETWEEN, >, <, =, !=, and DISTINCT
  4. Explain how to read an entity relationship diagram (ERD)

Prerequisites

  • No SQL experience needed! Welcome!

Intermediate Workshop: Aliases, Joins, Functions and Operators

By the end of this section, you will be able to:

  1. Rename a column and table using an alias
  2. Join tables to retrieve data across a database
  3. Display data using the arithmetic operators +, -, * / and %
  4. Display data using the aggregate functions COUNT, MIN, MAX and AVG
  5. Filter aggregated data using HAVING and GROUP BY
  6. Change the display of data using NULL and CASE

Prerequisites

You can complete the 3 assessment items for the Beginning Workshop.

Advanced Workshop: Choose Your Own Adventure

You can choose to work through one of the options, or try all three. Have fun.

Prerequisites

You can complete the 4 assessment items for the Intermediate Module