-
Working through the LS SQL Book
-
Learning about table relationships
-
Learning about primary keys and foreign keys
-
Adding constraints
-
Learning about database diagrams
- Conceptual SCHEMA
- Physical SCHEMA
-
One to one
-
One to many
-
Many to Many
-
Cardinality and Modality
-
Converting a 1:M Relationship to a M:M relationship
-
Learning about subqueries
Here are the basics of Join Syntax:
SELECT [table_name.column_name1, table_name.column_name2, ..] FROM table_name1
join_type JOIN table_name2 ON (join_condition);