|
|
CIS 2210 - Database Management and Design
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
skvincent@gmail.com
Copyright © 2018, 2019 Steve Vincent
URL:
http://stevevincent.info/index.html
Legend: Blue Links are unvisited, Burgundy Links are visited.
: lecture
section notes
: lab
section notes
:
assignments, outlines
:
review/study guides
: handouts
: WWW
references
|