From 7aa8eb1a505d6f206286245fe519b11d96d43903 Mon Sep 17 00:00:00 2001
From: TheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com>
Date: Fri, 27 Dec 2024 21:42:38 +0900
Subject: modified Dashboard.md, modified Machine Learning.md", modified
 MySQL.md

---
 SI/Dashboard.md                                    | 27 ++++++++++-----------
 .../Machine Learning/Machine Learning.md           | 14 +++++++----
 SI/Resource/Data Science/SQL/MySQL.md              | 28 ++++++++++++++++++++++
 3 files changed, 49 insertions(+), 20 deletions(-)

diff --git a/SI/Dashboard.md b/SI/Dashboard.md
index 43dabd0..ea9865e 100644
--- a/SI/Dashboard.md
+++ b/SI/Dashboard.md
@@ -12,33 +12,30 @@ cssclasses:
 
 # Dashboard
 
-## Contents
-
-### Table of contents
-
-<!-- toc -->
-
 - ### 🏠 [House]()
+
   - 💰 Budget
   - [[Q1 2024]]
-  - ## 🛒 Grocery
-  - l💳 Transaction
-  - hello
-- ### 👤 Personal
-
-  - ## 🏡[Archive](file:////Users/si/Documents/SI/Archive)
-  - ## ✍️ [Area](file:////Users/si/Documents/SI/Area)
-  - ## 📁 [Projects](file:////Users/si/Documents/SI/Project)
-  - ## 📚 [Resource](file:////Users/si/Documents/SI/Resource)
+  - #### 🛒 Grocery
+  - 💳 Transaction
+
+- ### 👤 [Personal]()
+
+  - #### 🏡[Archive](file:////Users/si/Documents/SI/Archive)
+  - #### ✍️ [Area](file:////Users/si/Documents/SI/Area)
+  - #### 📁 [Projects](file:////Users/si/Documents/SI/Project)
+  - #### 📚 [Resource](file:////Users/si/Documents/SI/Resource)
   - ✅ [To-do](file:////Users/si/Documents/SI/To-do)
     `$=dv.list(dv.pages('"To-do"').sort(f=>f.file.name,"desc").limit(4).file.link)`
 
 - ### 🏢 [School]()
+
   - 📔 [Class]()
     `$=dv.list(dv.pages('"Resource"').sort(f=>f.file.mtime.ts,"desc").limit(4).file.link)`
   - 💼 [Project]()
   - ✏️ [Assignment]()
     `$=dv.list(dv.pages('#assignment').sort(f=>f.file.mtime.ts,"desc").file.link)`
+
 - ### 🚧 Life Progress
 
   ```dataviewjs
diff --git a/SI/Resource/Data Science/Machine Learning/Machine Learning.md b/SI/Resource/Data Science/Machine Learning/Machine Learning.md
index 7d39736..6dbb5e8 100644
--- a/SI/Resource/Data Science/Machine Learning/Machine Learning.md	
+++ b/SI/Resource/Data Science/Machine Learning/Machine Learning.md	
@@ -10,19 +10,21 @@ tags:
 
 # Machine Learning
 
+## Definition
+
 Machine Learning (ML) is a subset of artificial intelligence (AI) that focuses on the development of systems and algorithms that can learn from and make decisions or predictions based on data. The core idea is to enable a machine to make intelligent decisions or predictions without being explicitly programmed to perform the task.
 
-## Machine
+### Machine
 
 Machine is a model or a function derived from data given by human
 
-## Learning
+### Learning
 
 Learning is to find the best model represented data, meaning optimization of parameter
 
 - Optimization of parameter: By statistical method or [[Gradient descent | gradient descent]]
 
-## Goal
+### Goal
 
 [[Optimization]]: Find optimal parameters
 
@@ -30,7 +32,9 @@ Learning is to find the best model represented data, meaning optimization of par
   - A model with the smallest difference between predictions $\hat{y}$ and actual values $y$
   - A model parameter makes the smallest loss
 
-## Supervised Learning
+## Types of learning
+
+### Supervised Learning
 
 1. [[Regression]]
    - [[Linear Regression]] and [[Nonlinear Regression]]
@@ -46,7 +50,7 @@ Learning is to find the best model represented data, meaning optimization of par
      - [[Bagging]]
      - [[Boosting]]
 
-## Unsupervised Learning
+### Unsupervised Learning
 
 1. [[Preprocessing]]
    - [[Principal Component Analysis]] ([[Principal Component Analysis |PCA]])
diff --git a/SI/Resource/Data Science/SQL/MySQL.md b/SI/Resource/Data Science/SQL/MySQL.md
index 992ea5d..abec6ec 100644
--- a/SI/Resource/Data Science/SQL/MySQL.md	
+++ b/SI/Resource/Data Science/SQL/MySQL.md	
@@ -19,6 +19,34 @@ tags:
 
 <!-- toc -->
 
+- [Variables](#variables)
+- [Table](#table)
+- [DDL (Data Definition Language) - CREATE, ALTER, DROP, TRUNCATE](#ddl-data-definition-language---create-alter-drop-truncate)
+- [DML (Data Manipulation Language): UPDATE commands (UPDATE, INSERT, DELETE) & Query command (SELECT)](#dml-data-manipulation-language-update-commands-update-insert-delete--query-command-select)
+  - [UPDATE commands](#update-commands)
+  - [Query command](#query-command)
+    - [FROM clause](#from-clause)
+      - [ORDER BY](#order-by)
+      - [LIMIT](#limit)
+      - [WHERE clause: Condition / Predicates](#where-clause-condition--predicates)
+        - [Filtering](#filtering)
+    - [Functions](#functions)
+      - [Date](#date)
+        - [Date Format](#date-format)
+    - [GROUP BY](#group-by)
+    - [Division & Analysis](#division--analysis)
+      - [Division](#division)
+      - [Before/After](#beforeafter)
+      - [Border](#border)
+      - [Merge](#merge)
+    - [Sub Query / Temporary Table](#sub-query--temporary-table)
+      - [Multi Columns](#multi-columns)
+      - [Uni Column & Uni Data](#uni-column--uni-data)
+      - [VIEW / WITH](#view--with)
+    - [Custom Function](#custom-function)
+
+<!-- tocstop -->
+
 ## Variables
 
 ```sql
-- 
cgit v1.2.3