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