This module introduces the reason and importance of storing your data in a relational database. The module also introduces why SQL Server authentication is preferred to windows authentication, as well as the procedures used in creating a SQL server login.

This module introduces the concept of the contained databases which is an interesting part of SQL server 2014. You will learn how contained databases solve the problem of moving one database from one server to another. You will also learn about Principals which are users or processes allowed to access secured objects.

This module introduces how to implement permissions to keep the server and the database secured. You will learn how SQL server allows for assignment of default schemas for users and groups. You will also learn about the concept of Exception which exists when a code owner has permissions on underlying objects.

This module introduces encryption as one of the most important layers that can be applied to any digital asset. The module will also introduce you to the steps on how to encrypt data by the use of a key or password.