공부하고 싶은 곳

http://blog.naver.com/alicialee74

https://xlworks.net/

http://www.rondebruin.nl/

http://www.iexceller.com/MyXls/VBA_Beginner/Index_Beginner.asp

https://www.kubiszyn.co.uk/free-stuff.html

http://blog.naver.com/ks_1862/221433281219

https://programmers.co.kr

파이썬공부 PyQt5

https://umnoni.tistory.com/

https://www.slideshare.net/ravenkyu/pycon-2017-pyqt

https://076923.github.io/posts/#python 파이썬

https://tariat.tistory.com/category/%ED%8C%8C%EC%9D%B4%EC%8D%AC

 

https://codetorial.net/pages/home

 

이승준 인생은 짧아요, 엑셀 대신 파이썬 파이썬으로 도전 하는 업무 자동화와 RPA 로봇 프로세스 자동화

https://github.com/FinanceData/Life-is-short/blob/master/README.md 

주피터 수첩

홈택스 공인인증서 로그인

https://nbviewer.jupyter.org/gist/FinanceData/3866e1939cdf0e3e5140331df28ea15f

 

https://wikidocs.net/26471 https://wikidocs.net/26460

 

opencv

https://076923.github.io/posts/Python-opencv-1/

 

python-docx

https://python-docx.readthedocs.io/en/latest/#

 

파이썬 매크로

https://github.com/MacHu-GWU/macro-project

 

유용한 프로그램 찾는곳

http://freeprosoftz.com/

 

pynput 이미지클릭

https://wikidocs.net/26460

 

파이썬카페

https://cafe.naver.com/jkitstudy

 

파이썬

https://wikidocs.net/4308

 

autoit

https://www.guru99.com/

 

잔재미

https://www.fun-coding.org/crawl_basic1.html

 

연구중 홈택스 세금계산서 발행

https://blog.naver.com/12heejin/221402335805

 

예제로 배우는 PyQt5

https://opentutorials.org/module/544

 

web

http://webberstudy.com/

 

점프 투 파이썬

https://wikidocs.net/13

 

파이썬으로 배우는 알고리즘 트레이딩

https://wikidocs.net/5247

1) QFileDialog

디자이너를 위한 HTML/CSS - ANZI

https://www.youtube.com/playlist?list=PLy8gaHExYFXEC4oO3Rxf7rj2pwqbMORy_ 

디자이너를 위한 HTML/CSS (처음부터)

https://www.youtube.com/playlist?list=PL4UVBBIc6giKkfYN_2TVPgbMpd87lJEfg 

웹표준 사이트 만들기

Node.js

https://www.youtube.com/playlist?list=PLcqDmjxt30RsGIPBBKX7xl05VuqJeCTFn 

노드교과서 개정3판

Node.js 백엔드 맛보기1

https://www.youtube.com/playlist?list=PLSK4WsJ8JS4cQ-niGNum4bkK_THHOizTs 

[Node.js] 백엔드 맛보기

 

https://www.youtube.com/playlist?list=PLuHgQVnccGMBB348PWRN0fREzYcYgFybf 

WEB2-JavaScript

 

https://www.youtube.com/playlist?list=PLuHgQVnccGMAMctarDlPyv6upFUUnpSO3 

JavaScript Object Oriented Programming

9. class의 constructor

10. 메소드 구현

11. 상속

12. super

13.1. object inheritance

13.2. __proto__

13.3. Object.create(), debugger - Watch

13.4. 객체상속의 사용

14.1. 객체와 함수

14.2. call

14.3. bind

 

https://www.youtube.com/watch?v=Krc4mHkGLqM&list=PLeNJ9AVv90q0t7m-AE6aTSsyUaIWjpU_1 

https://codegear.tistory.com/category/%EC%9D%BC%EB%A0%89%ED%8A%B8%EB%A1%A0%20%EA%B8%B0%EC%B4%88

'일렉트론 기초' 카테고리의 글 목록

https://www.youtube.com/playlist?list=PLuHgQVnccGMAicFFRh8vFFFtLLlNojWUh 

Node.js-MySQL

node nodejs/mysql.js

에러

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

 

해결책

https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server

MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '패스워드';

 

참고-mysql

mysql -uroot -p

패스워드

mysql>

show databases;

use opentutorials;

show tables;

select * from topic;

 

node nodejs/mysql.js

 

================

https://www.youtube.com/playlist?list=PLVsNizTWUw7GCfy5RH27cQL5MeKYnl8Pm 

[SQL 기초 강의] 혼자 공부하는 SQL(MySQL 8.0)

https://techsolutionstuff.com/post/node-js-express-crud-example-with-mysql

Node.js Express CRUD Example With MySQL