Database Design & Implementation

AI悦创原创2023年9月23日大约 4 分钟...约 1147 字

Department of Computer Science
New York University

Schedule

Date	Class	Topics	Notes	Helpful resources	Quiz due	Exercise due
9/5	1	Welcome	Course intro	Syllabus
9/7	2	Python	- Discord for Education - Python	Videos: - Python crash course - Set up Visual Studio Code for Python programming Python for Everyone (py4e): - Variables - Conditionals - Functions - Iterations - Strings - Lists - Dictionaries - Tuples	Intake	- Complete consent form - Join Discord - Create GitHub account
9/12	3	Plain text data formats	Plain text data formats	- Video: Plain-text data formats - py4e: - Files - Text files code examples	Python	- Set up Python - Contemporary issues exercise
9/14	4	Data munging	- Text files in Python - Example Python code	Accessing O’Reilly Safari e-books Big Data Handbook (bdh): - Does This Data Smell Funny? - Data Lurking in Plain Sight	Text files
9/19	5	Workshop - raw data munging	Workshop - raw data munging		Data munging
9/21	6	Spreadsheets	Spreadsheets
9/26	7	Workshop - spreadsheets	Workshop - spreadsheets	Vicky Rampin’s slides		Workshop - raw data munging
9/28	8	SQL CRUD	SQLite intro	Using SQLite: - What is SQLite? - Uses of SQLite - Building and Installing SQLite (only Precompiled Distributions and An sqlite3 Primer) - The SQL Language - The SELECT Command	Spreadsheets
10/3	9	SQL joins	- SQL joins - SQL inner joins - SQL left, right, and reflexive joins	SQL joins example code	SQL CRUD	Workshop - spreadsheets
10/5	10	Workshop - SQL	Workshop - SQL		SQL joins
10/10	n/a	no class (Legislative Day)
10/12	11	Normalization	Normalization	- A Simple Guide to Five Normal Forms in Relational Database Theory - Database Design, Chapter 12
10/17	12	Entity-relationship diagrams	Entity-Relationship Diagrams	Relational Database Design and Implementation: - Chapter 3 - Why Good Design Matters - Chapter 4 - Entities and Relationships - Chapter 5 - The Relational Data Model	Normalization	Workshop - SQL
10/19	n/a	no class (Prof. out)
10/24	13	Workshop - database design	Workshop - database design		Entity-Relationship Diagrams
10/26	14	Review	Exam 1 review	Exam Practice: - Quiz - GitHub Repository
10/31	15	Exam 1				Workshop - database design
11/2	16	MongoDB CRUD	- MongoDB setup - MongoDB CRUD	Video: MongoDB setup NYU CIMS documentation: - MongoDB Database Management on CIMS - Accessing MongoDB on CIMS MongoDB documentation: - MongoDB CRUD Operations - MongoDB db.collection.find()
11/7	17	MongoDB CRUD	MongoDB aggregation	MongoDB documentation: - MongoDB Data Model Design - MongoDB Data Model Examples and Patterns
11/9	18	Workshop - MongoDB	Workshop - MongoDB		MongoDB CRUD
11/14	19	Web apps	- The Web - Intro to HTML
11/16	20	Web apps	Pymongo & flask	Flask & pymongo documentation: - Flask Quickstart - Pymongo tutorial		Workshop - MongoDB
11/21	21	Workshop - web apps	Workshop - Web app		Web apps
11/23	n/a	no class (Thanksgiving)
11/28	22	Jupyter notebooks	Jupyter Notebooks
11/30	23	Pandas	- Pandas	- 10 minutes to Pandas - Example Jupyter notebooks
12/5	24	Data visualization				Workshop - web app
12/7	25	Workshop - pandas	Workshop - pandas		Pandas
12/12	26	Review	Exam 2 review			Workshop - pandas (No late work accepted beyond this date.)
12/14	n/a	no class (Prof out)
TBD	27	Exam 2

Addenda

Material that is not currently included in the course, but may be of interest to some:

Date	Class	Topics	Notes	Helpful resources	Quiz	Exercise due
n/a	n/a	Blockchain	Blockchain slides	- Cryptography code examples	Blockchain

Copyright

All content herein is copyrighted, shared under the GNU General Public License, Version 3.

欢迎关注我公众号：AI悦创，有更多更好玩的等你发现！

公众号：AI悦创【二维码】

AI悦创·编程一对一

AI悦创·推出辅导班啦，包括「Python 语言辅导班、C++ 辅导班、java 辅导班、算法/数据结构辅导班、少儿编程、pygame 游戏开发」，全部都是一对一教学：一对一辅导 + 一对一答疑 + 布置作业 + 项目实践等。当然，还有线下线上摄影课程、Photoshop、Premiere 一对一教学、QQ、微信在线，随时响应！微信：Jiabcdefh

C++ 信息奥赛题解，长期更新！长期招收一对一中小学信息奥赛集训，莆田、厦门地区有机会线下上门，其他地区线上。微信：Jiabcdefh

方法一：QQ

方法二：微信：Jiabcdefh