Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Science - Coggle Diagram
Data Science
SQL
基本概念
Database
Relational Database
Tables
Rows
Columns
Relational Database Management System (RDBMS)
SQL
MySQL
PostgreSQL
Oracle DB
SQL Server
SQLite
Manipulation
CREATE
資料種類
INTEGER
TEXT
DATE
REAL
資料限制
PRIMARY KEY
UNIQUE
NOT NULL
DEFAULT
INSERT
SELECT
ALTER
UPDATE
DELETE
Queries
SELECT FROM
AS
WHERE
DISTINCT
LIKE
_
%
IS NULL / IS NOT NULL
BETWEEN AND
AND / OR
ORDER BY
ASC
DESC
LIMIT
CASE
Aggregate Functions
COUNT()
SUM()
MAX() / MIN()
AVG()
ROUND(column, n)
GROUP BY
HAVING
Multiple Tables
JOIN ON
LEFT JOIN ON
Primary Key vs Foreign Key
CROSS JOIN
UNION
WITH
Go Off-Platform
Command Line
ls
cd '路徑'
echo '文字' >> '檔名.txt'
cat '檔名.txt'
Python
Python
Syntax
Functions
Control Flow
Lists
Loops
List Comprehension
Lambda Functions
Jupyter Notebooks
Pandas
Matplotlib
Seaborn
Numpy
SciPy
Machine Learning