Introduction to SQL
Selecting and sorting data
Filtering
Ordering and commenting
Aggregating and calculating values
Joins and aliases
Figure 1

Figure 2
This figure shows the relations between the tables and helps to
visualise joining or linking the tables in the database: We will cover
relational database design in the
next episode. In addition to visual above, SQL
Join Types Explained Visually provides visual/animated examples
to help convey to learners what is happening in SQL
JOIN
s.
Saving queries
Database design
Figure 1

Figure 2

Figure 3

Figure 4
