Securing Azure SQL Databases

SQL Server 2016    |    Intermediate
  • 10 videos | 47m 56s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 20 users Rating 4.6 of 20 users (20)
Determining how to secure databases in SQL Server 2016 is one of the most important parts of a deployment strategy. Discover how to implement firewalls, authentication, and auditing to ensure Azure SQL database security.

WHAT YOU WILL LEARN

  • Describe the benefits of enabling a sql server firewall
    Demonstrate how to configure sql server 2016 firewall rules
    Demonstrate how to manage existing firewall rules in the azure portal
    Explain how to restrict and secure a connection to a sql server database
    Explain how the connection process redirects machines to a different ip address and port
  • Describe how to implement authentication in sql server 2016
    Describe considerations involving the implementation of contained database users
    Explain the restrictions involving managing logins and users
    Describe how to implement sql database auditing
    Explain how authorization can be used when securing sql server databases

IN THIS COURSE

  • 4m 22s
    Upon completion of this video, you will be able to describe the benefits of enabling a SQL Server firewall. FREE ACCESS
  • 4m 50s
    In this video, you will learn how to configure firewall rules for SQL Server 2016. FREE ACCESS
  • Locked
    3.  Managing Existing Firewall Rules in Azure
    4m 11s
    In this video, you will learn how to manage existing firewall rules in the Azure portal. FREE ACCESS
  • Locked
    4.  Connection Security
    8m 7s
    After completing this video, you will be able to explain how to restrict and secure a connection to a SQL Server database. FREE ACCESS
  • Locked
    5.  TCP Ports
    3m 26s
    After completing this video, you will be able to explain how the connection process redirects machines to a different IP address and port. FREE ACCESS
  • Locked
    6.  Authentication
    5m 7s
    After completing this video, you will be able to describe how to implement authentication in SQL Server 2016. FREE ACCESS
  • Locked
    7.  Contained Database Users
    4m 36s
    Upon completion of this video, you will be able to describe considerations involving the implementation of contained database users. FREE ACCESS
  • Locked
    8.  Managing Logins and Users
    4m 24s
    After completing this video, you will be able to explain the restrictions involving managing logins and users. FREE ACCESS
  • Locked
    9.  SQL Database Auditing
    4m 6s
    After completing this video, you will be able to describe how to implement auditing for a SQL database. FREE ACCESS
  • Locked
    10.  SQL Server Authorization
    4m 48s
    After completing this video, you will be able to explain how authorization can be used when securing SQL Server databases. 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

Course Microsoft Azure Infrastructure Solutions: Data Solutions
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Course Microsoft Azure Fundamentals: Network Security
Rating 4.5 of 191 users Rating 4.5 of 191 users (191)
Course Microsoft Azure Fundamentals: Managing Azure Authentication
Rating 4.6 of 198 users Rating 4.6 of 198 users (198)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Instances & Storage Considerations
Rating 4.5 of 19 users Rating 4.5 of 19 users (19)
Course Stored Procedures
Rating 4.6 of 64 users Rating 4.6 of 64 users (64)
Course CompTIA A+ Core 1: Wireless Networking & Services
Rating 4.6 of 248 users Rating 4.6 of 248 users (248)