Structured query language - interacts with data in a database eg. in Access database or mySQL or Oracle.
RDBMS: relational database management systerms: the program doing the admin work. They maintain data records and indices in tables. Relationships may be created and maintained across and among the data and tables. Eg. DB2, Oracle, SQL Server, Sybase - which is why they are called relational databases.

RDBMS is the most commonly used database format. Oracle Corporation created the first commercial relational database in 1979. IBM followed suit in 1982 with the SQL Data System. Microsoft was the last major company to jump in with SQL Server 4.2 in 1992. Oracle and Microsoft have the overwhelming market share of commercial database products in use.

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

Benefits of SQL:

• a language that can be learned to query almost any database.
• non-proprietary
• easy

While the following examples work with all databases, some of them will work only with Access and will need minor modifications to work with mySQL and others.

• Working with phpMyAdmin to create sql queries [word doc/ not posted yet]
• Download ArtGallery file and Northwind file [right click and download each file. They have a .sql extension]
• Northwind db [Access db. Right click and download] and Wizards.mdb [also Access db]
• Fundamentals of database design [very important to read before designing a database]. Design principles pdf
• Video of how to create sql queries in an Access db
• Image files for sql [download zip file]

A gentle intro to sql: http://sqlzoo.net/

Attachments:

ArtGallery.sql	[ ]	13 Kb
northwind.sql	[ ]	407 Kb
sqlimages.7z	[ ]	82 Kb
wizards.mdb	[ ]	684 Kb
Northwind.mdb	[ ]	2604 Kb
SQL notes and examples	[ ]	51 Kb
SQL Examples 2	[ ]	28 Kb