"How To" Guides for databases in general

Database Design
CHAR vs. VARCHAR
Database Tuning
Functions

"How To" Guides for specific database management systems (DBMS)

How To Guides for IBM DB2
How To Guides for MySQL
How To Guides for Oracle
How To Guides for Microsoft SQL Server

SQL

  DB2 MySql Oracle SQL Server
Create Tablespace CREATE TABLESPACE
Create Schema CREATE USER for schema
Create User CREATE USER
Create Role CREATE ROLE
Create Sequence CREATE SEQUENCE
Create Table CREATE TABLE

Data Types

Data Type DB2 MySql Oracle SQL Server
Date and time (date + hh:mm:ss)
Timestamp (date + hh:mm:ss.ff...) TIMESTAMP

Tasks

Task DB2 MySql Oracle SQL Server
Backups
Recovery RMAN

Last updated Tuesday July 15, 2008


Printer-friendly PDF* format:

How To Guides for Databases

This Section

You are currently viewing this page in XHTML 1 Style Sheet* format (* see Clicklets for more infomation). This document is also available in XHTML 1*XML*HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* XHTML 2* XHTML Mobile* WML Mobile* and printer-friendly PDF* formats. This is accomplished with Single Source Publishing, a content management system that uses templates in XSLT style sheets provided by XML Styles .com to transform the source content for various content delivery channels. There is also RDF* metadata that describes the content of this document.