Blog 05 – Week 8

This week we covered more on ‘Group by’ and ‘Having’ as well as users, permissions, procedures and functions.

Users and permissions control who is allowed to do what in the database, the default user being ‘root’ with full control. This allows you to keep certain users from having access to things that they should not have. For example, you might disallow some users from being allowed to run certain procedures or functions.

Procedures and functions allow for the controlled execution of SQL code at a specified point in time (when they are called). For example adding a new set of data to the database.