In today's beginners' Database tutorial, we explore a sample database model for a relatively simple system. In it we look at some good examples of the different types of relationships that tables can have in a database. We then look at a couple SQL queries based on this model.
Rob then gently takes you to the world of SQL JOINs and how we can use them to create information from data. We also modify data in a table, through the INSERT, UPDATE and DELETE queries. We finish up with a unique example of how to filter data, through the use of the NOT IN keywords and a nested query.
Table of Content:
- The model
- The queries