Database Security

SQL Server 2014    |    Beginner
  • 6 Videos | 44m 20s
  • Includes Assessment
  • Earns a Badge
Likes 30 Likes 30
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

COURSE Database Fundamentals: Working with SQL Commands
CHANNEL Database Security
Likes 46 Likes 46  
COURSE Microsoft Azure Infrastructure Solutions: Protecting Data at Rest

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Normalization & Indexes
Likes 32 Likes 32  
COURSE SQL Security Architecture
Likes 94 Likes 94  
COURSE SQL & Concurrency Concepts
Likes 108 Likes 108