| MSBA 504 | ||
| Session Six | ||
| Assignment Due: | ||
| Assignment 4 | ||
| Session Materials | ||
| chapter three powerpoint | ||
| https://waltonlab.uark.edu/ remote into uark epic (or horizon vm client) | ||
| Session Topics | ||
| SQL, T-SQL | ||
| SSMS | ||
| relational algrebra | ||
| Learning Objectives | ||
| TWO TABLES OR MORE (in SQL) | ||
| AGGREGATES (in SQL) | ||
| AGGREGATES PART 2 query (in SQL) | ||
| SELF-JOIN query (in SQL) | ||
| SET OPERATORS (in SQL) | ||
| IMPORT database into SQL | ||
| Session Deliverables | ||
| Schedule | ||
| 1230 | Session Begins | |
| 1230-115 | review of SMSS SQL syntax | |
| 115-220 | working through assignment 4 | |