Faculty/Graduate school Department 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
SDGs CP
Urban Design CP
Diversity CP
Learning for the Future CP
Carbon Neutral CP
Chiyoda Campus Consortium
Duplicate Subjects Taken Under Previous Class Title
Category (commenced 2024 onwards)
Category (commenced 2020-2023) 300-level Advanced Courses(上級)
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 オンライン/onlineIntroduction Introduction
2 対面/face to faceChapter 1: Introduction to database This class focuses on introducing databases and RDBMS.
3 対面/face to faceChapter 2:
Introduction to SQL (1)
This class introduces SQL.
4 対面/face to faceChapter 3: Introduction to SQL (2) This class covers basic grammar of SQL.
5 対面/face to faceChapter 4: Using SQL This class focuses on practicing multiple ways to utilize SQL.
6 対面/face to faceChapter 5: Building database (1) This class helps students build databases based on the actual dataset.
7 対面/face to faceChapter 6: Building database (2) This class helps students build databases and understand SQL to manage MySQL.
8 対面/face to faceReview & 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 faceChapter 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 faceChapter 8: Python and MySQL (1) This class focuses on learning Python and MySQL through pattern.
11 対面/face to faceChapter 9: Python and MySQL (2) This class provides students with multiple examples to get used to Python and MySQL.
12 対面/face to faceChapter 10: Python and MySQL (3) This class covers pandas library, pymysql, and Foreign Key.
13 対面/face to faceChapter 11: Data analysis and SQL This class helps students analyze the actual dataset using SQL.
14 対面/face to faceFinal 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.