You learnt the following topics in this session:

  • Some basic set operations such as union, intersection and difference.
  • Types of joins: inner joins, left joins and right joins.
  • Writing simple and complex queries involving multiple joins and views.
  • Using ‘union’ and ‘union all’ in queries.

Armed with all this knowledge and experience of writing numerous queries, you are now primed to dive into some of the more advanced features in MySQL. In the next module, you will learn about many of them in great detail.

Report an error