Database Security

SQL Server 2014
  • 6 Videos | 46m 50s
  • Includes Assessment
  • Earns a Badge
Likes 22 Likes 22
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

  • Playable
    1. 
    Overview of Database Security
    7m 7s
    UP NEXT
  • Playable
    2. 
    Exploring Server and User-defined Roles
    7m 58s
  • Locked
    3. 
    Creating and Assigning Permissions
    9m 8s
    FREE ACCESS
  • Locked
    4. 
    Overview of Database Backup and Restore
    8m 55s
    FREE ACCESS
  • Locked
    5. 
    Backing up Databases with SSMS
    5m 40s
    FREE ACCESS
  • Locked
    6. 
    Restoring Databases with SSMS
    5m 33s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

CHANNEL Wintellect SQL Server
Likes 1 Likes 1  
COURSE Advanced Database Security Development
Likes 8 Likes 8  
COURSE Encryption
Likes 69 Likes 69  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Normalization & Indexes
Likes 22 Likes 22  
COURSE Concepts & Conceptual Design
Likes 141 Likes 141  
COURSE SQL & Concurrency Concepts
Likes 79 Likes 79