ssac-web-fullstack SSAC Web Full-Stack 2κΈ° (μμ΅&볡μ΅) Online (Youtube) π΄ββοΈ [Linux & Docker] Linux 01 - 리λ μ€ κΈ°μ΄ Linux 02 - vi μλν° Linux 03 - python, telnet, putty, git μ€μΉ Linux 04 - λ컀μμ 리λ μ€ μ»¨ν μ΄λ ꡬλ ν Linux 05 - Shell Script & Cron Docker 01 - λ컀 κ°λ Docker 02 - λ컀 μ€μΉνκΈ° Docker 03 - λ컀 κΈ°λ³Έ λͺ λ Ήμ΄ Docker 04 - μ€λΌν΄, MySQL μ€μΉ νμ€ν#1 - Linux, Cloud, Serverless μκ° νμ€ν#2 - NCP(Naver Cloud Platform) CentOS μλ² μμ± λ° μ€μ νμ€ν#3 - Linux CentOS7μ Nginx μΉμλ² μ€μΉνκΈ° νμ€ν#4 - Linux μλ²μ Volta, node, pm2, python μ€μΉ νμ€ν#5 - CentOS7μ MySQL8 μ€μΉ νμ€ν#6 - Nginx μ ν λ° λ¬΄λ£ HTTPS μΈμ¦μ μ€μΉ νμ€ν#7 - docker image λ§λ€κΈ° 1 νμ€ν#8 - docker image λ§λ€κΈ° 2 νμ€ν#9 - docker image λ§λ€κΈ° μ 리 νμ€ν#10 - Linux λͺ λ Ήμ΄μ μ μ€ν¬λ¦½νΈ 1 νμ€ν#11 - Linux λͺ λ Ήμ΄μ μ μ€ν¬λ¦½νΈ 2 νμ€ν#12 - μ€λ¬΄μμ κΌ νμν κΈ°μ 1 νμ€ν#13 - μ€λ¬΄μμ κΌ νμν κΈ°μ 2 Tip#1 - μ μ€ν¬λ¦½νΈμ νλ‘λ€μ΄ μ°μν μ΅μ μ£ΌκΈ° Tip#2 - μ μ€ν¬λ¦½νΈλ₯Ό μμ€ν λͺ λ ΉμΌλ‘ λ±λ‘ [MySQL] MySQL 01 - Database λ° User μμ± MySQL 02 - Table μμ±, νκΈ μ€μ , Session κ°λ MySQL 03 - Table Altering, Sample Data μλ λ±λ‘ MySQL 04 - Insert, Select, Update, Delete λ¬Έ MySQL 05 - κ΄κ³(Foreign Key)μ indexμ κ°λ MySQL 06 - Join Tables ν μ΄λΈ μ‘°μΈνκΈ° MySQL 07 - λ΄μ₯ν¨μμ νΈλμμ MySQL 08 - μ°μ΅λ¬Έμ νμ΄ MySQL 09 - λ·°μ νΈλ¦¬κ±°, UNION, @rownum MySQL 10 - Stored Function & Procedure MySQL 11 - Cursorλ₯Ό μ΄μ©ν νλ‘μμ μμ± MySQL 12 - View, Trigger, Function, Procedure μ΅μ’ νκ° λ¬Έμ νμ΄ MySQL 13 - Backup & Restore νμ€ν#14 - MySQL μν λ°μ΄ν° μμ± νμ€ν#15 - MySQL DCL, DDL νμ€ν#16 - MySQL DML, TCL νμ€ν#17 - Mysql View, Trigger, Function, Procedure νμ€ν#18 - MySQL μ μ©ν λ΄μ₯ ν¨μ νμ€ν#19 - MySQL With - CTEλ‘ λ³΅μ‘ν 쿼리 μ½κ² μ½λ© νμ€ν#20 - MySQL νΈλ¦¬ν μλμ° ν¨μ μ¬μ© νμ€ν#21 - MySQL JSON λ°μ΄ν° νμ μ¬μ© νμ€ν#22 - MySQL λ°μ΄ν° λͺ¨λΈ μ€κ³, μ€λ¬΄ νλ‘μ νΈ μμ λ° μ€κ³ νμ€ν#23 - MySQL X DevApIλ₯Ό μ΄μ©ν NoSQL ꡬν λ° μ±ν λ°μ΄ν° λͺ¨λΈ κ΅¬μ± νμ€ν#24 - MySQL μ±λ₯ ν₯μ κΈ°λ² (μΈλ±μ€, Full text search, partition) νμ€ν#25 - MySQL μ€λ¬΄μμ κ°μ₯ μ€μν κΈ°μ (λ°±μ , 볡ꡬ, μ΄κ΄, 리ν리μΌμ΄μ ) Tip#1 - MySQL Drop table with Foreign Key Tip#2 - MySQL rollup κ³Ό pivot Tip#3 - Linux, MySQL μ€λΌν΄ ν΄λΌμ°λ λ¬΄λ£ μλ² μ¬μ©νκΈ° [Flask] νμ€ν#26 Flask μ€λ¬΄ - μ€μΉ, VS Code μΈν , λλ²κΉ , ν μ€νΈ [Git & Github] Git with Github 01 - Git μμ Git with Github 02 - Reset, Revert & Merge Git with Github 03 - Git Branch Git with Github 04 - μ΄μ 리 νμ€ν#27 Git μ€λ¬΄ 01 - rebase, fork & pull request etc. νμ€ν#28 Git μ€λ¬΄ 02 - Git Flow κ°λ λ° μ€μ μ¬λ‘ νμ€ν#29 Git μ€λ¬΄ 03 - Git Trouble Shooting Tip#1 - Github Branch μ¬μ©λ² [JavaScript] νμ€ν#1 - JS μ λλ‘ λ°°μ°κΈ° μκ° νμ€ν#2 - JS VSCode μΈν , μ μ©ν Extension μ€μΉ, λ¨μΆν€ νμ€ν#3 - JS λ³μ, μμ, λ°μ΄ν° νμ , νΈμ΄μ€ν , μ€μ½ν μ²΄μΈ νμ€ν#4 - ν¨μ νμ€ν#5 - λ³μμ ν¨μμ νΈμ΄μ€ν μ΄λ? νμ€ν#6 - OOP, TSμ μΈν°νμ΄μ€ etc. νμ€ν#7 - ν¨μμ λͺ¨λ κ² νμ€ν#8 - Strict mode κ΄λ ¨ μ§μ νμ€ν#9 - μ»΄νμΌ/μΈν°ν리ν°/λλ©μΈ/μ€ν 컨ν μ€νΈ/μ€μ½ν/this νμ€ν#10 - μ€ν μ½λλ‘ μμ보λ μ€ν 컨ν μ€νΈ λμ μ리 νμ€ν#11 - ν΄λ‘μ νμ€ν#12 - ν΄λμ€ νμ€ν#13 - λ°°μ΄1 νμ€ν#14 - λ°°μ΄2 νμ€ν#15 - Number & Math νμ€ν#16 - Date νμ€ν#17 - string, μ κ·μ νμ€ν#18 - Symbol (Enum, Iterator) νμ€ν#19 - μ€νλ λ, λμ€νΈλμ³λ§ νμ€ν#20 - Set, Map νμ€ν#21 - λΈλΌμ°μ λ λλ§, HTTP νμ€ν#22 - HTML & DOM νμ€ν#23 - DOM events νμ€ν#24 - Debounce & Throttle νμ€ν#25 - λΉλκΈ° νμ€ν#26 - Generator, Async & Await, μλ¬ μ²λ¦¬ [React] 리μ‘νΈ#1 - 리μ‘νΈ μ΄λ‘ 리μ‘νΈ#2 - SPA/CSR/SSR/SSG 리μ‘νΈ#3 - React μλ μ리 리μ‘νΈ#4 - 컀λ§κ³Ό ν©μ± 리μ‘νΈ#5 - 컀λ§κ³Ό ν©μ± νμ΄ λ¦¬μ‘νΈ#6 - JSX [Tip & Talk] Tip & Talk 01 - μ νμ€νμΈκ°? (κ°λ°μ μ»€λ¦¬μ΄ ν¨μ€) Tip & Talk 02 - λ³μ μ μΈκ³Ό GCμ μ리 Tip & Talk 03 - nullκ³Ό undefined κ°μ λ©λͺ¨λ¦¬ ν λΉ Tip & Talk 04 - JSμ μμ¬μ νλ‘κ·Έλλ° μΈμ΄μ νΈλ λμ μμ¬ Tip & Talk 05 - SW 곡ν μ΅μ λ² ν¨ν΄, MVC ν¨ν΄ Tip & Talk 06 - μμνμ μ΄ λΆλ³μ±μΈ μ΄μ Tip & Talk 07 - μ«μμΌκ΅¬ κ²μ νμ΄ Tip & Talk 08 - WASμ WSμ μ°¨μ΄μ Tip & Talk 09 - μ½λ°±ν¨μλ? Tip & Talk 10 - Objectμ κΉμλ³΅μ¬ vs. μμ λ³΅μ¬ Tip & Talk 11 - Daemon, Packet, Charset, SSH, HTTPS κ·Έλ¦¬κ³ λΌλΌλ? Tip & Talk 12 - κ°λ°μ μ·¨μ All-In-One Tip & Talk 13 - μ€λ¬΄ μ€ν°λ ν, μΈν°λ· μ리, λ€νΈμν¬, λ컀, ν΄λΌμ°λ Tip & Talk 14 - NCP μ μμ© IPμ κ³΅μΈ IPμ μ°¨μ΄ Tip & Talk 15 - νλ‘κ·Έλλ° κΈ°μ΄ μ΄λ‘ κ³΅λΆ μμμ μλ Ή Tip & Talk 16 - let νΈμ΄μ€ν Tip & Talk 17 - Nginx Node μ²λ¦¬ Tip & Talk 18 - μ±μ₯νλ κ°λ°μμ μ§μ₯ λ΄ μ²μΈμ Tip & Talk 19 - 2022 κ°λ° νΈλ λ λ° νμ΅ Tip & Talk 20 - μ μ κ°λ°μμ λ§μκ°μ§ Tip & Talk 21 - user agentμ λ€μν λλ°μ΄μ€ Tip & Talk 22 - κ°λ°μ μ μ±μλ λͺ κ³Ό μ Tip & Talk 23 - κΈ°μ μ€ν μ μ [μ± μκ°] μ± μκ° - νλ‘κ·Έλλ° κ³΅λΆλ μ± μΌλ‘ νμ? μ± μκ° - λͺ¨λ μλ°μ€ν¬λ¦½νΈ Deep Dive 1λΆ μ± μκ° - 리λ μ€ ν΅μ¬ λ νΌλ°μ€ μ± μκ° - μκ³ λ¦¬μ¦ [νΉκ°] 2022 μΉ΄μΉ΄μ€ μ μ κ°λ°μ λΈλΌμΈλ μ±μ© μ«μμΌκ΅¬κ²μ νμ΄ Assignments (SSAC) π¨βπ» Assignment - Shell Script Assignment - JavaScript 01 - number baseball game Assignment - JavaScript 02 - compose function Assignment - Node.js - singleton pattern