View source for MGIS 331 Database

==Welcome to the MGIS 331 Wiki==

===ER Diagrams ===

[http://www2.cs.uregina.ca/~bernatja/crowsfoot.html Crowsfoot ERD Notation]

[https://www.youtube.com/watch?v=-fQ-bRllhXc ERD Training Video]

=== Relational Models ===

[http://www.dcs.warwick.ac.uk/~hugh/TTM/The-Relational-Model.pdf Relational Model Tutorial]

[http://www.cs.sfu.ca/CC/354/han/material/notes/354notes-chapter3/node1.html Simon Fraser University]

=== SQL & PL/SQL ===

[http://www.w3schools.com/sql/ Great SQL Help]

[http://sqlcourse.com/ SQL Course]

[http://sqlcourse2.com/ SQL Course 2]

[http://sqlzoo.net/ SQL Zoo]

[http://oldweb.uwp.edu/academic/mis/baldwin/sqlplus.htm#SQLPLUS SQLPlus Tutorial] Dead Link

[http://consult.treadsoftlycanada.com/mis/PLSQLTrigger_Notes.pdf PL/SQL Trigger Notes] (Dead Link and Old Oracle Stuff)

=== Unicode===

[http://www.joelonsoftware.com/articles/Unicode.html What is Unicode?]

=== SQL-Loader (Oracle) ===

[http://www.orafaq.com/faq/sql_loader SQL-Loader FAQ] Dead Link and Old Oracle Stuff

== Database Management Systems ==

===Database Design Basics===

[http://office.microsoft.com/en-us/access/HA012242471033.aspx Decent Database Design Basics Article Using Access] Dead Link

[http://www.wrox.com/WileyCDA/Section/Database-Design-Basics.id-129433.html Database Design Basics]

[http://www.databasedev.co.uk/design_basics.html Relational Database Design]

[http://www.dtgeeks.com/journals/article/basic_database_design/ Basic Database Design] Dead Link

=== Oracle ===

[http://download-west.oracle.com/docs/cd/B19306_01/index.htm Oracle 10g Documentation Library]

[http://download-west.oracle.com/docs/cd/B25016_06/doc/dl/index.htm Oracle Developer Documentation]

[http://consult.treadsoftlycanada.com/mis/ORACLEReservedWords.doc Oracle Reserved Words]

[http://consult.treadsoftlycanada.com/mis/Oracle_Set_Up_Notes.pdf Oracle Developer Suite Notes]

=== MS Access === 

[http://office.microsoft.com/en-ca/access/default.aspx MS Access 2007]

[http://www.functionx.com/vbaccess/ VBA for Access]

=== SQL Server === 

[http://www.sqlservercentral.com/ SQL Server Central (need to register / free)]

[http://www.mssqltips.com/tip.asp?tip=1207 Data Import Tips for SQL Server]

[http://msdn.microsoft.com/en-us/library/ms187752.aspx SQL-Server Datatypes]

[http://technet.microsoft.com/en-ca/bb738031.aspx SQL Server 2005 180 Day Evaluation]

[http://www.microsoft.com/sql/editions/express/default.mspx SQL Server 2005 Express Edition]

[http://msdn2.microsoft.com/en-us/express/aa718378.aspx SQL Server 2008 Express Edition (MSDN)]

[http://consult.treadsoftlycanada.com/mis/Microsoft_SQL_Server_2005.pdf SQL Server Notes]
               
[http://cfpayne.wordpress.com/2006/07/23/how-to-import-microsoft-access-into-sql-server-2005/ Import Access to SQL Server 2005]

[http://www.microsoft.com/downloads/details.aspx?familyid=F72C74B3-ED0E-4AF8-AE63-2F0E42501BE1&displaylang=en MS Visual J# 2.0 -- Required for SSMA]

[http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en MS SQL Server Migration Assistant for Access]

=== Source Code ===

[http://www.planet-source-code.com/ Planet Source Code]

==Return [[MGIS_Page|MGIS]]==