SQL 1: Introduction to SQL (lab)

Lecture about SQL, databases. Work through Chapter 2.

Topics: SQL

Before Class

1. Read Chapter 1 of SQL book and skim Chapter 2

In Class

1. Chapter 2 Notes for “A Guide to SQL”: Use these as you’re reading along and working through the book
2. Chapter 2 SQL scripts in case you become desperate
3. SQL resources
4. Exercise concerning ER diagrams, normalization, and SQL
5. Do all the exercises in Chapter 2 of “A Guide to SQL”.

After Class

1. Make sure you complete all the exercises in Chapter 2 of “A Guide to SQL”.

Other Resources

1. MySQL home
2. SQL School
3. SQL tutorial
4. SQL: An introduction and reference

Bud last edited this October 10, 2005 | Permalink | Comments (0) | TrackBack (0)

SQL 2: Single and multiple table queries (lab)

Work through Chapter 3 and 4

Topics: SQL

Before Class

1. Read Chapter 3 of SQL book
2. Read Chapter 4 of SQL book

In Class

1. Do Chapter 3 of SQL book
2. Do Chapter 4 of SQL book

Other Resources

1. You can use this “House” SQL exercise to test your understanding

Bud last edited this October 12, 2005 | Permalink | Comments (0) | TrackBack (0)

SQL 3: Updating data and creating views (lab)

Work through Chapters 5 and 6 of SQL book.

Topics: SQL

Bud last edited this October 10, 2005 | Permalink | Comments (0) | TrackBack (0)

Quiz on first part of semester

Quiz covering ER modeling, normalization, and sql

Topics: ERD Normalization SQL

Bud last edited this October 10, 2005 | Permalink | Comments (0) | TrackBack (0)