A database is only as useful as it is safe and available. This final module starts with the most common attack on SQL-backed applications, SQL injection, and how to defend against it, then moves on to controlling who can do what with users, logins, permissions, and roles.
You'll also learn how encryption protects data at rest, and how backup and restore let you recover when something goes wrong, from a bad deployment to a failed disk. Together these are the everyday habits of anyone who looks after a database.
Commands and tools differ between databases, so the lessons mix examples from SQL Server and MySQL. Focus on the ideas and check your own database's documentation for exact syntax. Work through the lessons in order, then put everything to use in the Projects.
How SQL injection works, why it is one of the most common web application vulnerabilities, and how to protect your database from it.
Grouping permissions into roles so access is easier to manage, plus how DENY fits alongside GRANT.
How Transparent Data Encryption protects database files at rest, and the steps to turn it on safely.
Why backups matter and how to back up and restore a database so you can recover from failures.