| 学部・研究科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 | |
| 旧科目との重複履修Duplicate Subjects Taken Under Previous Class Title | |
| カテゴリー（2020年度以降入学者）Category (commenced 2020 onwards) | 300-level Advanced Courses（上級） |
| カテゴリー（2016～2019年度入学者）Category (commenced 2016-2019) | 300-level Advanced Courses Culture and Society |
【授業の概要と目的（何を学ぶか） / 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
※各回の授業形態は予定です。教員の指示に従ってください。
| 回 / No. | 各回の授業形態予定 / methods of teaching | テーマ / Theme | 内容 / Contents |
|---|---|---|---|
| 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.