# PDDS TA Course Materials

## Tech Stack Overview


<!-- Tech Stack Overview

- **Framework: Dash**
- **Language: Python**
- **Database: SQLite**
- **Library: Plotly, Pandas** -->

<!--

graph TD
    A[User] --|HTTP Requests| B[Dash Application]
    B --|Python Code Execution| C[Python Runtime]
    C --|Data Visualization| D[Plotly Library]
    C --|SQL Queries| F[SQLite Engine]
    F --|Data Storage/Retrieval| E[SQLite Database]
    D --|Renders Visuals| B
    E --|Query Results| F
    F --|Processed Data| C
    B --|HTML/JS/CSS| A

-->

<!-- ## Calendar -->

<!--```mermaid

gantt
title TA Courses
dateFormat YYYY-MM-DD
axisFormat %m-%d

section Error Messages
Introduction to Python :a1, 2025-09-02, 14d
Intermediate Python :a2, after a1, 21d

section Dashboard Design
Dashboard Types & Examples :a3, 2025-10-07, 14d

section Python, Pandas, & SQL
Python vs Pandas vs SQL :a4, 2025-10-21, 14d

section Dashboard Demo
Dashboard with Julia, Dash, Plotly :a5, 2025-11-04, 56d

-->

---

# 1. Python Runtime: Python Error Messages Understanding



Why do we need to understand the error message? To save your computer 


![image](https://hackmd.io/_uploads/SyiCZMuHel.png)

**Datacamp related**
| Topics | Page Link |
| --------  | -------- |
| Python Environment Setup | https://hackmd.io/@PoYa-Sharon-Lin/BJHURj3Uee |
| Introduction to Python | https://hackmd.io/@PoYa-Sharon-Lin/ryqJkdfSxe  | 
| Intermediate Python  | https://hackmd.io/@PoYa-Sharon-Lin/HJyk9lYreg | 

----

**Python assessment related**
| Topics | Page Link |
| --------  | -------- |
|[ Assignment ] - Python Assessment: list & pandas| https://hackmd.io/@PoYa-Sharon-Lin/BykYn6Ywll|


---


# 2. Dashboard Design



What exactly is dashboard? 
What's the difference between operational, tatical, and strategic dashboard? 


| Topics | Page Link | 
| --------  | -------- |
| Dashboard Design Concepts| https://hackmd.io/@PoYa-Sharon-Lin/B1eMjxzIxl| |



Reference: https://www.tableau.com/dashboard/what-is-dashboard

---


# 3. SQLite Engine: SQL Queries and SQL engine 
Why do we need SQL? Can't we use Python to do CRUD?

What is an SQLite engine? 

| Topics | Page Link | 
| --------  | -------- | 
| SQL engine | https://hackmd.io/@PoYa-Sharon-Lin/rk9JuZUIll |
<!-- | SQL Queries & Non SQL Queries | https://hackmd.io/@PoYa-Sharon-Lin/S1ipyicBgg | -->


---

# 4. SQLite Database: Database Demo

| Topics | Page Link | 
| --------  | -------- |
| Database Demo | https://hackmd.io/@PoYa-Sharon-Lin/Hy4d0VwLll | 

---

# 5. Dash: Dash Demo


| Topics | Page Link | 
| --------  | -------- |
| Dash Concepts| https://hackmd.io/@PoYa-Sharon-Lin/rJvCQzoUgl | 
| Dash Demo (🏗️Underconstruction🏗️) | https://github.com/PoYaSharonLin/PDDS/tree/dash-demo?tab=readme-ov-file |