"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 Apache Derby
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

Next: Summary 

Home > Computers > Summary

Viewing mobile website page. Switch to WML or Full HTML