Hacking and Securing SQL Server
In this workshop you will analyze, learn and practice critical tasks for implementing highly secure SQL Server infrastructure. We’ll start with identifying security needs regarding database servers and look at the most common attack types and use them on ‘out of the box’ installation.
Om utbildningen
Then we will discuss impact of system and network security on databases server. Next we will go through every layer of protection offered by SQL Server with lots of real life examples and hands on labs. At the end we will look at the monitoring and auditing our infrastructure to detect threats and react to them. Additionally, we’ll play with security of other SQL Services and Azure SQL Databases. Our goal is to show and teach you how to protect your precious data in SQL Server environment and how database security mechanisms work. After the course you will be able to test and secure your SQL Server infrastructure. And to get more practice we offer three extra weeks of labs online!
We want you to leave the class with scripts, checklists and practical, ready-to-use knowledge of how to hack, test and secure your SQL Server infrastructure.
This course is a must-go for database administrators, IT professionals and security officers dealing with database servers. The course has the form of an intensive workshop where we make a deep dive inside the SQL Server.
Target Audience and Prerequisites
This course is intended for Database administrators, infrastructure architects, security professionals, system engineers, advanced database developer, IT professionals, security consultants and other people responsible for implementing databases security.
To attend this training you should have good hands-on experience in administering Microsoft SQL Server infrastructure.
Detaljerad information
Module 1: Overview of SQL Server Security (SQL Server 2022 & 2025)
Get an overview of modern SQL Server security capabilities, including new features in SQL Server 2022/2025, architecture considerations, and integration with Azure services.
Module 2: Common Threats & Best Practices for Data Protection
Learn to identify common security risks such as SQL injection and misconfigurations, and apply best practices for protecting sensitive data.
Module 3: Setting Up SQL Server Environment
Understand how to securely install and configure SQL Server, including network setup, ports, and connectivity validation.
Module 4: Securing the Operating System & Network
Explore how to harden the underlying Windows environment, manage permissions, and secure network communication.
Module 5: User Account and Role Management
Manage authentication methods, user accounts, and roles to enforce least privilege and secure access control.
Module 6: Managing Permissions and Data Access
Dive deeper into permissions, securables, and access strategies to control how users interact with data.
Module 7: Data Encryption in SQL Server
Implement encryption techniques such as TDE and Always Encrypted to protect data at rest and in transit.
Module 8: Backup Security
Learn how to secure backups, including encryption and access control, to prevent data leaks and unauthorized recovery.
Module 9: Auditing SQL Server Access and Data Usage
Set up auditing and tracking to monitor access patterns, detect anomalies, and support compliance requirements.
Module 10: Security Monitoring Tools
Use built-in and external tools to monitor SQL Server security, detect threats, and respond proactively.
Module 11: Securing SQL Server Services
Secure SQL Server services and configurations to minimize the attack surface and reduce vulnerabilities.
Module 12: Protecting SQL Server Instances from External Attacks
Apply techniques to protect SQL Server from external threats, including network-based attacks and intrusion attempts.
Module 13: Simulating Attacks and Testing Responses
Simulate real-world attack scenarios to test defenses and improve incident response capabilities.
Module 14: Managing Certificates
Understand how to manage certificates for encryption, authentication, and secure communication.
Mer än en kurs
Vilken kompetens behöver ni om två år — och har ni den idag? Vi hjälper er planera för framtidens kompetensbehov innan luckorna blir ett problem.
Vet ni vilka kompetensgap som finns i er organisation idag? Vi hjälper er kartlägga nuläget och identifiera vad ni behöver bygga för att möta morgondagens krav.
Ladda kortet med utbildningsdagar i förväg och säkra budgeten innan behovet uppstår. Ni får rabatterade priser, flexibel användning och enklare administration — för hela teamet.
Relaterat innehåll
