MGIS 331 Database

Welcome to the MGIS 331 Wiki

ER Diagrams

Crowsfoot ERD Notation

ERD Training Video

Relational Models

Relational Model Tutorial

Simon Fraser University

SQL & PL/SQL

Great SQL Help

SQL Course

SQL Course 2

SQL Zoo

SQLPlus Tutorial Dead Link

PL/SQL Trigger Notes (Dead Link and Old Oracle Stuff)

Unicode

What is Unicode?

SQL-Loader (Oracle)

SQL-Loader FAQ Dead Link and Old Oracle Stuff

Database Management Systems

Database Design Basics

Decent Database Design Basics Article Using Access Dead Link

Database Design Basics

Relational Database Design

Basic Database Design Dead Link

Oracle

Oracle 10g Documentation Library

Oracle Developer Documentation

Oracle Reserved Words

Oracle Developer Suite Notes

MS Access

MS Access 2007

VBA for Access

SQL Server

SQL Server Central (need to register / free)

Data Import Tips for SQL Server

SQL-Server Datatypes

SQL Server 2005 180 Day Evaluation

SQL Server 2005 Express Edition

SQL Server 2008 Express Edition (MSDN)

SQL Server Notes

Import Access to SQL Server 2005

MS Visual J# 2.0 -- Required for SSMA

MS SQL Server Migration Assistant for Access

Source Code

Planet Source Code