SQLZoo (original) (raw)

Reference: how to...

1 SELECT

How to read the data from a database.

2 CREATE and DROP

How to create tables, indexes, views and other things. How to get rid of them.

3 INSERT and DELETE

How to put records into a table, change them and how to take them out again.

4 DATE and TIME

How to work with dates; adding, subtracting and formatting.

5 Functions

How to use string functions, logical functions and mathematical functions.

6 Users

How to create users, GRANT and DENY access, get at other peoples tables. How to find processes and kill them.

7 Meta Data

How to find out what tables and columns exist. How to count and limit the rows return.

8 SQL Hacks

Some SQL Hacks, taken from "SQL Hacks" published by O'Reilly

9 Using SQL with PHP on Amazon EC2 servers

Video tutorials showing how to run MySQL, PHP and Apache on Amazon's EC2 cloud servers.

Simpler instructions for students following module INF08104 at Edinburgh Napier University

10 An introduction to transactions

Video tutorials showing how sessions can interfere with each other and how to stop it.

11 Using SQL with C#

Code to connect to a database in Visual Studio.