Database 2018-02 - Revision history

James: /* Lecture Plan */

2018-09-20T05:14:20Z

Lecture Plan

← Older revision		Revision as of 14:14, 20 September 2018
Line 94:		Line 94:
	\| style="vertical-align: top;"\| '''SQL Introduction Part I'''		\| style="vertical-align: top;"\| '''SQL Introduction Part I'''
	[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_SQL_p1.pptx pptx] ] [ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_SQL_p1.pdf pdf] ]		[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_SQL_p1.pptx pptx] ] [ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_SQL_p1.pdf pdf] ]
	[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_worksheet.ipynb Notebook] ]		[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_worksheet.ipynb Notebook] ][ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_worksheet_eng.ipynb English] ]
	<br> '''Worksheet:'''		<br> '''Worksheet:'''
	<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/dataset_1.db DB]		<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/dataset_1.db DB]

James: /* Lecture Plan */

2018-09-20T05:05:36Z

Lecture Plan

← Older revision		Revision as of 14:05, 20 September 2018
Line 102:		Line 102:
	\| style="vertical-align: top;"\| Ch. 6		\| style="vertical-align: top;"\| Ch. 6
	\| style="vertical-align: top;"\| '''Assignment 1 '''		\| style="vertical-align: top;"\| '''Assignment 1 '''
	<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/HW1.ipynb Assignment 1]		<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/HW1.ipynb Assignment 1] [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/en/HW1.ipynb [English]]
	<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/correct_output.txt Correct Output]		<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/correct_output.txt Correct Output] [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/en/correct_output.txt [English]]
	<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/flights.db.zip DB for the assignment (must be unzipped)]		<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/flights.db.zip DB for the assignment (must be unzipped)] [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/en/flights.db.zip [English]]
	<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/sanity_check.py Sanity checker script (run on the terminal)]		<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/sanity_check.py Sanity checker script (run on the terminal)] [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/en/sanity_check.py [English]]
	<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/submit.py Answer Template]		<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/submit.py Answer Template] [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/en/submit.py [English]]
	<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/submission_instructions.txt Instructions on submitting the assignment]		<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/submission_instructions.txt Instructions on submitting the assignment] [http://open.gnu.ac.kr/lecslides/2018-2-DB/Assignments1/en/submission_instructions.txt [English]]

	<!-- Topic 3 -->		<!-- Topic 3 -->

James: /* Git */

2018-09-06T07:08:56Z

Git

← Older revision		Revision as of 16:08, 6 September 2018
Line 334:		Line 334:
	* you can download the course material from [https://github.com/resourceful/lecture_db here]		* you can download the course material from [https://github.com/resourceful/lecture_db here]
	* If you want the up-to-date version of the course material, checkout the course repository from the <code>git</code> by typing the following command		* If you want the up-to-date version of the course material, checkout the course repository from the <code>git</code> by typing the following command
	** <code> git ~~checkout~~ https://github.com/resourceful/lecture_db YourDestination </code>		** <code> git clone https://github.com/resourceful/lecture_db YourDestination </code>

	==== IPython-SQL ====		==== IPython-SQL ====

James: /* Evaluation */

2018-09-06T05:19:58Z

Evaluation

← Older revision		Revision as of 14:19, 6 September 2018
Line 56:		Line 56:
	\| Assignments \|\| 10 \|\| Midterm \|\| 30		\| Assignments \|\| 10 \|\| Midterm \|\| 30
	\|-		\|-
	\| Project \|\| 20 \|\| Final \|\| 30		\| Project \|\| 10 \|\| Final \|\| 30
	\|-		\|-
	\| \|\| \|\| Total \|\| 100%		\| \|\| \|\| Total \|\| 100%

James: /* Getting the latest course materials */

2018-09-06T04:54:36Z

Getting the latest course materials

← Older revision		Revision as of 13:54, 6 September 2018
Line 352:		Line 352:
	You can always access the latest course materials on the course website. You can download all at once and keep them synced by using git. To get started with this, run:		You can always access the latest course materials on the course website. You can download all at once and keep them synced by using git. To get started with this, run:

	<code> git clone https://github.com/resourceful/lecture_db </code>		<code> git clone https://github.com/resourceful/lecture_db YourDestination </code>

	Now you should have all the materials in ''Database''; to get the latest version, run the following command in the repository.		Now you should have all the materials in ''Database''; to get the latest version, run the following command in the repository.

James: /* Git */

2018-09-06T04:53:37Z

Git

← Older revision		Revision as of 13:53, 6 September 2018
Line 334:		Line 334:
	* you can download the course material from [https://github.com/resourceful/lecture_db here]		* you can download the course material from [https://github.com/resourceful/lecture_db here]
	* If you want the up-to-date version of the course material, checkout the course repository from the <code>git</code> by typing the following command		* If you want the up-to-date version of the course material, checkout the course repository from the <code>git</code> by typing the following command
	** <code> git checkout https://github.com/resourceful/lecture_db </code>		** <code> git checkout https://github.com/resourceful/lecture_db YourDestination </code>

	==== IPython-SQL ====		==== IPython-SQL ====

James: /* Lecture Plan */

2018-09-04T05:05:56Z

Lecture Plan

← Older revision		Revision as of 14:05, 4 September 2018
Line 236:		Line 236:
	\| style="text-align:center;" \| 12		\| style="text-align:center;" \| 12
	\| style="vertical-align: top;"\| '''Join part 1'''		\| style="vertical-align: top;"\| '''Join part 1'''
	[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day12/~~Day_12_Joins_p1~~.pptx pptx] ] [ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day12/~~Day_12_Joins_p1~~.pdf pdf] ]		[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day12/Day12_Joins_p1.pptx pptx] ] [ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day12/Day12_Joins_p1.pdf pdf] ]
	<br> '''Worksheet:'''		<br> '''Worksheet:'''
	\| style="vertical-align: top;"\| Ch. 15		\| style="vertical-align: top;"\| Ch. 15

James: /* Lecture Plan */

2018-09-04T05:04:27Z

Lecture Plan

← Older revision		Revision as of 14:04, 4 September 2018
Line 246:		Line 246:
	\| style="text-align:center;" \| 13		\| style="text-align:center;" \| 13
	\| style="vertical-align: top;"\| '''Join part 1'''		\| style="vertical-align: top;"\| '''Join part 1'''
	[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day13/~~Day_13_Joins_p2~~.pptx pptx] ] [ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day13/~~Day_13_Joins_p2~~.pdf pdf] ]		[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day13/Day13_Joins_p2.pptx pptx] ] [ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day13/Day13_Joins_p2.pdf pdf] ]
	<br> '''Worksheet:'''		<br> '''Worksheet:'''
	\| style="vertical-align: top;"\| Ch. 15		\| style="vertical-align: top;"\| Ch. 15

James: /* Lecture Plan */

2018-09-04T05:02:51Z

Lecture Plan

← Older revision		Revision as of 14:02, 4 September 2018
Line 80:		Line 80:
	\| style="text-align:center;" \| 1		\| style="text-align:center;" \| 1
	\| style="vertical-align: top;"\| '''Course Overview and Database History'''		\| style="vertical-align: top;"\| '''Course Overview and Database History'''
	[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day01/~~Day01_intro~~.pptx pptx] ] [ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day01/~~Day01_intro~~.pdf pdf] ]		[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day01/Day01_Intro.pptx pptx] ] [ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day01/Day01_Intro.pdf pdf] ]
	<br> '''Worksheet:'''		<br> '''Worksheet:'''
	<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day01/dataset_1.db DB]		<br> [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day01/dataset_1.db DB]

James: /* Lecture Plan */

2018-08-20T03:41:50Z

Lecture Plan

← Older revision		Revision as of 12:41, 20 August 2018
Line 92:		Line 92:
	\|-		\|-
	\| style="text-align:center;" \| 2		\| style="text-align:center;" \| 2
	\| style="vertical-align: top;"\| ''SQL Introduction Part I'''		\| style="vertical-align: top;"\| '''SQL Introduction Part I'''
	[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_SQL_p1.pptx pptx] ] [ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_SQL_p1.pdf pdf] ]		[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_SQL_p1.pptx pptx] ] [ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_SQL_p1.pdf pdf] ]
	[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_worksheet.ipynb Notebook] ]		[ [http://open.gnu.ac.kr/lecslides/2018-2-DB/Lectures/Day02/Day02_worksheet.ipynb Notebook] ]