A Guide to SQL

SQL or Structured Query Language is a database independent language for querying databases. SQL is frequently used in conjunction with web hosting companies who offer some kind of access to SQL compatible database, usually MySQL. The following is a comprehensive overview of SQL. 

What is a Database?

• What is a Database?
• Selecting a Database
• Computer Databases

What is SQL?

• What is SQL?
• SQL Overview
• SQL Scripts
• SQL Quick Start

Installing SQL

• Microsoft SQL Server 2008
• MySQL
• GNOME-DB
• PostgreSQL

Creating Databases using SQL

• Creating a Database Link
• Create a MySQL Database
• Using SQL to Create a Database

Creating Database Tables using SQL

• Create Table Statement
• Creating Tables with SQL
• Managing Tables

Primary & Foreign Keys

• Primary and Foreign Keys
• Using Foreign Keys
• Foreign Key Constraints

Adding Data with SQL

• The Insert Command
• Embedded SQL
• SQL Examples

Deleting Data with SQL

• MySQL Cheat Sheet
• SQL Delete Statement
• SQL Introduction

Updating Data with SQL

• MySQL Update
• MySQL FAQ
• Update Syntax

Retrieving Data with SQL

• SQL Select
• Using Oracle PL/SQL
• Select Statements
• Web Hosting

PHP and SQL

• Installing PHPMyAdmin
• PHP Scripting & MySQL
• MySQL Commands in PHP