Site |
Description |
Chapter 1: Introduction | General References |
http://www.microsoft.com/office/access/ | Microsoft Access |
http://www.microsoft.com/sql/ | Microsoft SQL Server |
http://www.oracle.com | Oracle |
http://www.oracle.com/technetwork | Oracle technology network |
http://www.ingres.com | Ingres |
http://www.sybase.com | Sybase |
http://www.software.ibm.com/data/db2/ | IBM DB2 |
http://www.mysql.com | Free DBMS now controlled by Oracle |
http://www.PostgreSQL.org | A better free DBMS |
http://www.acm.org | Association for Computing Machinery |
http://groups.google.com/groups/dir?sel=usenet%3Dcomp.databases | Questions and sometimes answers on many topics and subtopics |
http://dbforums.com | Discussion group |
http://dbasupport.com | Discussion group |
http://www.devx.com/dbzone/Door/7022 | Discussion group |
http://www.sqlservercentral.com | News group on SQL Server |
http://www.cms.hsss.gov/IDC10 | U.S. government Web site (HHS) with ICD-10 codes. |
http://webopedia.internet.com | Dictionary of computer terms |
Chapter 2: Database Design | Design Documentation |
http://www.rational.com/uml/ | The primary site for UML documentation and examples. |
http://www.iconixsw.com/umlzone.html | UML documentation and comments. |
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#i54330 | Oracle data type descriptions |
http://msdn2.microsoft.com/en-us/library/ms187752(SQL.90).aspx | SQL Server data type descriptions |
http://jerrypost.com/dbdesign | Database design system |
Chapter 3: Data Normalization | Information on Database Design |
http://www.for.gov.bc.ca/isb/datadmin/ | Database Programming & Design magazine. |
http://support.microsoft.com/support/kb/articles/q209/5/34.asp | Introducton to normalization. |
http://www.phpbuilder.com/columns/barry20000731.php3 | Normalization examples. |
Chapter 4: Data Queries | Basic SQL References |
http://www.iso.org/iso/en/stdsdevelopment/tc/tclist/TechnicalCommitteeDetailPage.TechnicalCommitteeDetail?COMMID=160 | ISO SQL committee. |
http://www.jtc1sc32.org | Standards documents |
http://www.wiscorp.com/SQLStandards.html | Free versiosn of draft standards. |
http://www.dbazine.com | Magazine and blogs on SQL. |
http://www.sqlmag.com | Magazine with SQL emphasis. |
http://www.sqlteam.com | SQL hints and comments. |
http://www.sqlcourse.com | Online SQL notes. |
http://www.w3.org/TR/xquery | XQuery reference. |
http://oracle.com/technology/pub/articles/jain-xmldb.html | Oracle XML documentation. |
http://www.aivosto.com/vbtips/regex.html | One regex tutorial. |
http://msdn.microsoft.com/en-us-magazine/cc163473.aspx | Microsoft article with the CLR regex function. |
http://msdn.microsoft.com/library/default.asp? URL=/library/psdk/sql/portal_7ap1.htm | Microsoft SQL Server notes. |
http://www.sqlcourse.com | Introductory SQL help. |
Chapter 5: Advanced Queries and Subqueries | Detailed discussions of SQL |
http://www.acm.org/sigmod/ | Association for Computing Machinery—Special Interest Group: Management of Data. |
http://www.acm.org/dl | ACM digital library with thousands of searchable full-text articles. |
http://www.oracle.com/technology/documentation/database.html | Oracle online documentation library, including SQL Reference. |
http://msdn.microsoft.com/en-us/library/ms130214.aspx | Microsoft SQL Server Books Online reference. |
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp | IBM DB2 reference. |
dev.mysql.com/doc | MySQL reference. |
Chapter 6: Forms, Reports and Applications | Design Guidelines |
http://www.microsoft.com/enable | Accessibility guidelines. |
http://www.unicode.org | Primary site for Unicode information... |
http://www.acm.org/sigchi/ | Association for Computing Machinery—Special Interest Group: Computer and Human Interaction. |
http://www.acm.org/sigcaph/ | Association for Computing Machinery—Special Interest Group: Computers and the Physically Handicapped. |
Chapter 7: Database Integrity and Transactions | Programming Guidelines |
http://www.acm.org/sigplan/ | Association for Computing Machinery—Special Interest Group on Programming Languages (advanced). |
http://support.microsoft.com/support/kb/articles/q115/9/86.asp | Avoiding common database programming mistakes. |
Chapter 8: Applications | Design Background |
http://www.microsoft.com/enable | Microsoft site for accessibility issues. |
http://msdn.microsoft.com/windowsvista/uxguide | Microsoft design guide for Windows. |
http://www.pinpub.com/oracle/tips | Oracle application tips. |
http://www.useit.com | Web site run by Jakob Nielson (a researcher in usability). |
http://helpware.net/mshelp3/intro.htm | Introduction and small examples of Microsoft Help 3. |
Chapter 9: Data Warehouses and Data Mining | Application Guidelines |
http://www.oracle.com/technology/products/bi/olap/index.html | Oracle OLAP process |
http://msdn.microsoft.com/en-us/library/ms173767.aspx | Microsoft Business Intelligence Studio. |
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp | IBM Cognos OLAP tools |
http://www.wintercorp.com/rwintercolumns/SQL_99snewolapfunctions.html | SQL 99 OLAP standards |
Chapter 10: Database Administration | Planning, Performance, and Security |
http://www.dama.org | Data Management organization. |
http://www.aitp.org | Association for Information Technology Professionals organization. |
http://www.acm.org/sigsac | Association for Computing Machinery: Special Interest Group on Security, Audit, and Control. |
http://www.cert.org | Internet organization tracking security topics. |
http://www.dbazine.com/ | Web site for general discussion of DBA issues, covering multiple DBMSs. |
http://www.databasejournal.com | Database security and other database management topics. |
Chapter 11: Distributed Databases and The Internet | Basic Web Construction Help |
http://www.w3.org/ | Web standards body. |
http://msdn.microsoft.com | Search for Microsoft's .NET framework and documentation. |
http://java.sun.com/products/jdbc | Java and JDBC documentation and references. |
Chapter 12: Physical Database Design | Performance and Management |
http://www.sql-server-performance.com | Hints on improving performance for SQL Server. |
http://www.oracle.com/technology/deploy/performance/index.html | Oracle performance tuning. |
http://www.bluerwhite.org/btree | General B-tree information and coding. |