adam's notes

  • Building Queries to Model Data
  • Write Queries on Data
  • Transpose and Append Data
  • Update, Insert, and Delete Data
Home

❯

Building Queries to Model Data

Building Queries to Model Data


Goals

  • Write queries on tables.
  • Transpose and append data.
  • Update, insert, and delete data.

Write Queries on Data

  • Data Manipulation Language (DML)
  • Querying Data
    • SELECT
    • joins
  • Types of Joins
  • The Impact of Each Join
  • WHERE Clause
    • LIKE Operator
  • Grouping and Aggregating Data
    • WHERE
    • GROUP BY

Transpose and Append Data

  • Exploding Data
  • Appending Data
  • Merging Data

Update, Insert, and Delete Data

  • Updating Data
  • Inserting Data
  • Deleting Data

Graph View

Backlinks

  • D492 - Data Analytics - Applications

Created with Quartz v4.5.2 © 2026

  • CC BY-NC-SA
  • adamfurman.me