SQL Tutorial
From SQLZoo
(Redirected from Main Page)
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.