INFO 3240 Enterprise Information Management

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

WeekDatesTopic Areas/Readings/Assignment(s)
0Before Mar 28/29Install SQL Server 2019 (instructions posted on Canvas)

Install Visual Studio 2019 (instructions posted on Canvas for MODULE 2)
1Mar 28/29Introduction, Course Outline, Schedule, Assignments and Case Studies
Mar 30/31MODULE 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]
2Apr 4/5Creating and Altering Tables [Atkinson & Vieira, Chapter 5]

Keys and Constraints [Atkinson & Vieira, Chapter 6]
Apr 6/7The Foundation Statements of T-SQL [Atkinson & Vieira, Chapter 3]
3Apr 11/12Joins [Atkinson & Vieira, Chapter 4]

Adding More to Your Queries [Atkinson & Vieira, Chapter 7]

Views [Atkinson & Vieira, Chapter 10]
Apr 13/14Stored Procedures [Atkinson & Vieira, Chapter 12]

User-Defined Functions [Atkinson & Vieira, Chapter 13]
4Apr 18/19Writing Scripts and Batches [Atkinson & Vieira, Chapter 11]
Apr 20/21PHASE I LAB
5Apr 25/26MODULE 2: Visual Studio Windows Forms

Intro to Visual Studio and the Visual Basic Integrated Development Environment

Creating Forms with Visual Studio
Apr 27/28Creating Forms cont…
6May 2/3Customizing Forms
May 4/5Customizing Forms cont…
7May 9/10PHASE II LAB
May 11/12MODULE 3: Visual Studio Windows Integrated Application and Reports

Creating Reports
8May 16/17Building an Integrated Application
May 18/19MODULE 1: SQL Server Database Design and Programming

Playing Administrator [Atkinson & Vieira, Chapter 21]
9May 23/24MEMORIAL DAY HOLIDAY – NO CLASS
May 25/26Introduction to Azure: SQL Server in the Cloud
10May 30/31PHASE III LAB
Jun 1/2PHASE III LAB cont…
11Jun 6,9FINAL PRESENTATION OF COURSE PROJECT (MW Mon / TTh Thurs)