SQL Links and 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
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
Sites Specializing in Databases
freecountry Freecountry has free resources including databases - quite a few.
IBM DB2 IBM's site for DB2
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
Developers Shed MySQL articles, tips, and tutorials including PHP/Perl/Python connections
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
Conteporary Tech A series of Oracle Admin and tuning scripts
PostgresSQL HQ Co-ordinating website fo free, OpenSource Postgres SQL database
SQLServerMag News, articles, and tutorials primarily on Microsoft SQL Server
SQL Software Vendors
AQT  Advanced Query Tool accesses DB2, MySQL, Oracle,SQL Server in style
Borland Interbase Builtin versioning RDBMS just getting into clustering and parallel ops
IBM DB2 Cross platform and enterprise caliber database for OLTP and OLAP
Microsoft SQL Server Microsoft Enterprise RDBMS "borrowed" from Sybase
MySQL Open Source/free RDBMS gets within 80% of transaction speed of DB2, Oracle, etc
Oracle Cross platform and enterprise caliber RDMS+Server for OLTP and OLAP
PostgreSQL Another topnotch Open Source database
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-2007