GISDepartment of Global and Interdisciplinary Studies
FRI300ZA（情報学フロンティア / Frontiers of informatics 300）Database UtilizationDatabase Utilization
Youyung Hyun
授業コードなどClass code etc
| 学部・研究科Faculty/Graduate school | GISDepartment of Global and Interdisciplinary Studies |
| 添付ファイル名Attached documents | |
| 年度Year | 2023 |
| 授業コードClass code | A6338 |
| 旧授業コードPrevious Class code | |
| 旧科目名Previous Class title | |
| 開講時期Term | 秋学期授業/Fall |
| 曜日・時限Day/Period | 火3/Tue.3 |
| 科目種別Class Type | |
| キャンパスCampus | 市ヶ谷 / Ichigaya |
| 教室名称Classroom name | 市外濠‐S603 |
| 配当年次Grade | 3～4 |
| 単位数Credit(s) | 2 |
| 備考（履修条件等）Notes | |
| 他学部公開科目Open Program | |
| 他学部公開（履修条件等）Open Program (Notes) | |
| グローバル・オープン科目Global Open Program | |
| 成績優秀者の他学部科目履修制度対象Interdepartmental class taking system for Academic Achievers | ○ |
| 成績優秀者の他学部科目履修（履修条件等）Interdepartmental class taking system for Academic Achievers (Notes) | 制度ウェブサイトの3．科目別の注意事項(1)GIS主催科目の履修上の注意を参照すること。 |
| 実務経験のある教員による授業科目Class taught by instructors with practical experience | |
| SDGsCPSDGs CP | |
| アーバンデザインCPUrban Design CP | |
| ダイバーシティCPDiversity CP | |
| 未来教室CPLearning for the Future CP | |
| カーボンニュートラルCPCarbon Neutral CP | |
| 千代田コンソ単位互換提供（他大学向け）Chiyoda Campus Consortium | |
| 旧科目との重複履修Duplicate Subjects Taken Under Previous Class Title | |
| カテゴリー（2024年度以降入学者）Category (commenced 2024 onwards) | |
| カテゴリー（2020～2023年度入学者）Category (commenced 2020-2023) | 300-level Advanced Courses（上級） |
| カテゴリー（2016～2019年度入学者）Category (commenced 2016-2019) |
300-level Advanced Courses Culture and Society |
すべて開くShow all
すべて閉じるHide All
授業の概要と目的（何を学ぶか）Outline and objectives
This course aims at understanding database and SQL. Through lectures and actual practices, students will learn how to build and utilize database.
到達目標Goal
By participating lectures and actual practices, students can (1) understand and implement crawling and MySQL, (2) implement programs using SQL and learn how to use MySQL using Python, and (3) utilize database on their own.
この授業を履修することで学部等のディプロマポリシーに示されたどの能力を習得することができるか（該当授業科目と学位授与方針に明示された学習成果との関連）Which item of the diploma policy will be obtained by taking this class?
Will be able to gain “DP 1”, “DP 2”, “DP 3”, and “DP 4”.
授業で使用する言語Default language used in class
英語 / English
授業の進め方と方法Method(s)（学期の途中で変更になる場合には、別途提示します。 /If the Method(s) is changed, we will announce the details of any changes. ）
This course will proceed with lectures, actual practices, and Q&A sessions (including individual instructions if necessary). Students are required to review what they have learned in the last class and to take the mini test every week about content of the last class.
At the beginning of every class, feedback for the previous class is given, and a brief review will be conducted.
アクティブラーニング（グループディスカッション、ディベート等）の実施Active learning in class (Group discussion, Debate.etc.)
あり / Yes
フィールドワーク（学外での実習等）の実施Fieldwork in class
あり / Yes
授業計画Schedule
授業形態/methods of teaching：対面/face to face
※各回の授業形態は予定です。教員の指示に従ってください。
1[オンライン/online]：Introduction
Introduction
2[対面/face to face]：Chapter 1: Introduction to database
This class focuses on introducing databases and RDBMS.
3[対面/face to face]：Chapter 2:
Introduction to SQL (1)
This class introduces SQL.
4[対面/face to face]：Chapter 3: Introduction to SQL (2)
This class covers basic grammar of SQL.
5[対面/face to face]：Chapter 4: Using SQL
This class focuses on practicing multiple ways to utilize SQL.
6[対面/face to face]：Chapter 5: Building database (1)
This class helps students build databases based on the actual dataset.
7[対面/face to face]：Chapter 6: Building database (2)
This class helps students build databases and understand SQL to manage MySQL.
8[対面/face to face]：Review & Simulation
Students will learn what the class has covered during the first half of the semester, and students will take a simple simulation test.
9[対面/face to face]：Chapter 7: Introduction to Python
This class focuses on introduction of Python, including how to use library, installation of pymysql, and so on.
10[対面/face to face]：Chapter 8: Python and MySQL (1)
This class focuses on learning Python and MySQL through pattern.
11[対面/face to face]：Chapter 9: Python and MySQL (2)
This class provides students with multiple examples to get used to Python and MySQL.
12[対面/face to face]：Chapter 10: Python and MySQL (3)
This class covers pandas library, pymysql, and Foreign Key.
13[対面/face to face]：Chapter 11: Data analysis and SQL
This class helps students analyze the actual dataset using SQL.
14[対面/face to face]：Final Exam & Wrap-up
The instructor will summarize the content throughout the semester, and students will take a final exam.
授業時間外の学習（準備学習・復習・宿題等）Work to be done outside of class (preparation, etc.)
Preparatory study and review time for this class are 2 hours each.
テキスト（教科書）Textbooks
Handouts and reading materials will be provided by a instructor.
参考書References
1. Walter Shields (2019) SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL. ClydeBank Media LLC.
2. Anthony DeBarros (2022) Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data. No Starch Press
成績評価の方法と基準Grading criteria
Participation (20%); Weekly mini test (20%); Simulation (20%); Final exam (40%).
学生の意見等からの気づきChanges following student comments
Not applicable.
学生が準備すべき機器他Equipment student needs to prepare
Laptop (*downloaded with ’anaconda’, ’jupyter notebook’, 'SQL')
その他の重要事項Others
This course is highly recommended to students who already took Introduction to Programming and/or Big Data and Analytics.
Prerequisite
None.