CIS 463 CLASS NOTES

Notes for 1/11/12

INFORMS Online article: Back in Business

AdventureWorks 2005 Business Scenario

AdventureWorks 2005 OLTP ER Diagram  (JPG file)

AdventureWorks 2005 OLTP ER Diagram  (Visio file)

SQL Server Documentation

SQL Server Exercises -- Production

SQL Server Exercises -- Human Resources

Notes for 1/18/12

T-SQL Exercises Parts 1 and 2

Notes for 1/20/12

T-SQL Exercises Part 3 -- Common Table Expressions

Notes for 1/23/12

Stored Procedures

Notes for 2/1/12

XML Notes

XML Sample Files

XPath Testers:   xpathtester.com     whitebeam.org

XPath Tutorial

Notes for 2/8/12

Amazon Web Services

Notes for 2/13/12

Data Visualization (Basic Charts)

Dashboard Exercise

Dashboard Software

Notes for 2/17/12

Dashboard and SQL-to-Chart Mappings

Notes for 2/20/12

Working with Interactive (JavaScript) Google Visualizations

Google Visualization SQL-Mapping Software

Notes for 2/22/12

Google Visualization Mapper

TreeMap with Drilldown using Google Visualization Mapper

Notes for 3/14/12

Data Integration Notes

Microsoft SSIS Tutorial #1

Source data for tutorial

Notes for 3/19/12

Microsoft SSIS Tutorial #2

Source data for tutorial

Notes for 3/21/12

Project Planning Services Data Integration

Files for PPS

Notes for 4/4/12

Analysis Services Tutorial

Notes for 4/9/12

Lesson 4 Start Files

Notes for 4/16/12

Financial Analysis OLAP Project

Notes for 4/20/12

Textbook Ch4 Notes

Induction and Decision Trees

Notes for 4/23/12

Data mining example dataabase

Notes for 4/25/12

Neural Networks