MIS 370 Database Design and Development

 

 

 

 

Syllabus

 

 

PowerPoint Slides

SQL Home Work and Practice

Other Resources

Chapter Audio Files

SQL Server Resouces (Videos and PDF's)

chap 1

chap 7

SQL HW Assignment

DB Solution Manual

MP3 Chap 4 ERM

Video Intro

chap 2

chap 8

Script file for SQL HW

Prob 9 Chap 6

MP3 Normalization

Create Table Video

chap 3

chap 9

Scrip file for SQL practice

Chapter Key Concepts

MP3 Data Admin-1

Create Relationships Video

chap 4

chap 10

Practice Questions for SQL

Top 25 List

MP3 Data Warehouse

PDF: Creating Relational Diagrams In SQL Server

chap 5

chap 13

Answers to SQL practice questions

Data Types

Using Microsoft Visio 2010

chap 6

chap 15

ERD In-Class Solutions

SQL Server Microsoft Assistance Site

Makeup Exam Contact Person

SQL Online Training Site

Online Resource

Video on Using Visio 2013

SQL Code Online Site

 

Database Admin: dgrant2@depaul.edu