SQL

db관리, user관리

SQL 테이블 관리

데이터 조회, 수정

데이터 정렬 order by

비교 연산자

논리연산자 AND OR NOT BETWEEN IN LIKE

UNION, UNION ALL

JOIN INNER, LEFT, RIGHT, OUTER, SELF JOIN

concat alias(as) distinct limit

AWS RDS MySQL 외부접속

SQL File SQL File 생성 & 실행

database backup & restore

PRIMARY KEY, FOREIGN KEY , CONSTRAINT

Python 으로 MySQL 접속 후 사용

python 에서 sql쿼리 실행 - execute, fetch all

read csv, insert, select

COUNT, SUM, AVG, MIN, MAX, FIRST, LAST, GROUP BY, HAVING

UCASE, LCASE, MID, LENGTH, ROUND, NOW, FORMAT

Subquery Scalar Subquery, Inline View, Nested Subquery(Single Row, Multiple Row, Multiple Column)

Source TABLE -> CREATE (SELECT FROM )

WINDOW_FUNCTION ( ) OVER ( PARTITION BY column ORDER BY column) LEAD, LAG

CASE WHEN

DDL(Definition) DML(Manipuation) DCL(Control) DQL(Query) TCL (Transaction Control Language) 쿼리 실행 순서 from> join on> group by> having>select> order by