05 November 2020
preps | erm | entities | relationships | sql
Value Added | daily
Class Schedule
Basics | sessions 01-03
- 13 Aug intro and clients | lecture | labs
- 20 Aug servers and command line | lecture | labs
- 27 Aug networks and protocols | lecture | labs
Web Development | sessions 04-07
- 03 Sep structural layer | lecture | labs
- 10 Sep presentational layer | lecture | labs
- 17 Sep using a structure | lecture | labs
- 24 Sep behavioral layer | lecture | labs
Dealing with Markup | sessions 08-09
Working with Data | sessions 10-13
- 15 Oct formulas, functions, vectors | lecture | labs
- 22 Oct data display | lecture | labs
- 29 Oct manipulate data sets | lecture | labs
- 05 Nov relational data bases | lecture | labs
Presentation | session 14
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
05 November lecture | preps | erm | entities | relationships | sql