SQL Workshops: SQL for Data Management

SQL for Data Management is a project-based workshop focused on transforming structured data with SQL via SQLite in Google Colab. Students will develop a complete project for professional portfolio using a real-world scenario and dataset. Students will improve technical skillset in SELECT, ORDER BY, WHERE, Aggregate Functions, GROUP BY, Joins, and Subqueries as well as conceptional understanding of querying data, sorting and filtering queries, aggregating data, combining tables, and nesting queries.

Benefits

• Complete project for professional portfolio

• Technical skillset in SELECT, ORDER BY, WHERE, Aggregate Functions, GROUP BY, Joins, and Subqueries

• Conceptual understanding of querying data, sorting and filtering queries, aggregating data, combining tables, and nesting queries

• Interactive group training

• Free access to AdventureWorks Sales Project

Topics

1. Querying data using SELECT, DISTINCT, and CAST

2. Sorting and filtering queries using ORDER BY and WHERE

3. Aggregating data using COUNT, SUM, AVG, MAX/MIN, and GROUP BY

4. Combining tables using INNER JOIN, LEFT/RIGHT JOIN, and FULL JOIN

5. Nesting queries using Subqueries

Deliverables

• Live 60-min screensharing via Google Meet with maximum 3 student

Requirements

• Google Colab

• Private information secured during screensharing