HOME
 
SYLLABUS
 
SCHEDULE
 
LECTURE SLIDES
 
LECTURE FILES
 
LECTURE VIDS
 
TIMELINES
 
ASSIGNMENTS
 
GRADE DATABASE
 
RESOURCES
 
 
 
LINK TO UARK EPIC

 

Tentative Schedule for ITMG 320 Spring 2021
note subject to change
 

USD FINAL EXAM SCHEDULE Spring_2021

Date TOPIC READINGS ASSIGNMENT
tue 26 jan Intro to Class    
thr 28 jan into to database/visualization INTRO PDF 1,2, DBD CH 1, CH2, CH3,  assignment one 
tue 2 feb data import/excel/access INTRO PDF 1,2, DBD CH 1, CH2, CH3,  Assignment Two
thr 4 feb data import/excel/access DBD CH 1, CH2, CH3, CH4, CH6 assignment three
tue 9 feb introduction to relational model DBD CH 1, CH2, CH3, CH4, CH6 assignment four
thr 11 feb databases design/normalization DBD CH7, CH 8 CH9  
tue 16 feb getting started/simple queries DBD CH7, CH 8 CH9 assignment five
thr 18 feb simple queries, fining specific results DBD CH7, CH 8 CH9  
tue 23 feb normalization/QBE/into toSQL DBD CH7, CH 8 CH9 assignment six
thr 25 feb normalization/QBE/into toSQL DBD CH7, CH 8 CH9  
tue 2 mar EXAM ONE DBD CH7, CH 8 CH9  
thr 4 mar ERD/introduction to SQL DBD CH7, CH 8 CH9 assignment seven
tue 9 mar SQL select where DBD CH7, CH 8 CH9  
thr 11 mar SQL logical operators DBD CH7, CH 8 CH9 assignment eight
tue 16 mar SQL logical operators DBD CH7, CH 8 CH9  
thr 18 mar SQL in exact match DBD CH7, CH 8 CH9 assignment nine
tue 23 mar SQL in exact match DBD CH11, CH 12 CH13  
thr 25 mar SQL in and null DBD CH11, CH 12 CH13 assignment ten
tue 30 mar NO CLASS SPRING BREAK    
thr 1 apr NO CLASS SPRING BREAK    
tue 6 apr SQL in and null DBD CH11, CH 12 CH13  
thr 8 apr EXAM TWO DBD CH11, CH 12 CH13  
tue 13 apr SQL in exact match DBD CH11, CH 12 CH13 assignment eleven
thr 15 apr SQL in and null DBD CH14, CH 15 CH16  
tue 20 apr SQL sort and calculate DBD CH14, CH 15 CH16 assignment twelve
thr 22 apr SQL aggregate DBD CH14, CH 15 CH16  
tue 27 apr SQL aggregates pt II DBD CH14, CH 15 CH16 assignment thirteen
thr 29 apr SQL self-joins DBD CH14, CH 15 CH16  
tue 4 may Business Intelligence   assignment fourteen
thr 6 may Business Intelligence    
TUE 18 may FINAL EXAM 2 PM to 4 PM