SQL Links / References

SQL Links
ANSI See if you can find SQL standards on ANSI site... available for a fee
Database Journal A broad set of resources on SQL covering major databases as well as SQL
Database Dev Zone Devx pages devoted to database news and tools weighted towards Microsoft
Gentle SQL Great some clear examples of SQL from several databases
ITToolbox General database and SQL resource center
Databases of High Interest and Easy Loadability
Lahman Baseball Database Free (but do contribute), treasure trove of up-to-date baseball stats
Pro Footbal Reference Database Free Pro Football database
Word Web Database Words, Dictionary, Thesaurus for English - fee based
If you have/know a database (free or for a fee) that would be of interest - contact me please and I will post it here
Sites Specializing in news, tutorials and articles on SQL, Databases
DBTA Database Trends and Applications stays close to what is happening in DB
DBWorld All the happenings in the Academic Database community - conferences, papers, etc
Database Modeling Great resource on database modeling tools and DB design methods
Developers Shed MySQL articles, tips, and tutorials including PHP/Perl/Python connections
ProgrammersTutorials As always, a good set of links to SQL tutorial sites
SQLCourse Two sets of SQL Courses elementary and this one, intermediate-good self tests
SQL Recipes Site with advice on SQL query problems
SQL Tutorials Wouldn't you know it- you have to go to PHP site to get good SQL tutorials
TutorGig TutorGigs section of SQL tutorials
W3Schools Good beginning into into SQL which applies to most RDBMS
BI-Business Intelligence and Data Warehousing Sites
DataWarehousing Links Beats DMOZ hands down for richness of DW and OLAP links
DM Review Broad BI and Data Management coverage
DW InfoCenter Like this site, one editor, broad views on Data Warehousing
Intelligent Enterprise Covers BI, data warehousing, and analytics comprehensively
OLAP Report Bible on OLAP news and trends
Predictive Analytics Another strong first start page from Wikipedia
Wikipedia on Data Mining Good place to start for data mining books, info and references
XMLA XML for Analysis, one emerging OLAP analysis standard
Database Methods
AgileDBMethods Agile Database Techniques and Refactoring
Agile UML A UML Profile for Database and Data Modeling
Avoiding Table Mutation Tom Kyte's approach to problem of Table Mutation
Evolutionary DB Design Martin Fowler on Database Design approaches
Information Quality ROI More on Information Quality ROI in Data Quality Management
Database Vendors and their Sites
AQT  Advanced Query Tool accesses DB2, MySQL, Oracle,SQL Server in style
Borland Interbase Builtin versioning RDBMS just getting into clustering and parallel ops
EnterpriseDB PostgreSQL, ebterrise level,adding compatibility and performance features.
freecountry Freecountry has free resources including databases - quite a few.
IBM DB2 IBM's site for DB2
IBM DB2 Cookbooks DB2 SQL topics and tutorials - very extensive
IDUG International DB2 Users Group has DB2discussion forum, articles, events
Mullins on DB2 Chris Mullins site has articles, scripts tips on DB2 and Oracle too
DB2 USA Lots of papers and technical articles on DB2 especially OS390/mainframe version
DB2 Magazine Good discussion of wide rnage of DB2 issues - not just DBA topics
Microsoft SQL Server Microsoft Enterprise RDBMS "borrowed" from Sybase
MySQL Open Source/free RDBMS gets within 80% of transaction speed of DB2, Oracle, etc
Navicat MySQL administrator/query/report writer for Windows, Linux and Mac OS X.
Oracle Cross platform and enterprise caliber RDMS+Server for OLTP and OLAP
OpenSQL.org MySQL & PostGres SQL complete documentation sets
OracleMagazine A good starting off point into OTN-just below
OTN-Oracle Tech Network The first place to get info, docs and a wide set of free Oracle downloads
Oriole Oriole has a good set of Oracle admin scripts
Oracle DBA Scripts Oracle sql and PL/SQL scripts for DBAs
Oracle FAQ Oracle FAQ and a wide range of scripts
Oracle DBAOnCall A good set of scripts and articles on Oracle admin
phpMyAdmin PHP app admins one or more MySQL servers over the web.
PostgresSQL Co-ordinating website for free, OpenSource Postgres SQL database
SQLServerMag News, articles, and tutorials primarily on Microsoft SQL Server
SQLite Small database(750KB), BIG capabilities, free, + part of Adobe AIR & Google Gears
Sybase SQL Anywhere Multiple platforms RDBMS with small footprint for mobile, PDA, & special devices

 Top of Page  Open Sourcery Home Tips & Tutorials  
©Imagenation 2001-2009