Database Security
SQL Server
| Beginner
- 6 videos | 44m 20s
- Includes Assessment
- Earns a Badge
A major concern for any database administrator is data security. Explore security considerations for SQL Server databases, how to assign permissions to database objects, and how to back up and restore databases.
WHAT YOU WILL LEARN
-
Describe the main considerations for relational database security
Using smss, identify and describe sql server fixed and user-defined server and database roles, the guest account and how to revoke it
Create, assign, and manage permissions to a sql server login -
List the options available in sql server for database backups and restores
Use sql server to back up databases
Use sql server to restore databases
IN THIS COURSE
-
7m 7sUpon completion of this video, you will be able to describe the main considerations for security of relational databases. FREE ACCESS
-
7m 58sIn this video, you will use SMSS to identify and describe SQL Server fixed and user-defined server and database roles, the guest account, and how to revoke it. FREE ACCESS
-
3. Creating and Assigning Permissions9m 8sLearn how to create, assign, and manage permissions for a SQL Server login. FREE ACCESS
-
4. Overview of Database Backup and Restore8m 55sAfter completing this video, you will be able to list the options available in SQL Server for database backups and restores. FREE ACCESS
-
5. Backing up Databases with SSMS5m 40sLearn how to use SQL Server to backup databases. FREE ACCESS
-
6. Restoring Databases with SSMS5m 33sLearn how to restore databases using SQL Server. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
