Changes between Version 125 and Version 126 of DeveloperGuidelines/Tips


Ignore:
Timestamp:
07/03/13 10:43:21 (12 years ago)
Author:
Fran Boon
Comment:

SQL Fiddle

Legend:

Unmodified
Added
Removed
Modified
  • TabularUnified DeveloperGuidelines/Tips

    v125 v126  
    176176
    177177== SQL ==
     178Test queries on multiple databases:
     179* http://sqlfiddle.com
    178180Basics of Design:
    179  * http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/
    180  * Normalization:
    181   * http://msdn.microsoft.com/en-us/library/ms191178%28SQL.100%29.aspx
    182   * http://www.tomjewett.com/dbdesign/dbdesign.php?page=normalize.php
    183  * http://www.sqlteam.com/article/database-design-and-modeling-fundamentals
    184  * http://msdn.microsoft.com/en-us/library/dd129510%28VS.85%29.aspx
     181* http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/
     182* Normalization:
     183 * http://msdn.microsoft.com/en-us/library/ms191178%28SQL.100%29.aspx
     184 * http://www.tomjewett.com/dbdesign/dbdesign.php?page=normalize.php
     185* http://www.sqlteam.com/article/database-design-and-modeling-fundamentals
     186* http://msdn.microsoft.com/en-us/library/dd129510%28VS.85%29.aspx
    185187Language:
    186  * http://www.intermedia.net/support/sql/sqltut.asp
    187  * http://sqlcourse.com/intro.html
    188  * http://www.w3schools.com/sql/default.asp
    189  * http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
     188* http://www.intermedia.net/support/sql/sqltut.asp
     189* http://sqlcourse.com/intro.html
     190* http://www.w3schools.com/sql/default.asp
     191* http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
    190192More Advanced:
    191  * http://www.tomjewett.com/dbdesign/dbdesign.php?page=intro.html
    192  * http://www.w3schools.com/Sql/sql_join.asp
    193  * http://en.wikipedia.org/wiki/Join_(SQL
    194  * http://www.plus2net.com/sql_tutorial/sql_linking_table.php
    195  * http://en.wikipedia.org/wiki/Entity-attribute-value_model
    196   * http://pypi.python.org/pypi/eav-django
    197  * Object-Relational Mapping: http://www.objectmatter.com/vbsf/docs/maptool/ormapping.html
    198  * Modified preorder Tree Traversal (for large Hierarchical trees): http://www.sitepoint.com/print/hierarchical-data-database/
    199  * GAE Many<>Many: http://arbingersys.blogspot.com/2008/04/google-app-engine-better-many-to-many_30.html
    200  * Django ORM & JOINs: http://slott-softwarearchitect.blogspot.com/2009/07/object-models-and-relational-joins.html
    201  * Especially useful for USB (minimise disk access): http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html
    202 
     193* http://www.tomjewett.com/dbdesign/dbdesign.php?page=intro.html
     194* http://www.w3schools.com/Sql/sql_join.asp
     195* http://en.wikipedia.org/wiki/Join_(SQL
     196* http://www.plus2net.com/sql_tutorial/sql_linking_table.php
     197* http://en.wikipedia.org/wiki/Entity-attribute-value_model
     198 * http://pypi.python.org/pypi/eav-django
     199* Object-Relational Mapping: http://www.objectmatter.com/vbsf/docs/maptool/ormapping.html
     200* Modified preorder Tree Traversal (for large Hierarchical trees): http://www.sitepoint.com/print/hierarchical-data-database/
     201* GAE Many<>Many: http://arbingersys.blogspot.com/2008/04/google-app-engine-better-many-to-many_30.html
     202* Django ORM & JOINs: http://slott-softwarearchitect.blogspot.com/2009/07/object-models-and-relational-joins.html
     203* Especially useful for USB (minimise disk access): http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html
    203204== XSLT ==
    204205 * XPath: http://www.w3schools.com/xpath/default.asp