
çç£æ§ãé«ãã NotebookLM ã®æŽ»çšã¬ã€ã
may9noy
NotebookLM ãæŽ»çšããŠæéãç¯çŽããæ¥åçç£æ§ãæå€§éã«é«ããæ¹æ³ãåŠã¶è¬åº§ã§ãã
å ¥é
Business Productivity, needs analysis, AI
PostgreSQLã䜿çšããŠ500äžä»¶ã®éåœã®ã¢ããŒãååŒããŒã¿ãåæããæ¹æ³ãåŠã³ãŸããããŒã¿ã®ã¯ãªãŒãã³ã°ã倿ãããã³å€æ§ãªSQLã¯ãšãªãéããŠãæå³ã®ããã€ã³ãµã€ããå°ãåºãããã»ã¹ãæ±ããŸãã
åè¬ç 125å
é£æåºŠ åçŽ
åè¬æé ç¡å¶é


åŠç¿ããåè¬è ã®ã¬ãã¥ãŒ
5.0
Jang Jaehoon
è¯ãè¬çŸ©ããããšãããããŸãïŒ
5.0
hakjuknu
5.0
íì€
SQLã¯å šãã®åããŠã§ããããšã¯ã»ã«ã§ãã¯ãŒã¯ãšãªãäœ¿ãæ £ããŠããã®ã§ãããã»ã©é£ããã¯ãªãã§ããã
ããŒã¿åæ
PostgreSQLãæŽ»çšããããŒã¿åæ
SQLãæŽ»çšããããŒã¿åæ
ãã®è¬çŸ©ã§ã¯ãPostgreSQLã䜿çšããŠ500äžä»¶ã«éããéåœã®ã¢ããŒãååŒããŒã¿ãåæããå¯èŠåããæ¹æ³ãåŠã³ãŸãã
ããŒã¿ããŒã¹ãããŒãã«ã®äœæããããŒã¿ã®ç²Ÿè£œãã¯ãšãªã®äœæããããŠPythonã®Dashã©ã€ãã©ãªã掻çšããå¯èŠåã«ããã€ã³ãµã€ãã®å°åºãŸã§ãå®åã§ããã«æŽ»çšã§ããæè¡ãç¿åŸã§ããŸãã
ããŒã¿åæãšå¯èŠåã«é¢å¿ãããæ¹ã®ããã®è¬çŸ©ã§ããð
ããŒã¿åæã®å ¥éè
PostgreSQLãæŽ»çšããããŒã¿ããŒã¹ç®¡çãšå€§å®¹éããŒã¿åæã«é¢å¿ãããåå¿è ã
SQLãŠãŒã¶ãŒ
éåœã®ã¢ããŒãååŒããŒã¿ãéããŠã倿§ãªSQLã¯ãšãªãšé¢æ°ã掻çšããããŒã¿ã®æœåºããã³åæã
ããŒã¿å¯èŠåã®å ¥éè
åæçµæã广çã«èŠèŠåããã€ã³ãµã€ããå°ãåºãããããŒã¿èŠèŠåã®å ¥éè ã
PostgreSQLãæŽ»çšãã倧容éããŒã¿ããŒã¹ç®¡çããã³ã¯ãšãªäœæèœåã®ç¿åŸã
åæçµæãèŠèŠåããŒã«ãéããŠå¹æçã«è¡šçŸããã³äœæå¯èœã
倧容éã®ããŒã¿ã掻çšããããŒã¿åæãè¡ããææçŸ©ãªã€ã³ãµã€ããå°åºã
PostgreSQL, DBMS/RDBMS, data-analysis, data-cleaning, ããŒã¿ãšã³ãžãã¢ãªã³ã°é¢é£ã®å 容ãåŠç¿ã
å¯èŠå (Python Dash)
åæããããŒã¿ãããŸããŸãªèŠèŠåããŒã«ã䜿çšããŠå¹æçã«è¡šçŸãã倿§ãªã°ã©ã圢åŒã§è¡šçŸããæ¹æ³ã«ã€ããŠåŠç¿ããŸãã
PostgreSQLã®åºæ¬ã¯ãšãªæ§æãšå€æ§ãªé¢æ°ã®äœ¿ãæ¹ãåŠç¿ããŸãããããéããŠãããŒã¿ããŒã¹ããããŒã¿ãå¹ççã«ç §äŒããæäœã§ããèœåãé€ããŸãã
颿°ã掻çšããã¯ãšãªåæ
äœæããã¯ãšãªã掻çšããŠå€§å®¹éããŒã¿ãåæããåæçµæãèŠèŠåããŒã«ãéããŠå¹æçã«è¡šçŸããæ¹æ³ãåŠã³ãŸããããã«ãããããŒã¿ããææçŸ©ãªã€ã³ãµã€ããå°ãåºãããšãã§ããŸãã
倿§ãªããŒã¿å¯èŠååæ
ãªãã¬ãŒãã£ã³ã°ã·ã¹ãã ããã³ããŒãžã§ã³(OS): Windows, macOS
䜿çšããŒã«: Postgresql, DBeaver, Python
åŠç¿è³æã¯è¬çŸ©ããŒããéããŠæäŸããŸãã
SQL (SELECT, INSERT, DELETE, UPDATE) ãšãã£ãåºç€çãªã¯ãšãªã®äœ¿ç𿹿³ã
PythonïŒåºæ¬çãªPythonã®ææ³ã«é¢ããåºç€ç¥èïŒ
è©±ãæ¹ããã£ãããªæ¹ãªã®ã§ãåç»ã®é床ã1.2ã1.5åã«èšå®ããŠèŠèŽãããšãããã¹ã ãŒãºã«ã芧ããã ããŸãã
äžéšã®æ åã«ãã€ãºãããç¹ãããããããäºæ¿ãã ããã
åŠç¿å¯Ÿè±¡ã¯
誰ã§ãããïŒ
ããŒã¿ãµã€ãšã³ã¹ããã³ããŒã¿ãšã³ãžãã¢ãªã³ã°åéã«å ¥éããããšããåŠçããã³åå¿è
PostgreSQLã䜿çšããŠå€§å®¹éããŒã¿ãå¹ççã«åæãããæ¹
SQLã¯ãšãªã®äœæããã³ããŒã¿ã®ç²Ÿè£œã倿æè¡ãåäžããããæ¹
åæç¥èã
å¿
èŠã§ããããïŒ
PostgreSQLã®åºæ¬ã¯ãšãªã®äœ¿ç𿹿³ (SELECT, UPDATE, INSERT, DELETE)
ãã£ãªã¢èªèšŒ
2,562
åè¬ç
295
åè¬ã¬ãã¥ãŒ
26
åç
4.4
è¬åº§è©äŸ¡
8
è¬åº§
ããã«ã¡ã¯ãð
æã ãè²å ãšä»äºã§ããŒã³ã¢ãŠãã«ãªãç²ãæãŠãŠããŸãããšããããŸãããð
äžæ¥äžæ¥ãåžžã«æè¬ãšæ¥œããæ°æã¡ã§çããŠããITåŽåè ã§ããð
å人ããã°ïŒhttps://may9noy.tistory.com
GitHub : https://github.com/Nanninggu
人çãšãå®¶åºã®äžã«ããã€ãè¯ãããšã ããæº¢ãããããç¥ãããããŸãã ð
å šäœ
64ä»¶ â (8æé 49å)
å šäœ
12ä»¶
4.4
12ä»¶ã®åè¬ã¬ãã¥ãŒ
åè¬ã¬ãã¥ãŒ 12
â
å¹³åè©äŸ¡ 4.9
åè¬ã¬ãã¥ãŒ 7
â
å¹³åè©äŸ¡ 2.0
1
åãããšãäœåºŠãäœåºŠãç¹°ãè¿ããŠèšããäœåºŠãç¹°ãè¿ããŠèšããäœåºŠãç¹°ãè¿ããŠèšãã
ããã«ã¡ã¯ã:) ç¹°ãè¿ãããã¯ãšãªã颿°ãªã©ã説æããéã«ãç¹°ãè¿ã説æããéšåãæ°ã«å ¥ããªãã£ãããã§ãããããããå人çã«äœ¿çšé »åºŠã®é«ã颿°ãªã©ãç¹°ãè¿ã説æããããšã§ãèšæ¶ã«é·ãæ®ã£ãŠã»ãããšããæãããç¹°ãè¿ã説æããŸãããæ¹åã§ããéšåã¯æ¹åããŠãããè¯ãè¬çŸ©ãäœããããåªåããŸãã åè¬ã¬ãã¥ãŒããããšãããããŸãã^^
ããã§ã¯ãªããŠãç¡é§ãªããšãç¹°ãè¿ããã§ããããã§ãããã§ããããããããã
åè¬ã¬ãã¥ãŒ 2
â
å¹³åè©äŸ¡ 5.0
ç¥èå ±æè ã®ä»ã®è¬åº§ãèŠãŠã¿ãŸãããïŒ
åãåéã®ä»ã®è¬åº§ãèŠãŠã¿ãŸãããïŒ
æééå®ã»ãŒã«ãããš6æ¥æ¥ã§çµäº
ï¿¥22
23%
ï¿¥4,689