SQL


 

Access SQL

 


Dates and Times in Access
Microsoft Access Misc. Tips
DevGuru Jet SQL Quick Reference		 Access query language elements
Access date formats
String Manipulation Functions in Access
Access SQL




Books Online




SQL Server 2000 Books Online Getting Started with SQL Server Books Online




Columns




Joe Celko's columns at DBMS magazine about SQL John Paul Ashenfelter's columns




Data Modeling




The Importance of Data Modeling Data Modeling




Data Warehousing




Data Warehousing (Microsoft defines 6 of its major components)
Data Warehousing and Online Analytical Processing (OLAP and OLTP are defined)
English Query
Meta Data Services Fundamentals		 Data Transformation Services (DTS) in Microsoft SQL Server 2000
The Data Warehousing Information Center has an introductory page Getting Started with Data Warehousing.
Microsoft SQL Server 2000 Analysis Services Operations Guide




FAQs




SQL FAQ
Oracle SQL FAQ Part of the large Oracle FAQ site
ANSI SQL FAQ - Tek-Tips		 MySQL FAQ
SQL FAQ.doc

 

 

Forums & Discussions

 

 

The Case for the Surrogate Key
Tek-Tips ANSI SQL forum		 Top 3 records query for any database The Case for the Surrogate Key Discussion on the SQLTeam.com forum
Immerse yourself in SQL Server - is a Q&A session between administrators and major experts.




IBM




SQL Reference IBM Red Brick Warehouse 6.3

 

 

Magazines, Journals & Major Pages

 

 

SQL Server Performance
SQL Server Professional
SQL Server Magazine
Database Journal
SQL Server Central
SQL Team has articles on Database Design.		 Data Warehouse
SQL Monster
SQL Skills
Windows IT Pro / SQLServer
SQL Dev
SQL Skills 




Microsoft




SQL Server 2000 Resource Kit
MS's Main SQL Server Page
MS's Main MSDN SQL Server Page		 MS's SQL Server Developer Center
SQL Server 7.0 Resource Guide
Microsoft SQL Server 2000

 

 

MySQL

 

 

MySQL - the latest information about MySQL is available on the web here
PostgreSQL vs. MySQL
dev.mysql.com		 Reference Manual
Error Codes & Handling

 

 

Oracle

 

 

Differences Between Oracle and MS SQL Server Report Subtotals and Totals Using Select ROLLUP in Oracle
Performing Top-N Queries in Oracle




Other Major References




SQL Server 2000 Survival Guide
Transact-SQL Reference (Microsoft's MSDN Site)
SQL Server 2000 Survival Guide.doc
System Stored Procedures
Fluffy Cat SQL Reference and Example Site		 eSQL Language Reference discusses the SQL that can be passed to Access
DevGuru Transact-SQL Syntax Charts
Schema Mania / jkl / booksonline / SQLBOL70 is a huge reference to SQL 7.
SQL Coding




Scripts

 

SQL 7.0 Scripts

 

Tip & Article Repositories




SQL Wiki
MySQL Documentation
 Dot Net John / SqlServer		 Sybase Transact-SQL User's Guide
Rules to Better SQL Server Databases
SQL Server Development Techniques and Scripts



Back to Mike Beaver's Hypnotherapy Home Page