Post

Week 7 - Data Loading in SQL

GROUP BY, HAVING, Subquery, JOIN, CREATE TABLE, INSERT INTO

Posted Updated
By Kyunghee Lee
1 min read
Week 7 - Data Loading in SQL

We’ll continue on Data Manipulation in SQL, and learn how to aggregate and combine data from multiple tables. We’ll also learn how to create and populate tables.

Goals

  1. Aggregate data using GROUP BY and HAVING
  2. Combine data from multiple tables using Subquery and JOIN
  3. Create a new table using CREATE TABLE
  4. Insert data into a table using INSERT INTO

Slides

  • Advanced SQL:
  • DDL & DML:

Labs

Resources

Lecture
sql
This post is licensed under CC BY 4.0 by the author.