{"id":275604,"date":"2022-08-24T06:24:54","date_gmt":"2022-08-24T05:24:54","guid":{"rendered":"https:\/\/blog.jetbrains.com\/education\/2022\/07\/27\/sql-with-python-on-jetbrains-academy\/"},"modified":"2022-08-24T06:57:17","modified_gmt":"2022-08-24T05:57:17","slug":"sql-with-python-on-jetbrains-academy","status":"publish","type":"education","link":"https:\/\/blog.jetbrains.com\/ko\/education\/2022\/08\/24\/sql-with-python-on-jetbrains-academy\/","title":{"rendered":"JetBrains Academy\uc758 SQL With Python \ud2b8\ub799"},"content":{"rendered":"

SQL(Structured Query Language) \uad00\ub828 \uc9c0\uc2dd\uc740 \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\ub294 \ubaa8\ub4e0 \ubd84\ub4e4\uaed8 \uac01\uad11\ubc1b\ub294 \uae30\uc220 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \ub370\uc774\ud130 \uacfc\ud559, \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uac1c\ubc1c, \ub9c8\ucf00\ud305 \ub610\ub294 \uc81c\ud488 \uad00\ub9ac \ub4f1 \ub2e4\uc591\ud55c \ubd84\uc57c\ub97c \ub9c9\ub860\ud558\uace0, SQL\uc740 \uc5c5\ubb34 \uc131\uacfc\ub97c \ud5a5\uc0c1\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc0ac\uc6a9\uc790 \ubd84\ub958, \ub370\uc774\ud130\uc5d0\uc11c \ud328\ud134 \ucc3e\uae30, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \uac1c\uc120\uc744 \uc704\ud574 SQL \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uace0 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc774\uc5d0 JetBrains Academy\uc5d0\uc11c\ub294 SQL With Python<\/a> \ud2b8\ub799\uc744 \uc0c8\ub86d\uac8c \uc120\ubcf4\uc785\ub2c8\ub2e4. \uc774 \uc2e0\uaddc JetBrains Academy \ud2b8\ub799\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uace0, \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uacfc \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ubc18 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc81c\uc791\uc744 \uc704\ud574 \uc790\uc8fc \ud568\uaed8 \uc0ac\uc6a9\ub418\ub294 Python \ud544\uc218 \uc9c0\uc2dd\ub3c4 \ud559\uc2b5\ud569\ub2c8\ub2e4.<\/p>\n

\"\"<\/figure>\n

<\/i>\uc2dc\uc791\ud558\uae30<\/a><\/p>\n

\ud559\uc2b5 \ub0b4\uc6a9<\/h2>\n

\ud559\uc2b5\uc790\ub294 SQL With Python<\/a> \ud2b8\ub799\uc744 \ud1b5\ud574 SQL\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\uace0, Python\uc73c\ub85c \ub370\uc774\ud130 \ubd84\uc11d\uc744 \uc218\ud589\ud558\uba70, \uc790\uc8fc \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc744 \uc0ac\uc6a9\ud574\ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c, SQL\uc758 \ubaa8\ub4e0 \uae30\ub2a5\uc744 \uc790\uc720\ub86d\uac8c \uc774\uc6a9\ud558\uae30 \uc704\ud55c Python \ub77c\uc774\ube0c\ub7ec\ub9ac SQLAlchemy \uc0ac\uc6a9\ubc95\uae4c\uc9c0 \uc775\ud790 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uad6c\uccb4\uc801\uc778 \ud559\uc2b5 \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

✅ SQL \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud55c \ub370\uc774\ud130 \uac80\uc0c9, \uc800\uc7a5 \ubc0f \ucc98\ub9ac \ubc29\ubc95\uc744 \ud559\uc2b5\ud569\ub2c8\ub2e4.
✅ Python\uc73c\ub85c SQLite \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub2e4\ub8f9\ub2c8\ub2e4.
✅ SQL \ucffc\ub9ac \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucee4\uc11c \uba54\uc11c\ub4dc\ub97c \uc775\ud799\ub2c8\ub2e4.
✅ \ub8e8\ud504, \ub9ac\uc2a4\ud2b8 \ubc0f \ub2e4\uc591\ud55c \ubb38\uc790\uc5f4 \uba54\uc11c\ub4dc\uc758 \ud65c\uc6a9\ubc95\uc744 \uc5f0\uc2b5\ud569\ub2c8\ub2e4.<\/p>\n

SQL With Python \ud2b8\ub799\uc744 \uc2dc\uc791\ud558\uc5ec 500,000\uba85 \uc774\uc0c1\uc774 \ucc38\uc5ec\ud558\ub294 JetBrains Academy \ud559\uc2b5\uc790 \ucee4\ubba4\ub2c8\ud2f0\uc758 \uc77c\uc6d0\uc774 \ub418\uc5b4\ubcf4\uc138\uc694. \ud559\uc2b5\uc790 \ucee4\ubba4\ub2c8\ud2f0\uc5d0\uc11c \ud559\uc2b5 \ub0b4\uc6a9\uc744 \ud1a0\ub860\ud558\uace0, \ud568\uaed8 \uacfc\uc81c\ub97c \uc644\uc131\ud558\uace0, \uc9c0\uc2dd\uc744 \uacf5\uc720\ud558\uac70\ub098 \uc11c\ub85c\uc758 \uc9c8\ubb38\uc5d0 \ub2f5\ubcc0\ud558\uc5ec \ub3c4\uc6c0\uc744 \uc904 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ube4c\ub4dc\ud560 \ud504\ub85c\uc81d\ud2b8<\/h2>\n

\uc774 \ud2b8\ub799\uc5d0\uc11c 180\uac1c \uc774\uc0c1\uc758 \uad50\uc721 \uc8fc\uc81c \ubc0f \ub2e8\uacc4\ubcc4\ub85c \uc81c\uc791\ud558\ub294 18\uac1c\uc758 \uc2e4\uc2b5 \ud504\ub85c\uc81d\ud2b8\ub97c \uc774\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc2e4\uc2b5 \ud504\ub85c\uc81d\ud2b8\uc758 \uc608\uc2dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

🔷 Honest Calculator(\uacf5\uc815\ud55c \uacc4\uc0b0\uae30)<\/a>. \ub09c\uc774\ub3c4: \ud558, 10\uc2dc\uac04.<\/em><\/p>\n

Honest Calculator\ub294 \uae30\uc874 \uacc4\uc0b0\uae30\ub97c \uc0c8\ub86d\uac8c \uc7ac\ud574\uc11d\ud55c \uacc4\uc0b0\uae30\uc785\ub2c8\ub2e4. \uc774 \uacc4\uc0b0\uae30\ub294 \ud544\uc694\ud55c \ubaa8\ub4e0 \uacc4\uc0b0\uc744 \uc218\ud589\ud560 \ubfd0 \uc544\ub2c8\ub77c, \uac04\ub2e8\ud55c \uacc4\uc0b0\uc744 \uc9c1\uc811 \ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0 \uc794\uc18c\ub9ac\uae4c\uc9c0 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ud559\uc2b5 \uc758\uc695\uc744 \uace0\ucde8\uc2dc\ucf1c\uc8fc\ub294 \ud504\ub85c\uc81d\ud2b8\uc8e0. \uc774 \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c \ucd5c\uc885 \uacb0\uacfc\ubb3c\uc778 \uc571\uc744 \uc81c\uc791\ud558\ub824\uba74 \uc21c\uc11c\ub3c4\ub97c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc21c\uc11c\ub3c4\ub97c \uc77d\ub294 \ubc29\ubc95\uc744 \ubc30\uc6b0\uace0 \ub8e8\ud504, \uc870\uac74 \ubc0f \uc54c\uace0\ub9ac\uc998\uc744 \uc774\ud574\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

🔷 Read Quality Control(\ud488\uc9c8 \uad00\ub9ac \ub370\uc774\ud130 \ud310\ub3c5)<\/a>. \ub09c\uc774\ub3c4: \uc911, 15\uc2dc\uac04.<\/em><\/p>\n

\uc774 \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c\ub294 \uc2e4\uc81c \uc0dd\ubb3c\ud559 \uad00\ub828 \uc791\uc5c5\uc5d0 \ud504\ub85c\uadf8\ub798\ubc0d\uc744 \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6c1\ub2c8\ub2e4. \ub370\uc774\ud130 \ud488\uc9c8\uc758 \uc8fc\uc694 \ub9e4\uac1c\ubcc0\uc218 \ubc0f Python\uc744 \uc0ac\uc6a9\ud55c \ub370\uc774\ud130 \ud3c9\uac00 \uc790\ub3d9\ud654\ub97c \ud559\uc2b5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc11c\ub85c \ub2e4\ub978 \ubd84\uc57c\uac00 \uacb0\ud569\ub41c \ubb38\uc81c \ud574\uacb0\uc5d0 \uad00\uc2ec\uc774 \uc788\ub294 \ubd84\uaed8 \uc801\ud569\ud55c \ud504\ub85c\uc81d\ud2b8\uc785\ub2c8\ub2e4.<\/p>\n

🔷 Memorization Tool(\uc554\uae30 \ub3c4\uad6c)<\/a>. \ub09c\uc774\ub3c4: \uc0c1, 26\uc2dc\uac04.<\/em><\/p>\n

\uc774 \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c\ub294 \uae00\uc904, \uc2dc, \uc5f0\uc124 \ubc0f \uae30\ud0c0 \ud14d\uc2a4\ud2b8 \uc790\ub8cc\ub97c \uc554\uae30\ud558\uae30 \uc704\ud55c \ub3c4\uad6c\ub97c \uc81c\uc791\ud569\ub2c8\ub2e4. \uc774\uc81c \ud63c\uc790 \uc554\uae30\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4! SQLAlchemy ORM \ubc0f SQLite \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uace0, \ub8e8\ud504, \ub9ac\uc2a4\ud2b8 \ubc0f \ub2e4\uc591\ud55c \ubb38\uc790\uc5f4 \uba54\uc11c\ub4dc\ub97c \ud559\uc2b5\ud569\ub2c8\ub2e4.<\/p>\n

\uc774 \ud2b8\ub799\uc744 \uc644\ub8cc\ud558\uba74 LinkedIn \ud504\ub85c\ud544 \ubc0f \uc774\ub825\uc11c\uc5d0 \ucd94\uac00\ud560 \uc218 \uc788\ub294 \uc218\ub8cc\uc99d\uc774 \uc81c\uacf5\ub429\ub2c8\ub2e4. \uc644\ub8cc\ud55c \ud504\ub85c\uc81d\ud2b8\ub294 GitHub \ud504\ub85c\ud544\uc5d0\ub3c4 \ucd94\uac00\ud558\uc5ec \uac1c\ubc1c\uc790 \ud3ec\ud2b8\ud3f4\ub9ac\uc624\ub97c \ud48d\uc131\ud558\uac8c \ucc44\uc6cc\ubcf4\uc138\uc694!<\/p>\n

\ud2b8\ub799 \uc644\ub8cc \ud6c4 \uacbd\ub825 \ubc29\ud5a5<\/h2>\n

SQL With Python \ud2b8\ub799\uc744 \ud1b5\ud574 \ub370\uc774\ud130 \uc5c5\ubb34\uc5d0 \ub300\ud55c \uc774\ud574\ub97c \uc99d\uc9c4\ud558\uace0, \uc8fc\ub2c8\uc5b4 \ub370\uc774\ud130 \ubd84\uc11d\uac00 \ucde8\uc5c5 \uba74\uc811 \uc9c8\ubb38\uc5d0 \ub300\ube44\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c SQL Fundamentals<\/a> \ud2b8\ub799\uacfc \ud568\uaed8 \uacf5\ubd80\ud558\uc5ec SQL \uc5ed\ub7c9\uc744 \uac15\ud654\ud558\uace0 \uba74\uc811\uc5d0 \ub354 \uc790\uc2e0\uac10 \uc788\uac8c \uc784\ud558\uc138\uc694.<\/p>\n

\ub370\uc774\ud130 \ubd84\uc57c\uc5d0\uc11c \uacbd\ub825\uc744 \uc313\uc744 \uacc4\ud68d\uc774 \uc544\ub2c8\ub354\ub77c\ub3c4, \uc81c\ud488 \uad00\ub9ac, \ub9c8\ucf00\ud305, \uc5f0\uad6c, \ud68c\uacc4 \ubc0f \ub370\uc774\ud130\uc640 \uad00\ub828\ub41c \uae30\ud0c0 \ubaa8\ub4e0 \ubd84\uc57c \ub4f1 \ub2e4\ub978 \ubd84\uc57c\uc5d0\uc11c\ub3c4 SQL\uacfc Python \ud2b8\ub799\uc5d0\uc11c \ud559\uc2b5\ud55c \uc0c8\ub85c\uc6b4 \uc5ed\ub7c9\uc744 \ud65c\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

JetBrains Academy\uc5d0\uc11c \uc990\uac81\uac8c \ud559\uc2b5\ud558\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4! \uc9c8\ubb38\uc774 \uc788\uac70\ub098 \ud53c\ub4dc\ubc31\uc744 \uacf5\uc720\ud558\uace0 \uc2f6\uc740 \uacbd\uc6b0 \uc544\ub798\uc5d0 \ub313\uae00\uc744 \ub0a8\uae30\uac70\ub098 academy@jetbrains.com<\/a>\uc73c\ub85c \ubb38\uc758\ud574 \uc8fc\uc138\uc694.<\/p>\n

\ub298 \uc5ec\ub7ec\ubd84\uc744 \uc751\uc6d0\ud569\ub2c8\ub2e4!<\/em>
JetBrains Academy \ud300 \ub4dc\ub9bc<\/em><\/p>\n

\uac8c\uc2dc\ubb3c \uc6d0\ubb38 \uc791\uc131\uc790<\/em><\/p>\n\n

\n
\n
\n
\n \"\"\n <\/div>\n
\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n","protected":false},"author":964,"featured_media":267750,"comment_status":"closed","ping_status":"closed","template":"","categories":[952,283,89,4440],"tags":[201],"cross-post-tag":[],"acf":[],"_links":{"self":[{"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/education\/275604"}],"collection":[{"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/education"}],"about":[{"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/types\/education"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/users\/964"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/comments?post=275604"}],"version-history":[{"count":7,"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/education\/275604\/revisions"}],"predecessor-version":[{"id":275612,"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/education\/275604\/revisions\/275612"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/media\/267750"}],"wp:attachment":[{"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/media?parent=275604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/categories?post=275604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/tags?post=275604"},{"taxonomy":"cross-post-tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/ko\/wp-json\/wp\/v2\/cross-post-tag?post=275604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}