2025-Spring-DataAnalyticsAI-WS-SQLFundamentals

Repos for live workshop: SQL Fundamentals: Getting Data from Databases
Location: ReDI-School Aarhus
Date: 2025-05-07 (May 7th, 2025)

Prerequisites

✅ What You’ll Need

• Visual Studio Code - https://code.visualstudio.com/download
• Python (3.10 or newer) - https://www.python.org/downloads
• Git - https://git-scm.com/downloads
• A GitHub account - https://github.com

🧩 Extensions to Install in VS Code

• Python by Microsoft
• SQL Server (mssql) by Microsoft

Great! Here's a well-structured agenda for your SQL Fundamentals workshop (17:30–20:00), including:

• Intro to databases and roles
• Practical SQL exercises
• GitHub integration

---

🗓 SQL Fundamentals Workshop Agenda

17:30–17:45 | Introduction & Setup

---

17:45–18:15 | SQL Basics

• Concepts:

  • Tables, columns, rows
  • SELECT, WHERE, DISTINCT, ORDER BY, LIMIT/TOP

---

18:15–18:45 | Relationships and JOINs

• Concepts:

  • Foreign keys and table relationships
  • INNER JOIN vs LEFT JOIN

---

18:45–19:00 | Short Break + Q&A

---

19:00–19:30 | Aggregations and Grouping

• Concepts:

  • COUNT, SUM, AVG, GROUP BY, HAVING

---

19:30–19:50 | Challenge: Mini Case Study

---

19:50–20:00 | Wrap-up & What’s Next

• Review: SELECT, WHERE, JOINs, Aggregates

• Next steps:

  • Views, Parameters, Subqueries, CASE WHEN, Window functions (future topics)
  • Practice site: sqlpad.io

• Push all branches to GitHub

---

Slide Deck

Git Cheatsheet