본문 바로가기

반응형
SMALL

DB

(118)
SQL Query Execution Order
Oracle에서 MongoDB로의 CDC Pipeline 구축 https://tech.kakaopay.com/post/kakaopaysec-mongodb-cdc/ Oracle에서 MongoDB로의 CDC Pipeline 구축 | 카카오페이 기술 블로그Oracle에서 MongoDB로의 초기 데이터 이관 및 CDC Pipeline 구축 경험을 공유합니다.tech.kakaopay.com
CDC(Change Data Capture) https://suminii.tistory.com/entry/CDCChange-Data-Capture-%EA%B0%9C%EB%85%90%EA%B3%BC-%EA%B5%AC%EC%B6%95%ED%95%B4%EB%B3%B4%EA%B8%B0#:~:text=CDC(Change%20Data%20Capture)%EB%8A%94,%EC%9D%B4%EB%82%98%20%EC%95%A0%ED%94%8C%EB%A6%AC%EC%BC%80%EC%9D%B4%EC%85%98%EC%97%90%EA%B2%8C%20%EC%A0%84%EB%8B%AC%ED%95%9C%EB%8B%A4. CDC(Change Data Capture) 개념 및 테크 기업 사례 살펴보기CDC(Change Data Capture) 개념CDC(Change Data C..
SQL Operations
SQL 수행 순서
Types of Database
Say NO to Venn Diagrams When Explaining JOINs https://blog.jooq.org/say-no-to-venn-diagrams-when-explaining-joins/ Say NO to Venn Diagrams When Explaining JOINsIn recent times, there have been a couple of tremendously popular blog posts explaining JOINs using Venn Diagrams. After all, relational algebra and SQL are set oriented theories and languages, so …blog.jooq.org
SQL Tutorial https://www.w3schools.com/sql/default.asp W3Schools.comW3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.www.w3schools.com
SQL JOINS
오라클 문자열 붙이기 / WM_CONCAT / LISTAGG https://studyingazae.tistory.com/14 [ORACLE] 오라클 문자열 붙이기 / WM_CONCAT / LISTAGG* WM_CONCAT, LISTAGG, 문자열 연결, 컬럼 붙이기, 컬럼연결, 여러행합치기 * 10g~11g R1에서는 WM_CONCAT, 11g R2 이상부터는 LISTAGG 사용 (버전모르겠으면 그냥 다해보고 되는거 하면됩니다) * 모두 GROUP 함수이studyingazae.tistory.com

반응형
LIST