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
|