CIS 2210 - Database Management and Design

Text Image

Link to Publisher's Site

Lesson 1: Chapter 1, Database Systems
Lesson 2: Chapters 2 and 3, Data models and the Relational database model
Lesson 3: Chapters 4 and 5, Entity Relationship Modeling and Advanced Data Modeling
Lesson 4: Chapter 6, Normalization
Lesson 5: Chapter 9, Database Design
Lesson 6: Chapter 7, Introduction to Structured Query Language (SQL)
Lesson 7: Chapter 8, Advanced SQL
Lesson 8: Chapter 15
Review for the mid-term test
Lesson 9a: Review of Basic SQL
Lesson 9b: Review of Second Level SQL
Lesson 11: Chapter 16 (and some SQL)
Lesson 12: Chapter 13
Lesson 13: Chapter 14
Review for the end-of-term test

Other useful web sites:
SQLcourse - lessons and practice with SQL
MySQL Online Manual - the online manual for the MySQL product
MySQLTutorial - lessons and practice with MySQL, including how to load a database in the MySQL GUI
MySQL Online - an interface that accepts longer MySQL scripts, letting you create and manipulate tables online
Beginners Guide to SQL at the Udemy blog site - introduction to SQL, and many other subjects

Steve Vincent

Copyright 2018, 2019 Steve Vincent

Legend: Blue Links are unvisited, Burgundy Links are visited.
: lecture section notes
: lab section notes
: assignments, outlines
: review/study guides
: handouts
: WWW references