| Buffalo
State College
Databases and the Data Science Information Life Cycle, DSA 610
Course Description (from the College):
Introduction to a “big picture” understanding of data flow for strategic,
data-driven decision making, including data storage, data organization,
data gathering and preparation, exploratory data analysis, and meaningful
visualizations and communication. Includes hands-on practice.. (3 credits)
Syllabus -- in Word format
Homework
Important Dates
Final Project -- Due Monday, May 10th
more detailed schedule in the syllabus
Email List
via Blackboard
Announcements:
Buffalo State Office:
My BSC voicemail:
My BSC email: mccallb@buffalostate.edu
Office Hours: by appt
Answer
Keys
Homeworks to be
Turned in
Homework #1 -- Data
Homework #2 -- Data
Homework #3
Homework #4 -- Data
Homework #5 -- Data
Homework #6 -- Data
Homework #7 -- Data
Homework #8 -- Data
Homework #9 -- Data
Practice
Labs & Class Notes
Projects
Project #1 -- Data
Project #2 -- Data
Project #3 -- Data
Final
Project -- Data set options posted in Blackboard
Handouts
Links:
Data Lifecycle
Data Lifecycle Management
The Lifecycle of Data
16-Step Lifecycle
Data
Lifecycle, Best Practices
Data Lifecycle Management (DLM)
Data
Analytics Lifecycle
Data Protection and Information Lifecycle Management
The
Data Science Lifecycle
Excel Easy
Data Analysis in
Excel
Excel 2016+
Microsoft Excel Video Training
SQL Tutorial
Learn SQL
SQL Basics for
Beginners
SQLite Tutorial
Beginners' Guide to SQLite
SQL Query Cheet Sheet
SQL
Tutorial
SQL Tutorial for
Beginners
Interactive SQL Course
10+ Free Python Books
Python for
Beginners
Learn Python
Which Library should I use for my Python Dashboard?
Best Python Data Visualization Libraries
Big Data: How is it generated?
Data Capture
Data Classification
Types of Data Classification
Data Classification
Ethics of Data Collection
The Murky Ethics of Data Gathering in a Post-Cambridge Analytica World
What is Data
Validation?
Data Privacy
5 Things to Know about Data Privacy
Data Storage
Data Storage: Emerging Technologies
Data Lakes vs. Data Warehouses
Data Security
Most Common Passwords
Spreadsheets vs. Databases
Relational Databases
Definition and Overview of ODBMS
Object-Oriented Databases and Advantages
JSON Databases
JSON
Interchange Standard
JSON vs. XML
What is JSON?
Importing XML into Pandas
Data Maintenance vs. Data Cleansing
Tips to Maintaining Your Data
Data Management
History of Data Management
Data Management: A Cheat Sheet
Stats NZ
Public
Datasets (List of Sources)
Color Brewer (for maps)
Color Brewer for
Python
PDF Graph Paper
I Will Derive song
How to
draw Greek
GraphCalc
Free Online Math
Courses
Mathnotes
Coding
|
