Class Schedule

Week 1

What is Modeling? What are our Outcomes?
Data and Data Choices
Programming Review
Object Orientation
- Modeling an Object, Car
- Inheritance
- Relational Databases
- Sketching Historical Objects
How Databases and Applications Work
- Logic Separation, Model, View, Controller
- Our Focus:
  - Models (Designed in Schema, Data in Excel)
  - Views (Written in SQL)
Starting to work with Workbench
- Installation, creating a local dB
- How Schemata Work
- How Queries Work

Think About Project
- Historical
- What is Your Source?
- Special Collections
Reviewing Homework Models
Thinking About, Severan Coin Database
Python
- Review, Lists, Dictionaries, Functions
- Classes
  - Properties, Methods, Magic Methods
  - Web Scraping Example

Discussion Part 1: What are Data?
- What are the Contradictions?
- Limitations?
- Potentials?
Creating a Database
- Schema
- Forward Engineering
Your Sources....
- Presenting Your Source
- Troubleshooting Problems and Potentials Together

How a Full Stack Application Works
- Getting Help, Slack, ProgrammingHistorian, StackOverflow, Lynda
Your Sources (Continued)....
- Presenting Your Source
- Troubleshooting Problems and Potentials Together
Discussion: What are Data?
- What are the Contradictions?
- Limitations?
- Potentials?
- The Conservatism of Statistics
- Mapping and the Production of Power
SQL
- Running SQL Statements
- Whitespace and Semicolons
- Create Table, Insert Into, Alter Table, Update/Set
- Select
  - Column names, Where Statements
  - Distinct, Aggregates, Functions

Running a linux server, howto
- ubuntu
- apt / apt-get
- port-forwarding
- webmin
- x2go / lxde
Using Learning Resources
- W3 Schools Reference
- MySQLTutorial
Next Week's Homework
A Sample Database MySqlTutorial
- Joining Tables
- Filtering, Where Conditions
- Selecting Columns, Distinct, Union
- Views
Trying to Model, Severan Coin Database
- Coming Up with Tables
- Thinking About Data Entry with Views
- Homework