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, assignment one 
tue 2 feb data import/excel/access INTRO PDF 1,2, DBD CH 1 Assignment Two
thr 4 feb data import/excel/access DBD  CH2 assignment three
tue 9 feb introduction to relational model DBD  CH3 assignment four
thr 11 feb databases design/normalization DBD CH 4  
tue 16 feb getting started/simple queries DBD CH 5 assignment five
thr 18 feb simple queries, fining specific results DBD CH 6  
tue 23 feb QBE/introduction to EPIC DBD CH 7 assignment six
thr 25 feb QBE/exam review DBD CH 7  
tue 2 mar EXAM ONE    
thr 4 mar introduction to SQL DBD CH8 assignment seven
tue 9 mar ERD/normalization/SQL DB, CH 8  
thr 11 mar ERD/normalization/SQL DBD CH9 assignment eight
tue 16 mar SQL logical operators DBD CH10  
thr 18 mar SQL in exact match DBD CH11 assignment nine
tue 23 mar SQL two tables DBD CH12  
thr 25 mar SQL aggregates DBD CH13  
tue 30 mar NO CLASS SPRING BREAK    
thr 1 apr NO CLASS SPRING BREAK    
tue 6 apr SQL exam review    
thr 8 apr EXAM TWO    
tue 13 apr SQL Intro to Final Project DBD CH14  
thr 15 apr SQL post exam review DBD CH15 assignment ten
tue 20 apr SQL nested queries/Triggers/Forms/Views DBD CH16  
thr 22 apr SQL nested queries/Triggers/Forms/Views DBD CH14, CH 15 CH16  
tue 27 apr SQL Injections DBD CH14, CH 15 CH16 assignment eleven
thr 29 apr SQL IIS Interactions DBD CH14, CH 15 CH16  
tue 4 may work day   assignment twelve
thr 6 may work day    
TUE 18 may FINAL EXAM/PROJECT 2PM to 4 PM