20 April 2021
preps | erm | entities | relationships | sql
Value Added | daily
Class Schedule
Basics | sessions 01-03
- 19 Jan intro and clients | lecture | labs
- 26 Jan servers and command line | lecture | labs
- 02 Feb networks and protocols | lecture | labs
Web Development | sessions 04-08
- 09 Feb structural layer | lecture | labs
- 16 Feb presentational layer | lecture | labs
- 23 Feb using a structure | lecture | labs
- 02 Mar behavioral layer | lecture | labs
- 09 Mar design thoughts | lecture | labs
Dealing with Markup | sessions 09-10
Working with data | sessions 11-14
- 30 Mar formulas, functions, vectors | lecture | labs
- 06 Apr data display | lecture | labs
- 13 Apr manipulate data sets | lecture | labs
- 20 Apr relational data bases | lecture | labs
Presentations | sessions 15-16
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | syllabus | contact | grades
We will be considering relational databases,
so do these readings to prepare yourselves for Entity Relationship Modeling
and Structured Query Language terminology.
Some Relational Database Fundamentals
back to top
It wouldn't hurt to read
- the Wikipedia entry on Relational Databases for background
- and Microsoft's Database design basics
Read this linked article twice
- Read it prior to the first relational database session so you will have an idea about why relational databases are useful.
- Then read it again after we've discussed relationships
Glance over the Structured Query Language tutorial at W3Schools.
We will introduce SQL and build a few SQL queries, so this tutorial is something you might want to come back to in the future.
back to top
20 April lecture | preps | erm | entities | relationships | sql