| MSBA 504 | ||
| Session Four | ||
| Assignment Due: | ||
| Assignment 3.1 | ||
| Session Materials | ||
| chapter two powerpoint | ||
| kokos db kokos excel | ||
| kokos case kokos solution example susans case | ||
| query practice questions (A4 intro) harkins.accdb employees3.xls | ||
| https://waltonlab.uark.edu/ remote into uark epic (or horizon vm client) | ||
| Session Topics | ||
| SQL, T-SQL | ||
| SMSS | ||
| relational algrebra | ||
| Learning Objectives | ||
| SELECT query (in QBE) | ||
| WILDCARD query (in QBE) | ||
| COMPOUND query (in QBE) | ||
| PARAMETER query (in QBE) | ||
| CALCULATED query (in QBE) | ||
| Session Deliverables | ||
| Schedule | ||
| 1230 | Session Begins | |
| 1230-115 | review of SMSS | |
| 115-220 | working through assignment 3 | |