| MSBA 504 | ||
| Session Five | ||
| Assignment Due: | ||
| Assignment 3.1 and 3.2 start on A4 | ||
| Session Materials | ||
| chapter three powerpoint | ||
| student_team_DB_CREATE | ||
| student_team_DB_INSERT | ||
| student_team_DB_DROP | ||
| 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 | ||
| SSMS | ||
| relational algrebra | ||
| Learning Objectives | ||
| CREATE TABLE (in SQL) | ||
| INSERT (in SQL) | ||
| SELECT query (in SQL) | ||
| SELECT FROM WHERE query (in SQL) | ||
| LOGICAL OPERATORS (in SQL) | ||
| IN EXACT MATCH (in SQL) | ||
| IN AND NULL (in SQL) | ||
| SORT CALCULATE (in SQL) | ||
| Session Deliverables | ||
| Schedule | ||
| 1230 | Session Begins | |
| 1230-115 | review of SMSS SQL syntax | |
| 115-220 | working through assignment 4 | |