Database Security

SQL Server 2014    |    Beginner
  • 6 videos | 44m 20s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 21 users Rating 4.6 of 21 users (21)
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 7s
    Upon completion of this video, you will be able to describe the main considerations for security of relational databases. FREE ACCESS
  • 7m 58s
    In 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
  • Locked
    3.  Creating and Assigning Permissions
    9m 8s
    Learn how to create, assign, and manage permissions for a SQL Server login. FREE ACCESS
  • Locked
    4.  Overview of Database Backup and Restore
    8m 55s
    After completing this video, you will be able to list the options available in SQL Server for database backups and restores. FREE ACCESS
  • Locked
    5.  Backing up Databases with SSMS
    5m 40s
    Learn how to use SQL Server to backup databases. FREE ACCESS
  • Locked
    6.  Restoring Databases with SSMS
    5m 33s
    Learn 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.

YOU MIGHT ALSO LIKE

Rating 4.7 of 250 users Rating 4.7 of 250 users (250)
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 667 users Rating 4.5 of 667 users (667)
Rating 4.8 of 23 users Rating 4.8 of 23 users (23)
Rating 4.0 of 383 users Rating 4.0 of 383 users (383)