Database Languages

SQL Index

IIS Topics: SQL- PHP - Access - ORM - AI

Related Resources - Links to other people's pages covering related content - suggestions welcome.

SQL Dictionary - An online dictionary containing language definitions and conventions.

SQL - Introductions, Definitions of concepts around Relational Databases; The Relational Model of Data; Normalized Tables; Keys; Significant Populations

The Relational Model Of Data - Relational Operations = Data definition and manipulation; Relational Diagrams and representations of Projection, Selection, Union, Intersection, Difference, Joining (with and without constraint).

MySQL Commands - Introduction; Creation of database objects (Databases and Tables); Selection and Projection of Data; Deleting Data; Altering Data; Metadata

Further MySQL - Aliases, Destroying things, Altering Table Definitions, Storing Commands, Sub-string Comparisons, Grouping and Query Exotica.

Multi-Table Queries - Some Set theory, Any and All operators, Sub-queries, Union queries, Intersection using the IN operator, Difference using NOT IN, Joins (Inner and Outer, left right and full) and Views (updatable and not)

Correlation and Existence - Correlation, the EXISTS Operator, some worked examples.

mSQL Housekeeping - Environment commands, Readibility of answer tables