| (Powerpoint) | Review of SQL Select Statement |
| (Powerpoint) | Transactions |
You should download the files from the following URL to help you do your HW. These files include the sample database.
http://www.murach.com/downloads/sql5.htm
The following is a document with HW exercises for each chapter. You are required to do all of the problems for each chapter as we complete the chapters.
http://yrosenthal.com/pub/murachsql2005/Exercises.doc
I will post solutions to the HWs as we proceed through the semester.
| Chapter 3 | Chapter 4 | Chapter 5 | Chapter 6 | Chapter 7 |
| Chapter 8 | Chapter 10 | Chapter 12 | Chapter 13 | Chapter 14 |
| Chapter 15 | Chapter 16 | Chapter 17 |
Download SQL Server 2005 Express: http://msdn2.microsoft.com/en-us/express/aa718378.aspx.
| ch01 | ch02 | ch03 | ch04 | ch05 | ch06 | ch07 | ch08 | ch09 | ch10 |
| ch11 | ch12 | ch13 | ch14 | ch15 | ch16 | ch17 | ch18 | ch19 | ch20 |
| ch21 |