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

BOOK Database Security: Problems and Solutions
CHANNEL Database Core Concepts
Likes 146 Likes 146  
CHANNEL Database Backup & Recovery
Likes 70 Likes 70  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Multiple SQL Tables
Likes 122 Likes 122  
COURSE Big Data Interpretation
Likes 1032 Likes 1032  
COURSE Classifying and Collecting Data
Likes 323 Likes 323