DU Logo

Kellie B. Keeling

Cow Spots
Stats Dairy LogoStats Dairy Logo



Stats Dairy has a carefully regulated schedule that it must follow.

INFO 3240 Enterprise Information Management
Syllabus: INFO 3240 Enterprise Information Management

WK Dates Topic Areas/Readings/Assignment(s)
0 Before Mar
28/29
Install SQL Server 2019 (instructions posted on Canvas)
Install Visual Studio 2019 (instructions posted on Canvas for MODULE 2)
1 Mar 28/29

Mar 30/31
Introduction, Course Outline, Schedule, Assignments and Case Studies

MODULE 1: SQL Server Database Design and Programming
What Makes up a SQL Server Database [Atkinson & Vieira, Chapter 1]
Learning the Tools of the Trade [Atkinson & Vieira, Chapter 2]
2 Apr 4/5


Apr 6/7
Creating and Altering Tables [Atkinson & Vieira, Chapter 5]
Keys and Constraints [Atkinson & Vieira, Chapter 6]

The Foundation Statements of T-SQL [Atkinson & Vieira, Chapter 3]
3 Apr 11/12



Apr 13/14
Joins [Atkinson & Vieira, Chapter 4]
Adding More to Your Queries [Atkinson & Vieira, Chapter 7]
Views [Atkinson & Vieira, Chapter 10]

Stored Procedures [Atkinson & Vieira, Chapter 12]
User-Defined Functions [Atkinson & Vieira, Chapter 13]
4 Apr 18/19

Apr 20/21
Writing Scripts and Batches [Atkinson & Vieira, Chapter 11]

PHASE I LAB
5 Apr 25/26



Apr 27/28
MODULE 2: Visual Studio Windows Forms
Intro to Visual Studio and the Visual Basic Integrated Development Environment
Creating Forms with Visual Studio

Creating Forms cont…
6 May 2/3

May 4/5
Customizing Forms

Customizing Forms cont…
7 May 9/10

May 11/12
PHASE II LAB

MODULE 3: Visual Studio Windows Integrated Application and Reports
Creating Reports
8 May 16/17

May 18/19
Building an Integrated Application

MODULE 1: SQL Server Database Design and Programming
Playing Administrator [Atkinson & Vieira, Chapter 21]
9 May 23/24

May 25/26
MEMORIAL DAY HOLIDAY – NO CLASS

Introduction to Azure: SQL Server in the Cloud
10 May 30/31

Jun 1/2
PHASE III LAB

PHASE III LAB cont...
11 Jun 6, 9 FINAL PRESENTATION OF COURSE PROJECT (MW Mon / TTh Thurs)

Stats Dairy provides its cows with plenty of extra nourishment.

INFO 3240 Enterprise Information Management
Data Camp

The Managing Operations Officer can be contacted for additional information.

Office Hours
Mon, Tue, Wed, Thu 9:20-9:50am OR Click to Schedule an Appointment
The Office 365 Bookings system interacts directly with my calendar and will list open times both in person in Daniels 590 and on Zoom. It will allow you to make an appointment up to 2.5 hours before the scheduled time.

Class Room & Times
INFO 3240 Enterprise Information Management
Section 3 M/W 10a-11:50a MRH 006
Section 2 M/W 12p-1:50p MRH 006
Section 1 T/Th 10a-11:50a MRH 006

Department of Business Information & Analytics  |  Daniels College of Business  |  DU Home Page

© 1995-2022 K.Keeling