Masterclass: Hacking and Securing SQL Server (HSS)

Trainings-ID:
sHSSQL

Wichtige Information

This Lighthouse training is held in English!

Inhalt des Trainings

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. In simple words we will hack our systems!

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.

All exercises are based on SQL Server 2019 and Windows Server 2019.

After the course you will be able to test and secure your SQL Server infrastructure and have knowledge for these topics:
  • Hacking SQL Server Infrastructure
  • SQL Server security baseline concepts
  • SQL Server Instance Security
  • Managing Logins and Passwords
  • Encryption in SQL Server
  • Protecting database backups
  • Monitoring and auditing
  • Securing other SQL Server services

Zielgruppen

This is an advanced course on Hacking and Securing SQL Server for Cybersecurity Specialists.
The course is perfect for:
  • Enterprise administrators
  • Infrastructure architects
  • Security professionals
  • Systems engineers
  • Network administrators
  • IT professionals
  • Security consultants

Vorkenntnisse

We recommend good hands-on experience in administering Microsoft SQL Server infrastructure with least 2 years in the field.

Detail-Inhalte

Hacking SQL Server Infrastructure
  1. Discovering SQL Server instances
  2. SQL injection using men in the middle
  3. Capturing SQL credentials using men in the middle
  4. Decrypting SQL Logins passwords
  5. Gaining access to SQL Server on compromised Windows Server
SQL Server security baseline concepts
  1. Defining security objectives
  2. Configuring service accounts
  3. Auditing database permissions
  4. Implementing physical protection
  5. Configuring firewall
  6. Securing client-server communication
SQL Server Instance security
  1. Limiting permissions
  2. Securing CLR
  3. Implementing protection for extended procedures
  4. Protecting linked servers (OPENROWSET)
  5. Securing by using policies
  6. Hiding instance metadata
Managing Logins and Passwords
  1. Authentication options
  2. Implementing password policies
  3. Securing connection strings
  4. Customizing login / user authorization
Encryption in SQL Server
  1. Key management
  2. Code and data encryption
  3. Managing certificates
  4. Transparent database encryption
  5. Encryption in HA and Disaster Recovery
Protecting database backups
  1. Securing backup files
  2. Setting backup file passwords and encryption
  3. Handling keys and certificate backups
  4. Security considerations while restoring to another SQL Server instance
Monitoring and auditing
  1. Login auditing options
  2. Data access auditing
  3. Data Manipulation Language custom auditing
  4. Policy-based management
  5. Forensics case study
Securing other SQL Server services
  1. SQL Server Agent
  2. SQL Server Analysis Services
  3. SQL Server Reporting Services
  4. Azure SQL Database

Downloads

Jetzt online buchen

  • 17.02.-21.02.2025 17.02.2025 5T 5 Tage Online
    von Ihrem Computer Uhrzeiten
    • Trainingspreis  3.600,-
      • Online
  • 19.05.-23.05.2025 19.05.2025 5T 5 Tage Online
    von Ihrem Computer Uhrzeiten
    • Trainingspreis  3.600,-
      • Online

Preise exkl. MwSt.

Sie haben Fragen?

Ihr ETC Support

Kontaktieren Sie uns!

+43 1 533 1777-99

Hidden
Hidden
Hidden
5,0

4 Bewertungen

  • 09.05.2019

    Immer noch ein TopTrainer!

    — Marcus Michael Berka

    Masterclass: Hacking and Securing SQL Server (HSS)

    09.05.2019

    Immer noch ein TopTrainer!

    — Marcus Michael Berka
  • 23.11.2018

    — Johannes Groiß

    Masterclass: Hacking and Securing SQL Server (HSS)

    23.11.2018

    — Johannes Groiß
  • 16.04.2018

    Sehr interessanter Kurs, Trainer war sehr gut

    — Ing. Manfred Schopf

    Masterclass: Hacking and Securing SQL Server (HSS)

    16.04.2018

    Sehr interessanter Kurs, Trainer war sehr gut

    — Ing. Manfred Schopf
  • 13.04.2018

    Sehr guter und informativer Kurs. Der Trainer war sehr kompetent.

    — Markus Skrivan

    Masterclass: Hacking and Securing SQL Server (HSS)

    13.04.2018

    Sehr guter und informativer Kurs. Der Trainer war sehr kompetent.

    — Markus Skrivan

Unsere Empfehlungen für Sie

16.12.2024+2
Ab  3.420,-  3.600,-

SQL Server: Administration

SQL Server Datenbanken aufbauen, verwalten und pflegen

13.01.2025+5
Ab  2.615,-

SQL Server: Data Querying mit Transact-SQL

SQL Server leicht gemacht mit Hands-on-Training

28.01.2025+6
Ab  1.460,-
13.01.2025+3
Ab  2.008,-  2.510,-

Lernformen im Überblick

Mehr darüber