[ DB ] DB 공부하는 법

* DB 강의

 

https://github.com/ossu/computer-science?tab=readme-ov-file

GitHub - ossu/computer-science: 🎓 Path to a free self-taught education in Computer Science!

Courses | Duration | Effort | Prerequisites | Discussion

Databases: Modeling and Theory	2 weeks	10 hours/week	core programming	chat
Databases: Relational Databases and SQL	2 weeks	10 hours/week	core programming	chat
Databases: Semistructured Data	2 weeks	10 hours/week	core programming	chat

 

* DB 공부하는 법

오라클 필수
개발자들이 개발한 sql이 잘 짜여졌는지 검증한다.
튜닝 : index 추가하거나 똘똘한 index 태우는 정도로 많이 하더라
보통 index에 대한 정책
개발자들이 index를 잘 타게하는 것만 해도 sql 잘 짜는 것과 같다
튜너가 튜닝을 할게 없을 정도까지 짤 수 있으면 된다.

튜너들 : 실행계획을 본다
실행계획 확인하는 습관 들여야 한다

항상 시간을 내서 다른 사람들은 sql을 어떻게 자는지 확인해봐야 한다

 

www.yes24.com/Product/goods/59273790?scode=032&OzSrank=1