<> | ȭ
Ȱϱ ּ ! α , ˻ϰ ٷ SQL(Structure Query Language) Ѱᰰ ڸ Ű ִ. ʺڸ SQL 200 (PL/SQL) 5 Ʈ 200 Ǿ ִ. SQL ʸ , α غν SQL Ȱ ӽŷ м Kaggle ǿ ֵ Ǿ ִ. ӽŷ žǾ ִ Ŭ 19c ġϰ, ϳϳ Էϸ鼭 å غ нϸ ͺм ʰ ̴. OS Ʈ SQL*PLUS Ʈ â Ŭ ͺ̽ ؼ н ص ǰ, SQL DEVELOPER нص ȴ. å ϵ ڵ ȭ Ȩ(infopub.co.kr) ڷǿ ٿε ִ. н ñ Ȩ(cafe.daum.net/oracleoracle) ǵ ϱ ִ.
PART 1 Թ SQL ù 001 ̺ Ư (COLUMN) ϱ002 ̺ (COLUMN) ϱ003 ÷ Ī Ͽ µǴ ÷ ϱ004 ϱ(||)005 ߺ ؼ ϱ(DISTINCT)006 ؼ ϱ(ORDER BY)007 WHERE 1( ˻)008 WHERE 2(ڿ ¥ ˻)009 (*, /, +, -)010 1(, , =, =, =, !=, , ^=)011 2(BETWEEN AND)012 3(LIKE)013 4(IS NULL)014 5(IN)015 (AND, OR, NOT) PART 2 ʱޡ SQL 016 ҹ ȯ Լ (UPPER, LOWER, INITCAP)017 ڿ Ư ö ϱ(SUBSTR)018 ڿ ̸ ϱ(LENGTH)019 ڿ Ư ö ġ ϱ(INSTR) 020 Ư öڸ ٸ öڷ ϱ(REPLACE) 021 Ư öڸ N ŭ ä(LPAD, RPAD)022 Ư ö ߶(TRIM, RTRIM, LTRIM) 023 ݿøؼ ϱ(ROUND)024 ڸ ϱ(TRUNC)025 ϱ(MOD)026 ¥ ϱ(MONTHS_BETWEN) 027 ¥ ϱ(ADD_MONTHS) 028 Ư ¥ ڿ ¥ ϱ(NEXT_DAY)029 Ư ¥ ִ ¥ ϱ(LAST_DAY)030 ȯϱ(TO_CHAR)031 ¥ ȯϱ(TO_DATE)032 Ͻ ȯ ϱ033 NULL ٸ ϱ(NVL, NVL2)034 IF SQL ϱ 1(DECODE)035 IF SQL ϱ 2(CASE)036 ִ밪 ϱ(MAX)037 ּҰ ϱ(MIN)038 հ ϱ(AVG)039 Ż ϱ(SUM)040 Ǽ ϱ(COUNT)041 м Լ ϱ 1(RANK)042 м Լ ϱ 2(DENSE_RANK)043 м Լ ϱ(NTILE) 044 м Լ ϱ(CUME_DIST)045 м Լ η ϱ(LISTAGG)046 м Լ ٷ ϱ(LAG, LEAD)047 COLUMN ROW ϱ 1(SUM+DECODE)048 COLUMN ROW ϱ 2(PIVOT)049 ROW COLUMN ϱ(UNPIVOT)050 м Լ ϱ(SUM OVER)051 м Լ ϱ(RATIO_TO_REPORT) 052 м Լ ϱ 1(ROLLUP)053 м Լ ϱ 2(CUBE)054 м Լ ϱ 3(GROUPING SETS)055 м Լ ѹ ϱ(ROW_NUMBER)PART 3 ߱ޡ SQL Ƿ 056 µǴ ϱ 1(ROWNUM)057 µǴ ϱ 2(Simple TOP-n Queries)058 ̺ ؼ ϱ 1(EQUI JOIN)059 ̺ ؼ ϱ 2(NON EQUI JOIN)060 ̺ ؼ ϱ 3(OUTER JOIN)061 ̺ ؼ ϱ 4(SELF JOIN)062 ̺ ؼ ϱ 5(ON)063 ̺ ؼ ϱ 5(USING)064 ̺ ؼ ϱ 6(NATURAL JOIN)065 ̺ ؼ ϱ 7(LEFT/RIGHT OUTER JOIN)066 ̺ ؼ ϱ 8(FULL OUTER JOIN)067 ڷ Ʒ ϱ 1(UNION ALL)068 ڷ Ʒ ϱ 2(UNION) 069 ڷ ϱ(INTERSECT) 070 ڷ ̸ ϱ(MINUS) 071 ϱ 1( )072 ϱ 2( )073 ϱ 3(NOT IN)074 ϱ 4(EXISTS NOT EXISTS)075 ϱ 5(HAVING )076 ϱ 6(FROM )077 ϱ 7(SELECT )078 Էϱ(INSERT)079 ϱ(UPDATE)080 ϱ(DELETE, TRUNCATE, DROP)081 ϱ(COMMIT, ROLLBACK) 082 Է, , ѹ ϱ(MERGE)083 (LOCK) ϱ084 SELECT FOR UPDATE ϱ085 Ͽ Էϱ086 Ͽ ϱ087 Ͽ ϱ088 Ͽ ġ089 ǹ ְ ϱ 1090 ǹ ְ ϱ 2091 ǹ ְ ϱ 3092 ǹ ְ ϱ 4093 Ϲ ̺ ϱ(CREATE TABLE)094 ӽ ̺ ϱ(CREATE TEMPORAY TABLE) 095 ܼϰ ϱ 1(VIEW)096 ܼϰ ϱ 2(VIEW)097 ˻ ӵ ̱(INDEX)098 ߺ ʴ ȣ (SEQUENE) 099 Ǽ ϱ 1(FLASHBACK QUERY)100 Ǽ ϱ 2(FLASHBACK TABLE)101 Ǽ ϱ 3(FLASHBACK DROP)102 Ǽ ϱ 4(FLASHBACK VERSION QUERY)103 Ǽ ϱ 5(FLASHBACK TRANSACTION QUERY)104 ǰ ̱ 1(PRIMARY KEY)105 ǰ ̱ 2(UNIQUE)106 ǰ ̱ 3(NOT NULL)107 ǰ ̱ 4(CHECK)108 ǰ ̱ 5(FOREIGN KEY)109 WITH ϱ 1(WITH ~ AS)110 WITH ϱ 2(SUBQUERY FACTORING)111 SQL ˰ Ǯ 1( 2 )112 SQL ˰ Ǯ 2( 1 ~ 9 )113 SQL ˰ Ǯ 3(ﰢ )114 SQL ˰ Ǯ 4(ﰢ )115 SQL ˰ Ǯ 5( )116 SQL ˰ Ǯ 6(簢 )117 SQL ˰ Ǯ 7(1 10 )118 SQL ˰ Ǯ 8(1 10 )119 SQL ˰ Ǯ 9(1 10 ¦ )120 SQL ˰ Ǯ 10(1 10 Ҽ )121 SQL ˰ Ǯ 11(ִ )122 SQL ˰ Ǯ 12(ּ )123 SQL ˰ Ǯ 13(Ÿ )124 SQL ˰ Ǯ 14(ī ˰)125 SQL ˰ Ǯ 15(Ϸ ڿ ϱ)PART 4 Ȱ롹 SQL 126 DB εϴ 127 Ƽ ⽺ ܾ ΰ? 128 Ƽ ⽺ ܾ ܾ ?129 ϴ ΰ?130 츮 ϱ б ΰ?131 ǰ ΰ? 132 ϴ Ҵ ΰ?133 ȭ ū ΰ?134 ȭ ū ΰ?135 ϴ ΰ?136 ġŲ Ҵ ΰ?137 迡 ٹ ð ΰ?138 ڿ ڰ ɸ ΰ?139 PL/SQL ϱ 1140 PL/SQL ϱ 2141 PL/SQL IF ϱ 1(IF ~ ELSE)142 PL/SQL IF ϱ 2(IF ~ ELSIF ~ ELSE)143 PL/SQL Basic Loop ϱ144 PL/SQL While Loop ϱ145 PL/SQL for Loop ϱ146 PL/SQL Loop ϱ147 PL/SQL Cursor ϱ(BASIC LOOP)148 PL/SQL Cursor ϱ(FOR LOOP)149 PL/SQL Cursor for loop ϱ150 ν ϱ151 Լ ϱ152 н ϱ 1(밪)153 н ϱ 2(ﰢ)154 н ϱ 3( Լ)155 н ϱ 4(α Լ)156 н ϱ 5()157 н ϱ 6()158 ϱ 1(հ)159 ϱ 2(߾Ӱ)160 ϱ 3(ֺ)161 ϱ 4(л ǥ)162 ϱ 5(л)163 ϱ 6()164 ϱ 7(Ȯ 1)165 ϱ 8(Ȯ 2)166 ϱ 9( )167 ϱ 10(Ժ)168 PL/SQL ˰ Ǯ 1(ﰢ )169 PL/SQL ˰ Ǯ 2(簢 )170 PL/SQL ˰ Ǯ 3(Ÿ )171 PL/SQL ˰ Ǯ 4(丮)172 PL/SQL ˰ Ǯ 5(ִ )173 PL/SQL ˰ Ǯ 6(ּ )174 PL/SQL ˰ Ǯ 7( )175 PL/SQL ˰ Ǯ 8( )176 PL/SQL ˰ Ǯ 9(Ž)177 PL/SQL ˰ Ǯ 10(ī ˰) 178 PL/SQL ˰ Ǯ 11(Ž ˰)PART 5 ǹ SQL ǹ 179 SQL ӽŷ ϱ 1(NAIVEBAYES)180 SQL ӽŷ ϱ 2(NAIVEBAYES)181 SQL ӽŷ ϱ 3(NAIVEBAYES)182 SQL ӽŷ ϱ 4(DECISION TREE)183 SQL ӽŷ ϱ 5(DECISION TREE)184 SQL ӽŷ ϱ 6(RANDOM FOREST)185 SQL ӽŷ ϱ 7(RANDOM FOREST)186 SQL ӽŷ ϱ 8(RANDOM FOREST)187 SQL ӽŷ ϱ (Ű)188 SQL ӽŷ ϱ 10(Ű)189 SQL ӽŷ ϱ 11(Ű)190 SQL ӽŷ ϱ 12(SUPPORT VECTOR MACHINE)191 SQL ӽŷ ϱ 13(SUPPORT VECTOR MACHINE)192 SQL ӽŷ ϱ 14(SUPPORT VECTOR MACHINE)193 SQL ӽŷ ϱ 15(REGRESSION)194 SQL ӽŷ ϱ 16(REGRESSION)195 SQL ӽŷ ϱ 17(Ļ )196 SQL ӽŷ ϱ 18(Ļ )197 SQL ӽŷ ϱ 19(APRIORI)198 SQL ӽŷ ϱ 20(APRIORI)199 SQL ӽŷ ϱ 21(K-MEANS)200 SQL ӽŷ ϱ 22(K-MEANS)APPENDIX η001 Kaggle ǿ ϱ 1002 Kaggle ǿ ϱ 2