Overview What You Will Learn Curriculum Instructor

Course Overview

Are you concerned about the security of your Microsoft SQL Server database?  The importance of securing your SQL Server database cannot be overstated. Ignoring this issue puts your valuable data at risk and leaves you vulnerable to potential breaches and data leaks. Applied Microsoft SQL Server Security is the ideal course to address your database security concerns. 

In this course, you will gain a deep understanding of the latest security features and best practices for Microsoft SQL Server. You will learn how to implement robust authentication mechanisms, safeguard against unauthorized access, and implement encryption techniques to protect your sensitive data. This comprehensive course is specifically designed to equip you with the knowledge and skills necessary to protect your SQL Server environment effectively. Additionally, the course covers advanced security topics such as auditing, monitoring, and securing database backups. With hands-on exercises and real-world examples, you will acquire practical skills that you can immediately apply in your own environment. The course is delivered by experienced instructors who have a wealth of expertise in SQL Server security, ensuring that you receive top-notch training tailored to your needs. 

By the end of the course, you will gain the confidence and expertise to secure your SQL Server database effectively. You will have the ability to identify potential vulnerabilities, implement robust security measures, and proactively defend against threats. Investing in this course will provide you with the peace of mind that your valuable data is adequately protected, mitigating the risks associated with data breaches and unauthorized access. Don't wait any longer to address your SQL Server security concerns. Enroll in the Applied Microsoft SQL Server Security course today and take control of your database security. Your data and your business's reputation are too important to leave unprotected.

What You Will Learn

  • Understand SQL Server Security Architecture.
  • Learn authentication and authorization
  • Familiarize with implementing Data Encryption both at rest and in flight
  • Security Best Practices and configurations
  • Learn about some common Security Threats and Countermeasures
  • Understand about auditing and monitoring your environment

Program Curriculum

  • Getting Started with SQL Server: An Introduction to the SQL Server and Basic Database Concepts
  • SQL Server Architecture
  • Potential Vulnerabilities and Attack Vectors Affecting MS SQL Server
  • Chapter 1 Quiz

  • Preparing the Environment for SQL Server Installation
  • Authentication and Authorization
  • Installation Using Best Practices for Security
  • Post Installation Changes (Surface Area Configuration of SQL Server)
  • Encrypting Connection to Instances (TLS and SSL Certificates)
  • Chapter 2 Quiz

  • Server and Database Level Access (Logins and Users in SQL Server)
  • Password Management
  • Roles and Privileges
  • Contained Databases
  • Privilege Escalation
  • Chapter 3 Quiz

  • Understanding Encryption
  • Managing Certificates
  • Always Encrypted
  • Dynamic Data Masking
  • SQL Injection
  • Chapter 4 Quiz

  • SQL Server Logs
  • Triggers
  • Audits
  • Extended Events
  • Chapter 5 Quiz

  • Backups in SQL Server
  • Backup Encryption (Transparent Data Encryption, TDE)
  • Patches and Updates
  • Chapter 6 Quiz
Load more modules

Instructor

Robert Fon

Robert Fon is an experienced database professional and educator with 7 years’ experience managing database infrastructure and deploying advances database tools in various high security environments. Robert brings a wealth of practical knowledge to this course. With a knack for clear, accessible teaching, you will be guided through each concept with the understanding and insight needed to apply database security measures to your daily security tasks.

Join over 1 Million professionals from the most renowned Companies in the world!

certificate

Empower Your Learning with Our Flexible Plans

Invest in your future with our flexible subscription plans. Whether you're just starting out or looking to enhance your expertise, there's a plan tailored to meet your needs. Gain access to in-demand skills and courses for your continuous learning needs.

Monthly Plans
Annual Plans
Save 20% with our annual plans!

Pro

Ideal for continuous learning, offering extensive resources with 600+ courses and diverse Learning Paths to enhance your skills.

$ 499.00
Billed annually or $59.00 billed monthly
Get Started Now
Start your 7-day trial for $1

What is included

  • 700+ Premium Short Courses
  • 50+ Structured Learning Paths
  • Validation of Completion with all courses and learning paths
  • New Courses added every month
Early Access Offer

Pro +

Experience immersive learning with Practice Labs, CTF Challenges, and exclusive EC-Council certifications for comprehensive skill-building.

$ 599.00
Billed annually or $69.00 billed monthly
Get Started Now
Start your 7-day trial for $1

Everything in Pro and

  • 800+ Practice Lab exercises with guided instructions
  • 150+ CTF Challenges with detailed walkthroughs
  • New Practice Labs and Challenges added every month
  • 3 Official EC-Council Essentials Certifications¹ (retails at $897!)
    Exclusive Bonus with Annual Plans

¹This plan includes Digital Forensics Essentials (DFE), Ethical Hacking Essentials (EHE), and Network Defense Essentials (NDE) certifications. No other EC-Council certifications are included.

Related Courses

  • Hands-on FortiGate Firewall

    Hands-on FortiGate Firewall

    Short Course

    Hands-on FortiGate Firewall

    Security Architecture and Operations

    Learn how to deploy the FortiGate NGFW and how to configure t...

    $99.99

    Intermediate

    3 hr 0 m

  • Hands-on SELinux

    Hands-on SELinux

    Short Course

    Hands-on SELinux

    Security Architecture and Operations

    Learn SELinux Basics: Implement Security Policies, Troublesho...

    $49.99

    Beginner

    5 hr 28 m

  • Complete Bash Shell Scripting

    Complete Bash Shell Scripting

    Short Course

    Complete Bash Shell Scripting

    Security Architecture and Operations

    Automate repetitive tasks with Bash Shell Scripting to save v...

    $79.99

    Intermediate

    18 hr 10 m

  • Installing and Mitigating Linux Rootkits

    Installing and Mitigating Linux Rootkits

    Short Course

    Installing and Mitigating Linux Rootkits

    Security Architecture and Operations

    Understanding the threat posed by rootkits in Linux and poten...

    $59.99

    Advanced

    3 hr 0 m

  • Start Hacking and Making Money Today at HackerOne

    Start Hacking and Making Money Today at HackerOne

    Short Course

    Start Hacking and Making Money Today at HackerOne

    Security Architecture and Operations

    Hack Legally and Get Paid for Your Findings

    $59.99

    Beginner

    1 hr 9 m

  • PowerShell Scripting Essentials: Anatomy of Logging – Developing a Logging Module

    PowerShell Scripting Essentials: Anatomy of Logging – Developing a Logging Module

    Short Course

    PowerShell Scripting Essentials: Anatomy of Logging – Developi...

    Security Architecture and Operations

    How to write a PowerShell module that contains functions to d...

    $69.99

    Intermediate

    6 hr 1 m

  • Machine Learning for Application in Digital Forensics

    Machine Learning for Application in Digital Forensics

    Short Course

    Machine Learning for Application in Digital Forensics

    Security Architecture and Operations

    Unlocking the Potential of Machine Learning: From Theory to P...

    $99.99

    Intermediate

    4 hr 0 m

  • Applied Python Cryptography

    Applied Python Cryptography

    Short Course

    Applied Python Cryptography

    Security Architecture and Operations

    Securing your Python code and protecting your users private i...

    $79.99

    Intermediate

    4 hr 0 m

1 8