Demo: Securing Databases
Perform some hands-on demos to secure Azure databases.
We'll cover the following...
We’re familiar with database security, which implies various measures organizations take to ensure their databases are protected from internal and external threats. It includes protecting the database itself, the data it contains, and various applications that access it. We’ve already covered threats and some security measures to protect databases. Here, we’ll perform some hands-on demos to add security features to our databases.
Prerequistes
Before we do some security operations on our database, we have to set up a database. In our case, the resource group name is demo-exercise-gp, the SQL server setup is demoExercisedbserver, and the database name is demoDatabaseName.
You can create your SQL server and then the database using the following CLI command:
az sql server create -l westus -g resourceGroup -n demoExercisedbserver -u educativeAdmin -p educativepassword123+
Once you have the SQL server set up, you can use the command below to create a database. This command requires a resource group, database server, and database name as parameters.
Note: This command will create a General Purpose edition, Gen5 hardware, and two vcore database. ...