<HTML>
<HEAD>
  <TITLE>DataBase's Home</TITLE>
  <link rel="stylesheet" type="text/css" href="/style/style.css" title="style">
</HEAD>
<BODY BGCOLOR="#ffffFF" LINK="#0000ff" VLINK="#008000">
<A HREF="/yoonyc/yoon-col3.gif"><IMG SRC="/yoonyc/yoon-cartoon.gif" BORDER=0></A>
<HR noshade size=4>
<H2>
DataBase's Home
</H2>


<DL>

<DT> <IMG SRC="/icon/cydot.gif" ALT="button"> <a href="http://www.postgresql.org/"> PostgreSQL</a>
<font size=-1>
<dd> <a href="http://www.postgresql.org/download/"> The postgreSQL download</a> /
<dd> <a href="./postgresql/postgresql-9.2-A4.pdf"> The postgreSQL 9.2 user manual (full)</a> /
<dd> <a href="./postgresql/postgresql-7.4.2-A4.pdf"> The postgreSQL 7.4 user manual (full)</a> / <a href="./postgresql/postgresql-7.4.5/doc/src/FAQ/FAQ.html"> PostgreSQL 7.4.5 (FAQ)</a> / <a href="./postgresql/postgres.html"> Postgres95 User Manual (korean)</a> / <a href="./postgresql/db-start.html">PostgreSQL 7.4 접속방법</a> /
</font>

<DT> <IMG SRC="/icon/cydot.gif" ALT="button"> <a href="http://www.mariadb.org/"> MySQL</a>
<font size=-1>
<dd> MySQL-5.7.12 server on Windows ( <a href="./mysql/mysql.on.windows/mysql-installer-community-5.7.12.0.msi">file</a> / <a href="./mysql/mysql.on.windows/mysql-server-on-windows-install.pdf">install guide</a> by http://blog.naver.com/littletrace/220332880010 )
<dd> <a href="http://downloads.mysql.com/archives.php">The MySQL download</a>
<dd> <a href="./mysql/refman-5.5-en.a4.pdf"> MySQL 5.5 user manual (full)</a> / <a href="./mysql/MySQL-Manual-5.0-tutorial.pdf"> MySQL 5.0 Tutorial</a> /
<dd> <a href="./mysql/MySQL-Manual-5.0-ch3-tutorial.pdf"> MySQL 5.* user manual (ch.3)</a> /<a href="http://www.mysqlkorea.com/sub.html?mcode=manual&scode=01&m_no=20109&cat1=3&cat2=0&cat3=0&lang=k">MySQL 5.0 매뉴얼</a> / <a href="./mysql/mysql-install">MySQL 4.0 설치방법</a> / <a href="./mysql/mysql-start.html">MySQL 4.0 접속방법</a> / <a href="http://www.mysqlkorea.com"> MySQL Korea</a> /
</font>

<DT> <IMG SRC="/icon/cydot.gif" ALT="button"> <a href="http://www.mysql.org/"> mariadb</a>
<font size=-1>
<dd> <a href="https://mariadb.com/kb/en/library/training-tutorials/"> MariaDB Training & Tutorial </a> 
<dd> SQL &#8594 <a href="./mysql/basic-sql/0-mysql.html">Core Instructions for MariaDB on Linux</a>, 
</font>

<DT> <IMG SRC="/icon/cydot.gif" ALT="button"> <a href="http://www.mysql.org/"> MySQL 5.X</a>, <font size=-1 color=#bebebe>글로벌출판사 </font>
<font size=-1>
<dd> <b>Data w/ Korean</b> &#8594 <a href="./data/data.sql">data.sql</a> / <a href="./data/diplomas.sql">diplomas.sql</a> / <a href="./data/table.sql">table.sql</a>
<dd> <b>Data w/ English</b> &#8594 <a href="./data/e-data.sql">data.sql</a> / <a href="./data/e-diplomas.sql">diplomas.sql</a> / <a href="./data/e-table.sql">table.sql</a>
<dd> <b>TextBook</b> &#8594 
<a href="./mysql/mysql-5.x/1-intro.htm"> 1장. Introduction</a> / 
<a href="./mysql/mysql-5.x/2-student-db.htm"> 2장. 학사관리 예제 DATABASE </a> / 
<a href="./mysql/mysql-5.x/3-install.htm"> 3장. MySQL 5.x 설치와 정보 </a> / 
<a href="./mysql/mysql-5.x/4-db-table.htm"> 4장. 데이터베이스와 테이블 </a> / 
<a href="./mysql/mysql-5.x/5-create-table.htm"> 5장. 테이블 생성 </a> / 
<a href="./mysql/mysql-5.x/6-select1.htm"> 6장. select 명령문과 공통요소 </a> / 
<a href="./mysql/mysql-5.x/7-select-clause.htm"> 7장. SELECT명령문의 절(Clause) </a> / 
<a href="./mysql/mysql-5.x/8-select-from.htm"> 8장. SELECT명령문 : FROM 절 </a> / 
<a href="./mysql/mysql-5.x/9-select-where.htm"> 9장. SELECT명령문 : WHERE 절 </a> / 
<a href="./mysql/mysql-5.x/10-select-statistics.htm"> 10장. SELECT명령문 : 통계함수 </a> / 
<a href="./mysql/mysql-5.x/11-groupby.htm"> 11장. GROUP BY와 HAVING </a> / 
<a href="./mysql/mysql-5.x/12-orderby.htm"> 12장. SELECT 명령문: ORDER BY절 </a> / 
<a href="./mysql/mysql-5.x/13-union.htm"> 13장. SELECT 명령문의 조합 </a> / 
<a href="./mysql/mysql-5.x/14-subquery.htm"> 14장. 부속 질의어 </a> / 
<a href="./mysql/mysql-5.x/15-join.htm"> 15장. SELECT 명령문: 조인(JOIN) </a> / 
<a href="./mysql/mysql-5.x/16-insert.htm"> 16장. 테이블의 변경 </a> / 
<a href="./mysql/mysql-5.x/17-index.htm"> 17장. 인덱스의 사용 </a> / 
<a href="./mysql/mysql-5.x/18-view.htm"> 18장. 뷰(View) </a> / 
<a href="./mysql/mysql-5.x/19-transaction.htm"> 19장. 트랜잭션과 락(LOCK)  </a> / 
<a href="./mysql/mysql-5.x/20-sql-optimum.htm"> 20장. SQL명령문의 최적화 </a> / 
<a href="./mysql/mysql-5.x/21-db-guide.htm"> 21장. 데이터베이스 설계지침 </a> / 
<a href="./mysql/mysql-5.x/22-utility.htm"> 22장. MySQL 유틸리티 </a> / 
<a href="./mysql/mysql-5.x/23-trigger.htm"> 23장. Trigger </a> / 
</font>

<DT> <IMG SRC="/icon/cydot.gif" ALT="button"> <a href="http://www.mysql.org/"> 데이터베이스설계및구축</a>, <font size=-1 color=#bebebe>생능출판사 </font>
<font size=-1>
<dd> <b>TextBook</b> &#8594 
<a href="./lect/0-introduction.htm"> Introduction</a> / 
<a href="./lect/1-db.htm"> DATABASE 개요</a> / 
<a href="./lect/2-db.design.htm"> 정보시스템 구축_DB설계 </a> / 
<a href="./lect/3-db.modelling.htm"> 모델링 개념 </a> / 
<a href="./lect/5-analysis.htm"> 업무분석방법 </a> / 
<a href="./lect/6-entity.htm"> 엔티티의 정의 </a> / 

<DT> <IMG SRC="/icon/cydot.gif" ALT="button"> 1998~2008 : <a href="./db98-3q.html">Quiz-98</a>, <a href="./db98-32.html">MidTerm</a>, <a href="./db99-3a.html">Quiz-99</a>, <a href="./db04-1.htm">Quiz-04</a>, <a href="./db07-42.pdf">Quiz-07a</a>, <a href="./db07-43.pdf">Quiz-07b</a>, <a href="./db08-31.pdf">Quiz-08a</a>, <a href="./db08-32.pdf">Quiz-08b</a>
<font size=-1>
<dd> 문제를 개인이 선호하는 W/P를 이용하여 답안까지 추가하여 작성후 문제에 제시한 이메일로 제출 할 것!
</font>

<DT> <IMG SRC="/icon/cydot.gif" ALT="button"> 2013 &#8594 <a href="./db13a.pdf">Quiz-13a</a>, <a href="./db13-31.pdf">Quiz-4/3</a>, <a href="./db13-32.pdf">Quiz-4/7</a>, <a href="./db13-33.pdf">Quiz-4/17</a>, <a href="./db13-34.pdf">Quiz-5/15</a>, <a href="./db13-35.pdf">Quiz-6/17</a>

<DT> <IMG SRC="/icon/cydot.gif" ALT="button"> 2014 &#8594 <a href="./db1401-33a.docx">Quiz-5/29</a>, <a href="./db1401-34.docx">Quiz-6/12</a>, <a href="./db1402-31.docx">Quiz-10/27</a>, <a href="./db1402-32.docx">Quiz-12/15</a>, 

<DT> <IMG SRC="/icon/cydot.gif" ALT="button"> 2015 &#8594 <a href="./db1501-31.pdf">Quiz-4/21</a>, 

<DT> <IMG SRC="/icon/cydot.gif" ALT="button"> 
<font size=-1>
<dd> 문제를 개인이 선호하는 W/P를 이용하여 답안까지 추가하여 작성후 제시된 파일로 변환시킨 후에 문제에 제시한 이메일로 제출 할 것!<br>
만약 제출 답안지에 바이러스 발견시에는 감점 처리 하겠음!!!
</font>

<!-- 
<DT> <IMG SRC="/icon/cydot.gif" ALT="button"> <a href="/yoonyc/cyberschoolroom/bulletin/seminar-db98-2.html">세미나</a> 준비를 철저히 할 것.(11/6~12/4)
-->
</DL>


<HR>
<li>  Return to CyberSchoolRoom's <a href="http://cyber.woosuk.ac.kr"> home</a>.
<li>  Return to Y.Yoon's <a href="/yoonyc/index-yoonyc.html"> home</a>. 

<CENTER><font size=-1>
     <script language="JavaScript">
        <!--
           document.write("Last modified : ");
           document.write(document.lastModified);
        //-->
     </script><br>
  <!-- This page created by <b><A HREF="/yoonyc/index-yoonyc.html"> Y.C.Yoon</a></b><br> -->
   (c) <A HREF="/yoonyc/index-yoonyc.html"> Y.C.Yoon</a>, 1996, All rights reserved
 </i>
</font></CENTER>

</BODY>
</HTML>